On COLD start, WP logs show ORA-00942 error

Products

• 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