K2 blackpearl

We have nearly 50 smartforms and workflows and I need to get a count of how individual workflow instances were initialized since the beginning of time.Any guidance would be much appreciated. Thank you.

I know the old legacy K2 Black Pearl can create files in the workflow but can the newer version of K2 Five workflow be used to create a txt file with a forms based workflow? Thanks Dave

Hi,I am using a listview to display specific records. Each record is reference from KPI table wherein it changes the background color of column with specific color if it’s overdue. Could be blue, green, yellow and red.When exported to excel, the column color is not included which is an important feature to show significant value in the reports. The report is with corresponding monetary value.If anyone have done this, kindly share or at least advice.Thank you,   

Hi,I'm having trouble sending emails from the K2 system to employees within my company. Unable to export with a large numberI have inquired with my email provider. Was informed that if it's the same domain, there is no limit.So I would like to consult with members whether the K2 Filve has a Limit Sending Mail setting or not, if so. Which point do I need to check? Thank you.

I have an interesting issue where i have recently deployed a new service instance to leverage OData calls to SAP for personal data. I have a workflow that passes 2 values to a SMO created from the service instance being a total cost and personal number to then return between 1 and 3 personal numbers of people responsible for approving a request. Most use cases are 1 returned value or 2 barely 3, but in accounts for multiples i have created a small loop over a reference list in my workflow to pass those approver personal numbers to a sub workflow to create a separate task to approve this persons request, then garbage collecting the any additional workflows open with a SMO so there isn’t any double ups or issues. Hopefully that’s paints enough of a picture of my process to understand the issues i am having, for no apparent reason, nothing has notably changed in my development environments but my list isn’t passing the personal numbers back from the list to create tasks. it is however cre

Guys, currently there is a need to create a Text File from the input entered by the user in a form. this should generate a Text File with the appropiate information, and like to store and email as attachment. I wonder if somebody have some suggestions on how to achieve this...  Best Regards Dino.

I have an extremely simple form that allows users to add lines to an editable list view. There are only two fields in each line. When the form submits I need to make sure they fill in both of the fields to submit. Have used advanced conditions with Else rules many times in the past. It appears that the way the If condition nests it doesnt allow an Else to be used to validate. So for instances if you have a For Each loop that does a Create Smart Object rule, it seems impossible to stop the user if they forget a field in the display row of the list with an IF advanced condition rule. Then you cannot use Else because of the way the rules nest. I have tried Form Validation but it behaves weirdly when trying to add more than one line of data to the view for submission. Any ideas?  Thanks Dave

Hi, I'm using Literal to make a fullcalendar.When I run it at my chorm (file:///D:/K2Five/Pramool/fullcalendar-6.1.9/examples/month-view-k2.html) It works. But when I put the script in the Data Label and select Literal, nothing happened. The screen is white.I have verified that the src path is correct. I have placed the library in server (C:\Program Files\K2\K2 smartforms Runtime\Styles\Themes)download fullcalendar → https://fullcalendar.io/docs/initialize-globals1. create DataLabel and Add Expression Script2.This is the code in the Datalabel<script src='/Runtime/Styles/Themes/fullcalendar-6.1.9/dist/index.global.js'></script><script> document.addEventListener('DOMContentLoaded', function() { var calendarEl = document.getElementById('calendar'); var calendar = new FullCalendar.Calendar(calendarEl, { initialDate: '2023-01-12', editable: true, selectable: true, businessHours: true, dayMaxEvents: true, locale: 'th', events: [

Hi, I have added a value to a TextBox using Javascript. Now I want to use this value for Parameters. Apparently I cannot. Although there is a value in the TextBox it iseems I cannot use it. When I click into the TextBox then it gets cleared. If I manually input something I can use it afterwards. I am using this statement <script>document.getElementsByName("urlTextBox")[0].value = "abc"</script> Any ideas? ThanksSven

I have created a workflow in k2 studio (see the attachment). In that I have multiple approval levels. In one of the approval level I am doing parallel activities. Depending on the selection on form, I am sending worklist item link email to multiple people.For example, If user has selected two people on form, I am sending email to both of them simultaneously.In ideal scenario I am looking following functionalities:1. If anyone of them rejects the request, workflow should go back to previous step for second review.2. If both of the approvers approve it, workflow should go for next approval step.3. If both of the approvers reject it, workflow should go to previous approval step for second review.In current scenario I am getting following results1. If one person approves the request and another one rejects the request, workflow is neither going to previous step for second review nor going to next approval step.2. If both of the approvers approves it, workflow is going for next approval ste

Dear Members,We are unable to configure start condition in a K2 workflow which triggers on Item updated event of a SP Online list.Error states - “Only one start integration to a SharePoint integrated form or SharePoint event is supported per workflow. Please remove the existing SharePoint start integration and try again “.This works fine in our lower environment with same configuration.Any inputs.Regards,Zeeshan

I am trying to make a soap request but I am getting the below error. The K2 server is configured with https and tls 1.2 by default. What could be the issue? Anyone with the same experience with the SOAP API?  Details of error:"283010081","2023-08-31 10:00:45","Error","SmartObjects","10702","Error","SourceCode.SmartObjects.ServiceBroker [ExecuteSmartObject]","10702 An error occurred in the DSV CostEstimate Service Instance. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)   --- End of inner ex

