ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
When Installing on DB2 receive U00003592 UCUDB - Status: '42S02' Native error
Article ID: 88153
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:
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
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
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.
By design
Root Cause: The tables do not yet exist yet so the errors are printed to the log, but they can be ignored.
Environment
OS Version: N/A
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
Fix Status: No Fix
Fix Version(s):
N/A
Additional Information
Workaround :
N/A
N/A
Feedback
Yes
No
Powered by
