Symptoms
User Starts Workflow and it remains in Task Lists. Administrators are unable to release this workflow Instance.
Diagnoses
The following errors can be found in the K2 Host Server log:
K2:xxxxxxxxxx from 127.0.0.1 is not allowed to open the worklist item with SN=xxxxx_xx
"Error","General","1","GeneralErrorMessage","K2Worker.Action","1 26033 Worklist item xxxxx_xx Not Open for K2:xxxxxxxxxx at 127.0.0.1:"
Resolution
This error in host server is being logged when an entry in Actioner table for affected user(s) has a trailing space at the end of username.
To resolve this you can do the following:
1. In Active Directory check that the User does not have a trailing space after the User Account name, to make sure that Actioner table indeed contains wrong information caused by manual input or something like this
2. Use the following to query to check if the entry in the Actioner table has a trailing space:
-- You can use this script to check if ActionerName has spaces in the beginning or in the end
USE K2
SELECT ActionerName
FROM Server.Actioner
WHERE DATALENGTH(RTRIM(LTRIM(ActionerName))) <> DATALENGTH(ActionerName)
3. If this script returned you any data it means that ActionerName contains space(s) in the end or in the beginning of its value. As usual before attempting any modifications of K2 database create database backup first, then make sure that there is no trailing space for this user account in Active Directory and use the following script to trim the spaces around the ActionerName: value
--Make sure to specify correct ID, using information from previous query
USE K2
UPDATE Server.Actioner
SET ActionerName=LTRIM(RTRIM([ActionerName])) WHERE ID=1
