Workflow Step To Approve For Publish Fails..

(Doc ID 1452810.1)

Last updated on OCTOBER 03, 2017

Applies to:

Oracle WebCenter Sites - Version 7.6.1 and later
Information in this document applies to any platform.
***Checked for relevance on Tuesday, December 31, 2013***

Symptoms

When trying to complete a workflow step, the following error message is seen in the UI:

"Cannot change workflow definition

This attempt to change the workflow definition failed. The most likely cause of this is a system configuration error. PLease exit the browser, login, and try the operation again. If the problem persists, please contact your system administrator."

Additionally, at the same time this error is shown in the UI, there is the following errors in the logs:

"[2012-04-18 08:54:14,257] [fatwire.logging.cs.db] Missing value for key column id in table Assignment
[2012-04-18 08:54:14,257] [fatwire.logging.cs.db]


[2012-04-18 08:54:14,257] [fatwire.logging.cs.xcelerate] [pagename=OpenMarket/Xcelerate/Actions/SetWorkflowPost] Error: com.openmarket.xcelerate.commands.WorkflowEngineDispatcher: StartObjectWorkflowProcess: com.openmarket.basic.interfaces.AssetException: Error: errno=-105 on call to catalog manager for table 'Assignment'"


Furthermore, there are messages in the log that indicate a problem with the Assignment table mentioned in the above messages:

"[com.fatwire.logging.cs] Results for Query SELECT * FROM Assignment WHERE cs_ownerid=1234532572834 AND (cs_isactive='y' OR cs_isactive='q' OR cs_isactive='a') cannot be cached as Assignment does not exist in system. Please note that the cache names are case sensitive"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms