CAUAJM_E_85100 DBmaint Connection Failure

book

Article ID: 36106

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent

Issue/Introduction

Problem:

DBmaint fails with below error.

CAUAJM_I_85000 Compliance Application running 

CAUAJM_E_85100 Unable to open database connection. 

Error details: 

* IO Error: could not resolve the connect identifier "XXXXX" 

CAUAJM_E_85002 Compliance Application terminated with error [100] 

 Environment:

This issue may occur on AIX, Linux, Unix, Solaris and HP with Oracle as DB.

 Cause:

 

The problem is related to using fully qualified TNS alias in the tnsnames.ora. The SID value is extracted from the AE config file and using the TNS short 

 

 name.

 Solutions:  

Modify file tnsnames.ora or Copy JDBC driver from the OCI client install to the $AUTOSYS/lib directory.  

The OCI driver is able to retrieve the fully qualified TNS name from the short name.

However, the Oracle JDBC driver is not able to do this.

There are two solutions which can be implemented. 

 First one:

1. Modify the tnsnames.ora file 

 2. Duplicate the fully qualified TNS entry and change it to the short name. For example if you have the following in the tnsnames.ora: 

 TEST.CA.COM = 

(DESCRIPTION = 

(ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521)) 

(CONNECT_DATA = 

(SERVER = DEDICATED) 

(SERVICE_NAME = TEST) 

copy the TNS entry and change the copy to look like this: 

 TEST = 

(DESCRIPTION = 

(ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521)) 

(CONNECT_DATA = 

(SERVER = DEDICATED) 

(SERVICE_NAME = TEST) 

 3. Save the tnsnames.ora file. 

 Second one: 

1. Copy the JDBC driver from the OCI client install to the $AUTOSYS/lib directory. 

2. Modify the $AUTOSYS/config/cmplapp/connection.properties 

       Change the following: 

            oracle.tns.connection.string=jdbc:oracle:thin:@${dbname} 

      to 

           oracle.tns.connection.string=jdbc:oracle:oci:@${dbname} 

3. Save the connection.properties

Additional Information:  

This issue is solved in CA WAAE Release 11.3.6 SP3.

If issue is not solved please raise the case to CA Support.

 

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component:

Attachments

1558534240009TEC1645571.zip get_app