K2 blackpearl

FORUM POSTS AND DISCUSSIONS

  • 2,173 Topics
  • 5,411 Replies

2173 Topics

S
samarmRookie
asked in K2 blackpearl

Which database table have a records of all the completed workflow instances

Hi team, Could you please help which database table have the records of all the completed workflow instances?  I believe that the active workflow instance tables are: [K2].[ServerLog].[ProcInst][K2].[ServerLog].[ProcInstData] thanks and much appreciated for your help.

2
S
4 months ago
M
mit
asked in K2 blackpearl

Which database table has a record of all the workflow folios and process instance IDs that exist across all our forms?all

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.

2
S
5 months ago
F
FrozenFormsRookie
asked in K2 blackpearl

Create a txt file with K2 Five

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

4
S
5 months ago
D
DabuskolNovice
asked in K2 blackpearl

K2 listview export to Excel doesn't include the colors of each column

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,   

1
Frankie
5 months ago
P
P_JadsadaRookie
asked in K2 blackpearl

There was a problem sending a large number of emails.

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.

3
D
6 months ago
N
NathanMurphyNovice
asked in K2 blackpearl

Empty reference values but correct amount of rows in the reference

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

2
N
6 months ago
K
K2CaveMen
posted in K2 blackpearl

I need to generate a Text File from a K2 Form.... similar to the PDF Control but as Text File...

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.

4
F
6 months ago
F
FrozenFormsRookie
asked in K2 blackpearl

Using Advanced Condition for validation with a For Each loop

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

3
T
7 months ago
HarumiSysyem
HarumiSysyemRookie
asked in K2 blackpearl

Error logs in console

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: [

2
HarumiSysyem
7 months ago
S
SvenW
posted in K2 blackpearl

SmartForm: Set TextBox value by Javascript - when focussed, it gets cleared?!

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

7
V
7 months ago
M
m_s
posted in K2 blackpearl

K2 studio workflow parallel activity

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

3
B
8 months ago
ZeeshanNasim
ZeeshanNasimRookie
asked in K2 blackpearl

Unable to configure start condition in K2 workflow for SharePoint Item Updated Event.

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

2
ZeeshanNasim
8 months ago
K
KatzRookie
asked in K2 blackpearl

SOAP API Request

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

3
K
8 months ago
R
rtripathi28Rookie
asked in K2 blackpearl

User Impact of K2 Five Archive (mArchive)

Hello,I am using [mArchive] stored procedure to archive K2 Five database. Just want to know what kind of locks used in the stored procedure.Is it table level or row level?Can we run this stored procedure during business hours so that users can continue their work without any issues?What will be the impact on daily work in case tables/rows locked?Is there any measure how many rows can be archived in one go so that there should not be any impact on users?How much time generally it takes to complete execution, first time and there after?Thanks

5
T
8 months ago
V
Vincent_SCTWRookie
asked in K2 blackpearl

Error on open K2 Management site and viewflow (set_KeepAlive)

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

1
T
8 months ago
O
osman.islam.samiRookie
posted in K2 blackpearl

Unable to view Roles from K2 Management Error Code Form com.K2.System.Management.Form.UserRolesList

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,

0
O
8 months ago
H
HermanHarmseRookie
asked in K2 blackpearl

K2 5 database Growth

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 

3
H
8 months ago
B
BB33Novice
asked in K2 blackpearl

I have scheduled workflow but instance not triggered and not found in completed.

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!

2
MillaZ
8 months ago
Akhanjer
AkhanjerRookie
asked in K2 blackpearl

change add new row position

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

2
P
9 months ago
HarumiSysyem
HarumiSysyemRookie
asked in K2 blackpearl

k2 5.6 menu system blank page

 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.

3
HarumiSysyem
9 months ago
S
SoraweeRookie
asked in K2 blackpearl

Workflow Task Custom Form Type add parameter over 2 parameter

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 

3
T
9 months ago
Akhanjer
AkhanjerRookie
asked in K2 blackpearl

dynamic sql query not working

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

4
MillaZ
9 months ago
S
Sharpharp1Scout
asked in K2 blackpearl

Migrating from a Smartobject to a SQL Table

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

9
S
9 months ago
O
osman.islam.samiRookie
asked in K2 blackpearl

K2 (5.0004.1000.4) >> K2Five53June2023CumulativeUpdate >> Could not load type 'Roles' from assembly 'SourceCode.Install.SQL, Version=4.0.0.0, Culture=neutral, PublicKeyToken=16a2c5aaaa1b130d'.

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.  

2
O
9 months ago
Akhanjer
AkhanjerRookie
asked in K2 blackpearl

task user name incorrect

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. 

4
MillaZ
10 months ago

View our Community Site Map

Nintex Community Sitemap

Badges

  • You're a life saver!
    Brent_Dochas earned the badge You're a life saver!
  • First Topic
    jmashkovskiyhas earned the badge First Topic
  • First Topic
    alexvierahas earned the badge First Topic
  • First reply
    pezzahas earned the badge First reply
  • First Topic
    pezzahas earned the badge First Topic
Show all badges
Terms & ConditionsCookie settings