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

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

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'

Followed by:

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

Solution

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%';