My Oracle Support Banner

Workflow Error Message When Sysadmin Is User In Workflow (Doc ID 2376284.1)

Last updated on MARCH 21, 2018

Applies to:

Oracle WebCenter Content - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

Error seen when sysadmin is in workflow

>workflow/6 03.15 14:31:51.505 IdcServer-5532 WorkflowUtils.updateDbQueue: Add docName - WCCD_008630 to WorkflowInQueue
>workflow/6 03.15 14:31:51.511 IdcServer-5532 WorkflowUtils.updateDbQueue: Updated the queue with query = IwfInQueue for user sysadmin and dDocName = WCCD_008630 and result= 1
>workflow/6 03.15 14:31:51.518 IdcServer-5532 WorkflowUtils.deleteFromDbQueue: delete for user=sysadmin dDocName= WCCD_008630 with result=1
>workflow/6 03.15 14:31:51.521 IdcServer-5532 WorkflowUtils.deleteFromDbQueue: Unable to delete the workfow in queue entry for user sysadmin and dDocName WCCD_008630 intradoc.data.DataException: !csJdbcGenericError
workflow/6 03.15 14:31:51.521 IdcServer-5532 at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2729)
workflow/6 03.15 14:31:51.521 IdcServer-5532 at intradoc.jdbc.JdbcWorkspace.createResultSet(JdbcWorkspace.java:785)

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Caused by: Error : 942, Position : 14, Sql = SELECT * FROM WfDeletedInQueue WHERE dUser='sysadmin' AND dDocName='WCCD_008630', OriginalSql = SELECT * FROM WfDeletedInQueue WHERE dUser='sysadmin' AND dDocName='WCCD_008630', Error Msg = ORA-00942: table or view does not exist
workflow/6 03.15 14:31:51.521 IdcServer-5532
workflow/6 03.15 14:31:51.521 IdcServer-5532 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.