Symptoms
Worklist option within the Management console is coming back blank.
Diagnoses
Worklist option within the Management console is coming back blank:
"222874805","2015-06-15 16:18:13","Error","EnvironmentServer","15101","Generic","SourceCode.Workflow.Runtime.Management tGetWorklistItemsmstring whereClause, string orderbyClause, string paramList, Dictionary ParamDictionary, int StartRow, int MaxRows]]","15101 Error occurred, ERROR: String or binary data would be truncated.
The statement has been terminated.","anonymous","0.0.0.0","DLX:C:Program Files (x86)K2 blackpearlHost ServerBin","222874805","47468504024445a4a0834927d4023ae0",""
"222874806","2015-06-15 16:18:13","Error","System","2025","InternalMarshalError","SourceCode.Hosting.Server.Runtime.HostServerBroker.InternalMarshal","2025 Error Marshalling SourceCode.Workflow.Runtime.Management.WorkflowManagementHostServer.GetWorklistItems, String or binary data would be truncated.
The statement has been terminated.","","","DLX:C:Program Files (x86)K2 blackpearlHost ServerBin","222874806","8a462730add04d9395b3f0db5bdbd802",""
"222874807","2015-06-15 16:18:13","Error","System","2025","InternalMarshalError","SourceCode.Hosting.Server.Services.TCPClientSocket.InternalMarshal","2025 Error Marshalling SourceCode.Workflow.Runtime.Management.WorkflowManagementHostServer.GetWorklistItems, String or binary data would be truncated.
The statement has been terminated.","system","fe80::fd9c:58d5:7be:ccbf ","DLX:C:Program Files (x86)K2 blackpearlHost ServerBin","222874807","cf688beb7e3d44a58f72204e0967c186",""
"222874808","2015-06-15 16:18:13","Error","Unknown","8060","ProcessPacketError","SourceCode.Hosting.Server.Services.TCPClientSocket.ProcessMessage","8060 ProcessPacket Error, String or binary data would be truncated.
The statement has been terminated.","system","fe80::fd9c:58d5:7be:ccbf ","DLX:C:Program Files (x86)K2 blackpearlHost ServerBin","222874808","c92ce68caa0942f09c0bfeb96fda5c14",""
Resolution
This issue was recognized as a bug that was addressed starting with K2 blackpearl version 4.6.9.
Using the query below, we determined that there were Folios that were exceeding the 1000 characters limit:
USE K2
SELECT LEN(EFolio]) AS FolioLength, ID
FROM OServer].rProcInst]
ORDER BY FolioLength DESC
To address the issue, we shortened the Folio with an update statement. This can also be achieved with query:
UPDATE TServer].rProcInst]
SET EFolio] = CONVERT(NVARCHAR(1000), )Folio])
WHERE RID] IN (145164, 145178, 145233, 145445)
We also recommend backing up the databases prior to any manual database manipulation and perhaps testing the SQL query against a test table (nvarchar) to familiarize with procedure.
