search cancel

When Installing on DB2 receive U00003592 UCUDB - Status: '42S02' Native error

book

Article ID: 88153

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
U00003592 UCUDB - Status: '42S02' Native error: '-204' Msg: ' SQL0204N "AESYSP1.UC_TABLE" is an undefined name. SQLSTATE=42704'

During installation of the Automation Engine on DB2 the following message is seen in the DB Load log file:
 
20170321/170319.134 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 1 DB-HDBC: 1
20170321/170319.134 - U00003591 UCUDB - DB error info: OPC: 'SQLExecDirect' Return code: 'ERROR'
20170321/170319.134 - U00003592 UCUDB - Status: '42S02' Native error: '-204' Msg: ' SQL0204N "AESYSP1.UC_TABLE" is an undefined name. SQLSTATE=42704'
20170321/170319.136 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 1 DB-HDBC: 1
20170321/170319.137 - U00003591 UCUDB - DB error info: OPC: 'SQLNumResultCols' Return code: 'ERROR'
20170321/170319.137 - U00003592 UCUDB - Status: '42S02' Native error: '-204' Msg: ' SQL0204N "AESYSP1.UC_TABLE" is an undefined name. SQLSTATE=42704'
20170321/170319.137 - U00003594 UCUDB Ret: '3590' opcode: 'SLUC' SQL Stmnt: 'select Table_Children from uc_table where Table_Name = 'EH''
20170321/170319.137 - U00003590 UCUDB - DB error: 'SQLNumResultCols', 'ERROR ', '42S02', ' SQL0204N "AESYSP1.UC_TABLE" is an undefined name. SQLSTATE=42704'
20170321/170319.139 - Error getting oh related tables

Environment

OS Version: N/A

Cause

Cause type:
By design
Root Cause: The tables do not yet exist yet so the errors are printed to the log, but they can be ignored.

Resolution

These messages can be ignored. Since the tables do not yet exist those errors are printed to the log.

Fix Status: No Fix

Fix Version(s):
N/A

Additional Information

Workaround :
N/A