AWA: Unable to start CP and WP processes, error in the logs "U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file)."
Article ID: 189236
CA Automic Workload Automation - Automation Engine
Symptoms of the issue: When starting Automation Engine, CP and WP processes do not start. In the Automation Log files, you see the following errors: U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file). U00003594 UCUDB Ret: '3531' opcode: 'OPEN' SQL Stmnt: '' U00003611 DB OPEN executed. Return Code = '0000003531' U00003620 Routine 'UCMAIN_R' forces trace because of error. U00003449 Output to the TRACE file is finished.
In the forced trace file, you may see the messages such as presented below:
U00003611 DB OPEN executed. Return Code = '1017' U00003590 UCUDB - DB error: '72000', 'ORA-01017: invalid username/password; logon denied', '1017', 'java.sql.SQLException' U00032031 Error when connecting to Database
Release : 12.1, 12.2, 12.3
Component : AUTOMATION ENGINE
Automation Engine cannot connect to the database due to misconfiguration
Automation Engine could not connect to the database as ORA-01017 (Oracle error) states.
In most of the cases the issue is with one or a combination of the following:
1. ucsRV.INI Database configuration string (Database name, password, character set, syntax, etc.) 2. Configuration on the server side depending on the database type. For example, for Oracle Databases, verify ORACLE_SID and LD_LIBRARY_PATH. 3. Verify there is no issue with network between the Automation Engine and database servers.
Verify all the items listed above. If all the configuration is correct, open a case with Broadcom Support.