WP stops responding with error message "U00003507 UCUDB PGE: Table is not in DBTAB"

Document ID : KB000087822
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
U00003507 UCUDB PGE: Table is not in DBTAB, Table: ''

A worker process (WP) may stop responding and error messages similar to the above error may be displayed.  However, these errors do not always adversely impact the WP and may not have a visible impact on the system at all.

Investigation

A WP gets hundreds of the following error messages:

 
U00003594 UCUDB Ret: '3507' opcode: 'INSR' SQL Stmnt: ''U00003507 UCUDB PGE: Table is not in DBTAB, Table: ''U00003594 UCUDB Ret: '3507' opcode: 'SLCO' SQL Stmnt: 'SELECT * FROM MQSRV WHERE MQSRV_Type=1 ORDER BY MQSRV_Name'U00003507 UCUDB PGE: Table is not in DBTAB, Table: 'MQSRV'U00003594 UCUDB Ret: '3507' opcode: 'SLCU' SQL Stmnt: 'SELECT * FROM MQ1DWP WHERE MQDWP_SchedTime<=? ORDER BY MQDWP_Priority, MQDWP_SchedTime, MQDWP_PK FOR UPDATE SKIP LOCKED'U00003507 UCUDB PGE: Table is not in DBTAB, Table: 'MQ1DWP'U00003507 UCUDB PGE: Table is not in DBTAB, Table: ''U00003507 UCUDB PGE: Table is not in DBTAB, Table: 'MQ1PWP '
 
These are just examples of the type of error messages that may be displayed.  The error may affect various MQ tables so the actual table names might be different.

It also occurs during different operation codes, so the opcodes may be different as well.
 


 
Cause:
Cause type:
Defect
Root Cause: A problem has been fixed where a worker process stopped responding. The WP log contained the error message "U00003507 UCUDB PGE: Table is not in DBTAB".
Resolution:
This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: Released

Fix Version(s):
Component(s): AE Server and Initialdata

Automation Engine 12.0.0 - Available
Automation Engine 11.2.3 - Available
Additional Information:
Workaround :
N/A