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].vActioner] 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  

 

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 aServer].eActioner] 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 sServer].dActioner] table (assuming the custom database varchar field requires trailing spaces for any reason).

 

K2 Help Article

http://help.k2.com/onlinehelp/k2blackpearl/UserGuide/4.7/default.htm#2.Create/K2_for_VisualStudio_K2_Studio/4.Workflow/InlineFunctions/FB_Text.htm