JWP fails to start: U00032031 Error when connecting to Database

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The JWP doe snot start with the error message below in the log.

 

U00003545 UCUDB: Opening database ...
U00045440 [JDBC]/SQLDRIVERCONNECT not found in INI file.
U00003611 DB OPEN executed. Return Code = '500'
U00011847 'BULK_FETCH_SIZE' set to '50'.
U00032031 Error when connecting to Database

Environment

Product: CA Automic Workload Automation - Automation Engine v24.x 

Cause

The parameter sqlDriverConnect in the ucsrv.ini in section [JDBC] is empty.

Resolution

Please define the sqlDriverConnect in section [JDBC] of the ucsrv.ini file.

For example:

Oracle:

sqlDriverConnect=jdbc:oracle:thin:@//<DBSERVERNAME>:<DBPORT>/<DB_INSTANCE_NAME>

MS SQL Server:

sqlDriverConnect=jdbc:sqlserver://<DBSERVERNAME>:<DBPORT>;<DB_INSTANCE_NAME>

 

DB2

sqlDriverConnect=jdbc:db2://<DBSERVERNAME>:<DBPORT>/<DB_INSTANCE_NAME>

PostgreSQL

sqlDriverConnect=jdbc:postgresql://<DBSERVERNAME>:<DBPORT>/<DB_INSTANCE_NAME>