Receiving error message when starting the system

Document ID : KB000089717
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Receiving error message when starting the system
Resolution:

Symptoms

When starting the system (specifically with a COLD restart), the following error message appears toward the top of the logs:

U0003592 Status: '' Native error: '942' Msg: 'ORA-00942: table or view does not exist'

Followed by:

U0003594 UCUDB Ret: '3590' OpCode: 'EXEC' SQL Stmnt: 'DELETE FROM MQCP006 WHERE MQCP_System=?'


Cause

U0003592 Status: '' Native error: '942' Msg: 'ORA-00942: table or view does not exist'

Followed by:

U0003594 UCUDB Ret: '3590' OpCode: 'EXEC' SQL Stmnt: 'DELETE FROM MQCP006 WHERE MQCP_System=?'

_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________

Resolution

NOTE: Please do not run any lines of SQL below unless instructed by Automic Support!

These messages do not actually reflect an error in the system.  They are a warning message instead.

Explanation: When a COLD start happens, SQL is run to clear out the MQ tables.  There are (by default) 5 MQCP tables: MQCP001, MQCP002, MQCP003, MQCP004, MQCP005.  The SQL statements delete from these tables by adding 1 to the end until hitting the MQCP006 table withe the following statement:

DELETE FROM MQCP006 WHERE MQCP_System=<system name>

If the table MQCP006 does not exist (which by default it does not), the warning message is displayed.

Problem Persists:

If you feel that you are receiving this message in error because a MQCP table higher than MQCP005 exists, please contact Support with the results of the SQL statement if on SQL Server:

SELECT name FROM sys.tables WHERE name LIKE '%MQCP%'

or the following SQL statement if on Oracle:

SELECT table_name FROM dba_tables WHERE table_name LIKE '%MQCP%';