CA Automic Workload Automation - Automation Engine
Issue/Introduction
When starting Automic Workload Automation WPs in startmode = COLD, the following error shows up in the logs:
U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 2000730 DB-HDBC: 207ca30 U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR' U00003592 UCUDB - Status: '' Native error: '942' Msg: 'ORA-00942: table or view does not exist ORA-06512: at "UC4.UC_TRUNCATE_TABLE", line 1' U00003594 UCUDB Ret: '3590' opcode: 'EXEC' SQL Stmnt: 'call UC_Truncate_Table('MQ1CP009')' U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-00942: table or view does not exist ORA-06512: at "UC4.UC_TRUNCATE_TABLE", line 1'
The table in the error message 'MQ1CP009' can be any CP table, starting with 'MQ#CP###' where the # are numbers.
Environment
AWA 11.x, 12.x
Cause
When starting in COLD mode, the Automation Engine will truncate all MQ* tables in order to clear out the message queues.
It will: Start by truncating the message queue (MQ) table for CP1 (CP001) Loop, adding one to the CP number Until it hits a CP table that does not exist Throw the warning message above
In the example above, this means that 8 tables were truncated and when it went to truncate the 9th, it was not found.
Resolution
This error message is normal and is not indicative of any problems as long as: The error is seen during a cold start The error points to a MQ table for CPs