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

Last updated on JULY 20, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.