Symptoms
User is able to submit a task action from SmartForms successfully, but the action does not commit. The task event does not complete and the workflow does not move forward. The following error is logged: ""76350792","2016-11-22 13:17:35","Error","General","1","GeneralErrorMessage","K2Worker.Action","1 26033 Worklist item 1418_11 Not Open for K2:DENALLIXAdministrator at 127.0.0.1:97554","","","K2PROD:C:Program Files (x86)K2 blackpearlHost ServerBin","76350792","ee665d0b960244729f4ef86f774a2a53","""
Diagnoses
Exporting the result from the [Server].[Actioner] table as a .csv file, there looks be be trailing spaces of the accounts in question:
ID,ActionerName,ActionerType,Status
1,K2:DENALLIXAdministrator ,1,NULL
The destination set for this client event is using a SmartObject result from a SQL table (varchar SQL type) that return the username in the format 'DENALLIXAdministrator'. It would appear that this data may have had trailing spaces. This issue can be replicated by create a SQL table with varchar SQL data type and inserting a row with:
INSERT INTO [DatabaseName].[dbo].[TableName] ([UserName]) VALUES ('DENALLIXAdministrator ')
Exposing this table as a SmartObject and using this varchar UserName field in the Destination Set of a client event.
Resolution
1. Leading/trailing spaces was trimmed from the SQL table as well as the [Server].[Actioner] table with a similar SQL query to resolve running instances:
update [dbo].[TableName] set UserName = LTRIM(RTRIM(UserName))
*Please create database backup(es) prior to making any modification.
2. An Inline Function > Text > Trim function can be used in the destination set to intercept and remove any leading/trailing spaces before the task gets assigned and written to the [Server].[Actioner] table (assuming the custom database varchar field requires trailing spaces for any reason).
K2 Help Article
