CAUAJM_E_85100 DBmaint Connection Failure
search cancel

CAUAJM_E_85100 DBmaint Connection Failure


Article ID: 36106


Updated On:


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



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] 


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



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 




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: 



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




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

 TEST = 


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




 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/ 

       Change the following: 




3. Save the

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.



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

Attachments get_app