AutoSys update fails with error CAUAJM_E_112144 Unable to determine the security state of instance.

Products

• CA Workload Automation AE

Issue/Introduction

Upgrade from WAAE 11.3.6 SP8 CUM2 to 12.0 SP1 fails with the message :

Upgrade CA EEM Policies
-----------------------

CA EEM policies for the following server(s) will be updated.

     Web UI/Instance(s)    CA EEM Server(s)
     ----------------      ----------------

     PRD              CAUAJM_E_112144 Unable to determine the security
                           state of  instance "PRD".
                           java.sql.SQLRecoverableException: IO Error: The
                           Network Adapter could not establish the
                           connection
                           (CONNECTION_ID=2O9QwKXSnib6AWeoIIbdA==)

 

 

 

Environment

Release : 11.3.6 SP8 upgrade to R12

Cause

The Oracle SID in AutoSys config file and the tnsnames.ora were different :

config.PRD File: ORA12

tnsnames.ora: ORA12.world

Resolution

The Oracle SID in AutoSys config file and the tnsnames.ora were different.

config.PRD File: ORA12

tnsnames.ora: ORA12.world

 

The installer picks the Oracle SID from the AutoSys config file and resolves the entry using the tnsnames.ora. 

As it was incorrect, it failed to resolve and the database connection failed.

 

Updated the entry in the AutoSys config file from ORA12 to ORA12.world and the installer proceeded further.