Skip to main content

K2 blackpearl

FORUM POSTS AND DISCUSSIONS

  • 2,177 Topics
  • 5,428 Replies
2177 Topics
B
Bugmeister
posted in K2 blackpearl
SQL Server Stored Procedure Parameters with Defaults

Hi, I am trying to interface with one of our legacy systems and call a pre-existing SQL Server stored procedure which is rather generic and has many parameters (most unused) with default values assigned (I.e. assigned as part of the SP definition in SQL Server) to make it more useful.  Anyway the stored procedure shows up under our K2 SQL service objects with all parameters being "Required".  How can I change the service object so the parameters with defaults aren't showing up as "Required"?  Or is there a way in a smart object's service object method parameter bindings to just say use the default (i.e. I noted there is a SCNULL value I can pass, is there something similar to SCDEFAULT?). Thanks in advancePeter

7
Nicolaas
2 years ago
N
npatelRookie
posted in K2 blackpearl
How to get K2 Worklist Data for all the users?

Hello there, Might be similar question is very popular & asked several times but if someone can suggest a way to achieve this by any way then it'd be very helpful. What I want:I want to have dump of worklist data for each user as we're going to send this data to another system for use.(Example: if I query that final dump with where userid = 'xyzuser1' then it should be able to give me tasks for that user.)Things to consider:=> I'm using      - Users      - K2 Roles (dynamic also)      - AD-Groups in K2 Roles (optional - I'll find a workaround for this)=> I'll refresh this data & get the latest dump at certain interval (let's say 10 minutes) What I've tried:I'm doing an SQL query. I tried with joining the K2 tables & it is giving me worklist data but only problem is with K2 Roles (dynamic). It gives me participant as role name instead of users.This is where I'm stuck. I don't know how to get the role users (for dynamic roles only). I really want to go for SQL query way

4
V
2 years ago
F
foo_yk
asked in K2 blackpearl
How to display only the latest result instead of all result in a list view

Dear all, I have a list view, but it is showing all the record. How to display only the latest result instead of all result in a list view? My user only need to see the latest result instead of all. Thank you.

5
B5A7
3 years ago
P
Paull
posted in K2 blackpearl
Who can tell me where to download k2.net 2003 to K2 blackpearl migration utility

As the title, thank you.  

1
MillaZ
3 years ago
P
PraveenBoralka
posted in K2 blackpearl
Health report

Hello All,   I want to generate health report for K2 application or K2 server or K2 system.. Please let me know how to get these health reports...on daily basis

1
K
3 years ago
Y
yingjie
posted in K2 blackpearl
Smartform 4.6.11 State Rule Not Found

When we are using Smartform 4.6.11, in the non-Base state, we cannot see the rules in the Base state (other states inherit the Base state by default).The rule code actually exists, but it cannot be displayed in the front-end designer (it cannot be modified later). (The rule data exists in the K2 database, and the rule will also be triggered after the form is executed).May I ask if there is a corresponding patch solution for this anomaly, because the system continues to operate stably, and we don't want to take the risk to upgrade it to the latest version.

2
Y
3 years ago
X
Xuber_TGB
posted in K2 blackpearl
How to determine the DB version of a K2 DB

Hi, Our customer recently installed the following MS updates: 1.kb50018492.kb50036363.kb50036964.kb5003697 Now the K2 service is failing to start. When I look at the HostServer log files I see this, which apparently means the K2 DB version isn't matching the installed version:"45817334","2021-06-16 14:19:26","Error","General","0","ErrorMessage","SourceCode.Hosting.Server.Runtime.HostLoadBalancedServerManager.Poll","0 System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'hServerUpdate' expects parameter '@EnvironmentGUID', which was not supplied.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,

1
K
3 years ago
U
Umamaheswar
posted in K2 blackpearl
We are upgrading Database Sql 2012 to Sql 2014, the connection to the database needs to be updated.

Dear All,As part of Sql server upgrade, we are migrating databases to new server.so far we have done below activities.1. Create a backup of the K2 Database2. Stop the K2 Blackpearl Service3. Restore K2 Database to new sql server 2014.we are facing issue when we tried starting K2 blackpearl server 4.6.11.For exception please find below details:Please create a master key in the database or open the master key in the session before performing this operation.The key 'SCSSOKey' is not open.  appreciate your help in fixing above issue. Thanks 

