WP and CP processes do not start with IBM DB2.
search cancel

WP and CP processes do not start with IBM DB2.

book

Article ID: 197203

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

The WPs and CPs do not start with IBM DB2 as database.

20200812/162939.128 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 1  DB-HDBC: 1
20200812/162939.128 - U00003591 UCUDB - DB error info: OPC: 'SQLConnect' Return code: 'ERROR'
20200812/162939.128 - U00003592 UCUDB - Status: 'HY000' Native error: '-1042' Msg: ' SQL1042C  An unexpected system error occurred.  SQLSTATE=58004'
20200812/162939.128 - U00003590 UCUDB - DB error: 'SQLConnect', 'ERROR   ', 'HY000', ' SQL1042C  An unexpected system error occurred.  SQLSTATE=58004'
20200812/162939.128 - U00003611 DB OPEN executed. Return Code = '0000003590'
20200812/162939.128 - U00003620 Routine 'UCMAIN_R' forces trace because of error.
20200812/162939.128 - U00003590 UCUDB - DB error: 'SQLConnect', 'ERROR   ', 'HY000', ' SQL1042C  An unexpected system error occurred.  SQLSTATE=58004'
20200812/162939.169 - U00003449 Output to the TRACE file is finished.
20200812/162939.169 - U00003100 Memory TRACE was opened with the switches '0000000000000000'.
20200812/162939.169 - U00003380 Server 'AUTOMIC#WP' version '12.2.6+build.1590774379025' (Runtime '0/00:00:00', Log# '1', Trc# '0').
20200812/162939.169 - U00003491 There is a time difference of '0/00:00:00' or '0' seconds to the Primary Server.
20200812/162939.169 - U00003375 Server usage of the last minute '0%', the last 10 minutes '0%' and the last hour '0%'.
20200812/162939.170 - U00003590 UCUDB - DB error: 'SQLConnect', 'ERROR   ', 'HY000', ' SQL1042C  An unexpected system error occurred.  SQLSTATE=58004'
20200812/162939.170 - U00003410 Server 'AUTOMIC#WP' version '12.2.6+build.1590774379025' ended abnormally.

Environment

Release : 12.n

Component : AUTOMATION ENGINE

Cause

Configuration.

Resolution

Navigate to the AutomationEngine/bin directory and delete all libgcc* and libstdc* binaries.