Detailed Description and 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'
U0003594 UCUDB Ret: '3590' OpCode: 'EXEC' SQL Stmnt: 'DELETE FROM MQCP006 WHERE MQCP_System=?'
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.
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%';