"User not allowed to open worklist item" from Workspace Inbox
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
Issue
When opening a task from the Inbox on Workspace, the following error appears:
Worklist item could not be opened. [USER] is not allowed to open the worklist item with SN=[SN]
Symptoms
- The Task List in K2 Management shows that the user is assigned to the task.
- When opening the task from Workspace, the SharedUser parameter is added to the task URL with value equal to the user's FQN, even if no user is currently set to Out of Office. Removing this parameter allows the user to open the task.
eg. https://k2.denallix.com/Runtime/Runtime/Form/ApprovalForm/?SerialNo=15_7&SharedUser=K2SQL:TEST.USER
Troubleshooting Steps
Verify the user currently authenticated through the steps below:
- Login to Workspace.
- Open the developer tools from the browser.
- Go to the Console tab and type in the following: SourceCode.Forms.Settings.User.FQN
- This should return the FQN enclosed in quotation marks:
Ensure that the value is correct and has no trailing space. If there is a trailing space, please check the UserID property for the corresponding entry in the [Form].[UserProfile] table.
SELECT *, '[' + UserID ']'
FROM [Form].[UserProfile]
WHERE UserID LIKE '%{username}%'
-- Replace {username} as applicable.
FROM [Form].[UserProfile]
WHERE UserID LIKE '%{username}%'
-- Replace {username} as applicable.
After confirming that there is a trailing space in the UserID, you may update the entry as follows:
UPDATE [Form].[UserProfile]
SET UserID = LTRIM(RTRIM([UserID]))
WHERE ID={id_from_query}
SET UserID = LTRIM(RTRIM([UserID]))
WHERE ID={id_from_query}
Incorrectly editing the K2 database can result in system instability or failure. Before making any database changes, it is strongly recommended to make a backup of your database. Do not modify any database definition or database content unless specifically instructed to do so by K2. No changes to the K2 Database definition or content are supported unless specifically instructed by K2. If you need assistance with implementing these changes, please log a Support Ticket with K2 Product Support.
http://help.k2.com/onlinehelp/k2blackpearl/devref/current/default.htm#Database_Reference.html
http://help.k2.com/onlinehelp/k2blackpearl/devref/current/default.htm#Database_Reference.html