After upgrading to K2 4.7, the system functions properly and K2 Workspace is accessible. However, when attempting to connect to the K2 Management Site and open ViewFlow, the following error message appears. I'm not sure if anyone has encountered a similar situation. ’/ViewFlow' 應用程式中發生伺服器錯誤。找不到方法：“Void SourceCode. Hosting, Client. BaseAPI, SCConnectionString Builder.set_KeepAlive(Int32)”。 [MissingMethodException: 找不到方法：“Void SourceCode.Hosting.Client.BaseAPI.SCConnectionStringBuilder.set_KeepAlive(IntSourceCode.Security. Claims. Web.Shared. ConnectionClass.GetPoolConnectionString(Boolean useWorkflowPort)+0SourceCode.Security.Claims.Web.Shared.ConnectionClass.GetPoolConnection(String credentialToken, Boolean asAppPool, B SourceCode.Security.Claims.Web.Shared.ConnectionClass.Connect (BaseAPI baseAPI, Boolean asAppPool, Boolean validateLiSourceCode.Security.Claims.Web._trust.login.Page_Load(Object sender, EventArgs e) +204System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object send

This article is related to the following article:  Error CodeForm 'com.K2.System.Management.Form.UserRolesList' could not be found. Ensure that the form exists, that it is checked in, and that you are authorized to run the form and its views. Troubleshooting StepsPlease review the logs in the following locations, if available, to check if there was any issue during installation/upgrade:Package and Deployment logs (.log) found inside {K2 Installation Folder}Setup. Installation trace logs (.log) found in: %temp%K2 Setup Log {K2 Installation Folder}SetupLog {K2 Installation Folder}SetupUpdateLog ResolutionThere will be a need to manually re-deploy the package which may have encountered issues based on the logs above. Resolution 2i found the following error while runing K2 setup manager:The following warnings were logged as part of the install: Could not update add/remove programs: System.MissingMethodException: Method not found: 'System.Collections.Generic.Dictionary`2<System.String,

Hi Everyone, I have notice that our K2 production database has grown to over 600GB. Most growth is showing in the FG_Server and FG_ServerLog file groups. Is there any maintenance script that can be executed to cleanup some old logs?Thanks,Herman 

I have scheduled workflow to run every 3 months on 15th and send emails.In Schedules it is showing last run on 15th August with no failure. I checked under workflow but there is no instance either in running, error or completed(under report tab) state. The workflow was scheduled by person and his account is deactivated now in AD.Can any one have idea about this issue and how to resolve it?  Thanks in advance!

Hello,how I can change the position of the new row on the top instead of down. 

 Help, I'm having trouble.The right picture is a k2 5.4 can use the menu normally.But when I take the project to deployThe left picture is k2 5.6, the menu shows blank, I searched html, found that the data loads normally but why it shows blank and doesn't find any error.Now I can't fix the problem. Aside from reverting back to 5.4 as before.

Workflow → Task Control → Form Type = Customadd parameter over 2 parameter in custom form parameter mapper but when open url from worklist only 2 parameters data are received.https://custom_url/Runtime/Runtime/Form/FRM__Tracking/?SN=6504_268&request_id=60409c85-2f57-4570-a00f-0369c385030d 

Dear, i create Stord procured with the below dynamic sql but when create smart object select columns not appear in smart object.  ALTER PROCEDURE [dbo].[Sp_General_GetDynamicMenu]    @TableName NVARCHAR(100),    @ColumnID NVARCHAR(100),    @ColumnName NVARCHAR(100),    @ColumnParentID NVARCHAR(100),    @ColumnURL NVARCHAR(100) =NULL,    @ColumnIcon NVARCHAR(100)=NULL,    @ColumnOrder NVARCHAR(100)=NULLASBEGIN    -- SET NOCOUNT ON added to prevent extra result sets from    -- interfering with SELECT statements.    SET NOCOUNT ON;    DECLARE @DynamicSQL NVARCHAR(MAX)    IF NOT EXISTS ( SELECT 1 FROM sys.tables WHERE name = @TableName ) BEGIN RAISERROR('Invalid table name.', 16, 1) RETURN END    DECLARE  @Final TABLE (        ID INT,  Name NVARCHAR(MAX), ParentID INT, IsParent bit DEFAULT(1), [URL] NVARCHAR(100) ,Icon  NVARCHAR(100), OrderID int        )    create TABLE  #FinalTabel  (        ID INT,  Name NVARCHAR(MAX), ParentID INT, IsParent bit DEFAULT(1), [URL] NVARCHAR(100) ,Icon  NV

Hi,What’s the recommended route to migrate a form from a Dev environment which uses a SMartobject to a Live environment with a SQL table?Will moving from SMO to SQL break anything in the form?What’s the best way of achieving this? I can package it up on Dev, but when deploying, can we use a SQL table on Live rather the Smartobject? If so, again will connections in the form remain intact?Thanks

K2 (5.0004.1000.4)  >> K2Five53June2023CumulativeUpdate >> after update with database, Open K2 Setup Manager ERROR occured during the execution of setup:Arguments:  Exception: Could not load type 'Roles' from assembly 'SourceCode.Install.SQL, Version=4.0.0.0, Culture=neutral, PublicKeyToken=16a2c5aaaa1b130d'., Exception has been thrown by the target of an invocation., Exception has been thrown by the target of an invocation.  

Hello,we are assigned tasks to the users (throw user name or active directory group).and we using k2 API in order to take action.when assigning a task to a user by user name (Task user:name) correct but when assigning the task to the group  (Task user:name) wrong.(task user:name ) always equal the destination, not the person who tasks the action.we take the action from workspace everything is ok. 

Hi everyone some of the user can not use the k2 services and it gave them this Error exception of type 'system.web.httpunhandledexception' was thrown <br/>The K2:Domain\test user could not be found we are using Active Directory and i checked the smartobject which is in the tester and the users is there but when they try to access its gave them the error  

Hi,Upgraded K2 from 5.3 to 5.6 and K2 smart forms are insisting to enter credentials every time they tried to login.it supposed to be take windows credentials automatically.Can anyone have any idea how to resolve this?Best Regards,