K2 blackpearl

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 

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

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?

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?

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?

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.

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

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. 

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

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

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. 

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 

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 

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 ?

Hi All, I currently have a workflow that has an activity that starts on a dynamic datetime field. The activity starts at the correct time, however the Event Code within the activity isn't being executed. I'm not too sure why it isn't being executed, there is an if statement within the code to check if field A == 'Y' then K2.ExpireActivity("Activity Name"); The activity name does exist within the workflow Suggestions would be most appreciated Thanks.

Hello All, Assume, We have about 10,000 users and 500 forms created. Would like to control the process right (start, view, view/participate). What is the best approach to managing permissions? Now you have process * users against permissions combination. I don't want to import users to each process to provide rights. Each process has different set of permission as the process falls in the different department in an organization. One option can be creating AD groups, Is there any other best option available out there in K2. Thanks.

Hello All,I'm implementing a custom user manager, and I've done it as described here : https://help.k2.com/onlinehelp/k2blackpearl/icg/4.7/default.htm#Configure/UM-Changing.htm#RefreshUMc  which is working fine, I can authenticate in the workspace using the new security label and retrieve the users, but I noticed that if I open the managed users worklist I do not see the subordinatesm, running the Smartobject methos "GetUsers" I noticed that in the manager field I get the Distinguished name instead the user name, and If I run the "Get User Details" method I get it correct, the manager's user name. This is my LDAP Mapping<K2LdapMapping K2Name="Manager" FullOnly="true" LdapName="manager" ObjectType="System.String" SearchQuery="(&(objectClass=Person)(objectCategory=User))" SearchResultProperty="samAccountName" /> I wonder someone knows a way to set and retreive the manager's user name instead the distiguished name in the "Get Users" methos os the User SO from URM service  

Hi Guys, Could i use Activity Instances Grid without workflow instances grid?  and how to set the value of the workflow instance ID when execute activity instances grid control's run grid method. Best, 

Hi all.I am tring to deploy packege first time after updating to black pearl version 4.7 (4.16060) i recive exeption that unclear to me:System.IO.IOException: I/O error occurred.at SourceCode.ComponentModel.PackageManagerService.ServicePackage.GetStream(Uri itemUri, FileMode mode)at SourceCode.ComponentModel.FileItem.OpenRead()at SourceCode.Runtime.Services.Workflow.WorkflowDeploymentService.Deploy(IDeploymentContext context)at SourceCode.Deployment.Runtime.ServerSession.AsyncDeploy() Can you please provide me direction how can I solve this?Thank you in advance

Hi, Got a Toolbar button on a list. The button background is the same as the list, i want it to standout. So i changed the background of the button, but then it's completely flat and when the user hovers over it, nothing moves. Is there a way to make the Tollbar Button Background/Font colour change as the mouse hovers over it? I like my stuff to be user friendly :-)

Hello All, Is it possible to create a form displaying users in a AD group and than adding/ removing users from group from form. PLease guide 

Client event destination is set and assigned but unable to find in worklist.The assigned destination user on impersonation and fetching worklist ,not able to see the task.Have a simlar client event which works but only this seems to not work.Any assistance here is greatly appreciated

Hello Team, We as team working in isolated development environments, each developer have their own development server which contains a K2 development environment; K2, SQL Server, Visual Studio and so on. Visual Studio is where our expertise area and TFS we are using for version control/source control. We have requirement to use TFS for Application Lifecycle Management for K2 SmartForms, which allows us to track requirements, code, issues, fixes, history, WorkItems and so on. Follwoign are our requirements: (1)    Include SmartForms in TFS(2)    Share SmartForms definitions for use in other environments(3)    Track requirements/changes(4)    Maintain history of changes, WorkItems(5)    Build Automation that next stet leads to Test Automation Please advice on above mentioned requiremnts and in summary a way to use SmartForms with TFS(2013).

   Bonjour,    Je cherche a établir une connexion à partir d'un client (SourceCode.Workflow.Client) vers une instance K2.    Le client se trouve sur ma même machine que K2    Dans la string de connexion il est demandé d'entrer le host de K2.    Où puis-je trouver cette valeur?    G essayé     - "localhost" (port 80 et 5252)   - "127.0.0.1" (port 80 et 5252)   - "IP Du Serveur" (port 80 et 5252)   - "k2workspace-xxx.be"  (port 80 et 5252​)    Le message d'erreur m'indique à chaque fois: Unable to resolve address No such host is known.    Toute suggestion sera la bienvenue. Cordialement.Claude

Hi guysI have a procedure that return start date and end date as follows: create procedure [GetWeekdays](@Date Date)AsAsDeclare @Fri datetime, @Mon datetimeset @Fri=(SELECT DATEADD(d, 6- DATEPART(dw, @Date), @Date))set @Mon= (SELECT DATEADD(wk, DATEDIFF(wk,0,@Date), 0) MondayOfCurrentWeek)DECLARE @StartDate DATE = @Mon, @EndDate DATE = @FriSELECT date FROM ( SELECT DATE = DATEADD(DAY, rn - 1, @StartDate) FROM (SELECT TOP (DATEDIFF(DAY, @StartDate, DATEADD(DAY,1,@EndDate)))rn = ROW_NUMBER() OVER (ORDER BY s1.[object_id])FROM sys.all_objects AS s1CROSS JOIN sys.all_objects AS s2ORDER BY s1.[object_id] ) AS x ) AS y  inputed: 2017/12/04Results:2017/12/042017/12/052017/12/062017/12/072017/12/08 How can I implement this procedure in such a way that when I press the Button from a Itemview a subview  show up with this results. TIA.