2
K
3 years ago
D
dadkindRookie
posted in K2 blackpearl
Workdesk: Start specific app

Hello,We are using Workdesk to allow users to select from various applications. Our current URL for our workdesk is: https://bpm.placer.ca.gov/Runtime/Runtime/Form/com.K2.App.Workdesk.Form.Workdesk/ We want to be able to pass a parameter that will allow the user to load Appliation2 or App3 instead of the default application on the workdesk.  What parameters can be set to override the default application on load? Thanks,-tomas

2
R
3 years ago
S
SanaShah
posted in K2 blackpearl
PDF has extra blank page

Hi When my form is converted to a PDF, it adds a blank page at the end.  It's a small form and all the content is shown on the first page.  Any ideas on how I can remove this blank page?

3
F
3 years ago
P
PaulaB
posted in K2 blackpearl
Ongoing Replication from Amazon RDS for SQL Server Using AWS Database Migration Service

We are migrating our on-prem K2 servers (Blackpearl) to an AWS Amazon Managed Services (AMS) data center. What options are available for continuously updating the new destination K2 database (the migrated K2 proprietary SQL Server database) with source (on-prem) SQL Server K2 database, transactions from the time period between the new PROD destination environment being restored (and reconfigured), through the crossover to the new PROD go-live environment in AWS? Are there existing continuous replication utilities available? AWS has an 'Ongoing Replication' product for AWS RDS SQL Server databases using AWS Database Migration Service (AWS DMS) described here: Introducing Ongoing Replication from Amazon RDS for SQL Server Using AWS Database Migration Service ...  .....Has anyone used this tool or others like it?

0
P
3 years ago
P
PaulaB
posted in K2 blackpearl
Ongoing Replication from Amazon RDS for SQL Server Using AWS Database Migration Service

We are migrating our on-prem K2 servers (Blackpearl) to an AWS Amazon Managed Services (AMS) data center. What options are available for continuously updating the new destination K2 database (the migrated K2 proprietary SQL Server database) with source (on-prem) SQL Server K2 database, transactions from the time period between the new PROD destination environment being restored (and reconfigured), through the crossover to the new PROD go-live environment in AWS? Are there existing continuous replication utilities available? AWS has an 'Ongoing Replication' product for AWS RDS SQL Server databases using AWS Database Migration Service (AWS DMS) described here: Introducing Ongoing Replication from Amazon RDS for SQL Server Using AWS Database Migration Service | AWS Database Blog  .....Has anyone used this tool or others like it?

0
P
3 years ago
W
WilliamHing
posted in K2 blackpearl
.Net Core cannot connect to K2 Blackpearl

I need to connect ASP.Net Core application to K2 Blackpearl. I tried the nuget package K2.Workflow.Client but it throws a BadImage error. It seems the package works with .Net but not .Net Core. Could I know if there is an equivalent package for .Net Core.

0
W
3 years ago
S
Sharpharp1Scout
asked in K2 blackpearl
Minimum and Maximum Word Count on Text Area Control?

Hi, I need to set the Text Area to accept a Word count as follows:Minimum Words: 1000Maximum Words: 2000 Is there a way to set this up on a Text Area? If so, can the word count also be displayed alongside the TextArea so the user knows how many words they have written so far? Thanks

15
A
3 years ago
M
MRREA
posted in K2 blackpearl
Work flow results to a Flat File rather than emailed

Hello, currently we have a K2 workflow that is currently emailing the results from the workflow.  We would like to disable that portion of the code and rather than email creates a flat file with the same results and place it on the network share drive.   Any help would be greatly appricated. 

0
M
3 years ago
A
alexhabererScholar
posted in K2 blackpearl
Issues opening View Flow link from Reports, but not Instances View Flow button.

Hi, When I attempt to open "View Flow" link from "Management Console > Workflow Server > Workflows > Reports > View Flow" The URL I get redirected to is below which works.https://forms.usd.edu/Designer/K2Workflow/Viewflow.aspx?procInstId=932 I can take that URL and replace the ending number with that pulled from the first URL to get the ViewFlow to work. I'm assuming I have a configuration somewhere incorrect, but can't be sure where it is. Any advice is appreciated, Thanks

5
A
3 years ago
I
IPO
posted in K2 blackpearl
EndPoint Service Broker build Error

HI,I am creating an endpoint service broker using VS2010 to integrate with the Microsoft Dynamics GP eConnect with the Smartform using the Smartobject. When I try to build a project, I am getting the following error. If I change the CPU to x86 in Configuration Manager, K2 reference for 'SourceCode.HostClientAPI.dll' and 'SourceCode.Workflow.Client.dll' does not work. How to handle this issue. Thanks.  C:WindowsMicrosoft.NETFrameworkv4.0.30319Microsoft.Common.targets(1605,5): warning MSB3270: There was a mismatch between the processor architecture of the project being built "MSIL" and the processor architecture of the reference "Microsoft.Dynamics.GP.eConnect, Version=12.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=AMD64", "x86". This mismatch may cause runtime failures. Please consider changing the targeted processor architecture of your project through the Configuration Manager so as to align the processor architectures between your project and refere

1
B5A7
3 years ago
M
mikebroadway
posted in K2 blackpearl
No environments shown in environment library

While having an issue where one user couldn't see workflow tasks, I followed the steps in the forum post:User unable to see worklist tasks   This required adding the domain or everyone into the security settings of our environment.  After rebooting the server, I no longer have access to the environment page and all users are reporting errors.  I'd like to undo the settings to see if this would correct the issue, but I can't figure how to get to that setting to change it. 

0
M
3 years ago
B
BatesyRookie
posted in K2 blackpearl
Div or script for a spinner doesn't work on a form when there is an editable list view

I am trying to get a spinner from a div and script using two literal data labels (Spinner works when i closk start button and close when i click close button)  div I used  <div id="wait" style="display:none;width:69px;height:89px;position:absolute;top:50%;left:50%;padding:2px;"><img src='/Runtime/Styles/Themes/Lithium/RuntimeTheme/*personal details removed*' width="64" height="64" /><br>Loading..</div> To Show:  <script>$("#wait").css("display", "block");</script> To hide: <script>$("#wait").css("display", "none");</script> Everything works well if there are item views or normal list views in the form. But when I put an editable list view to the same form the code doesnt works?? or it doesnt show the spinner.  please refer the attached. Thanks Any Idea why?? Thanks 

3
B
3 years ago
M
mdowney
posted in K2 blackpearl
K2 Compatibility Support Matrix

Does anyone know where I can find the K2 Compatibility Support Matrix (used to be available at: https://help.k2.com/k2compatibilitysupportmatrix )We need a document to confirm that we are currently on 4.7, as when we check all programs it does not list 4.7 as the version but instead has 4.16060.2000.x 

3
OlivierC
3 years ago
L
LastSamuraiRookie
posted in K2 blackpearl
Is .NET core supported or not for using k2 black pearl 4.7 API ?

Is .NET core supported or not for using k2 black pearl  4.7 API ?Is it possible to make integration between k2 black pearl 4.7 and .NET core for using K2 black pearl 4.7 assemblies and API from a .NET core Application ?

0
L
3 years ago
S
Sharpharp1Scout
asked in K2 blackpearl
Text Area Watermark Font Size?

Got a few text boxes and text areas on a List View and have added Watermarks to all boxes and set the text to Arial 12 -> The Text Boxes show the watermark in Arial 12 -> The Text Areas show the watermark in tiny Arial 8 (i.e. much smaller) Why is this and how do i get the Text Area Watermark to be Arial 12? If i type in the Text Area, the font is indeed Arial 12, so the problem is the Watermark font size... Bug????

3
A
3 years ago
C
Capz
posted in K2 blackpearl
Multi Value. What does it look like?

What does Multi Value type look like when entered into Smart Object tester? I am trying to run User Role Manager Service -   GetRolesUsers

3
C
3 years ago
H
HARISHJALLIGAMA
posted in K2 blackpearl
QR Code reader

Hello AllWe are in 4.7 versionWe will have a PDF in which QRCode exist we need to read QR codeHow can we achieve this in K2Do we have QRCode reader control in K2?

4
P
3 years ago
T
toddwalkerRookie
posted in K2 blackpearl
How to update custom task URL

I have a legacy K2 blackpearl workflow that uses a custom task item URL pointing to a custom ASP.NET application. How can I use the API to update this URL on existing active workflows, say if the server name part of the URL needs to change or if I wanted to change it from http to https?

7
D
3 years ago

View our Community Site Map

Nintex Community Sitemap

Badges

Show all badges
Terms & ConditionsCookie settings