Agent Inventory Discrepancy

Products

• Autosys Workload Automation

Issue/Introduction

After re-pointing an Autosys instance from one database to another. 
The Agent Inventory is now showing all the old machines from DB2 and not what is currently in DB1.

 

Environment

Release : 12.0

Component : WCC
WORKLOAD CONTROL CENTER

Resolution

The tnsnames.ora file needed to be changed and it was yet the AEWS was still finding its way to the old db eventhough all the TNS_ADMIN environment variables in the $AUTOUSER/autosys.<shell>.<hostname> files were pointing to the correctly updated tnsnames.ora.

There was an extra TNS_ADMIN setting in 

/opt/CA/WorkloadAutomationAE/autouser.CDA/webserver/conf/wrapper.conf

set.ORACLE_HOME = /u001/app/oracle/product/19.3.0.0
set.TNS_ADMIN = /u001/app/oracle/product/19.3.0.0/network/admin

The settings above needed to be updated as they were pointing to a different/older tnsnames.ora.

Once that was done and AEWS restarted AEWS could display the correct machines.

To get WCC to reflect the update, delete the AEWS URL from the AutoSys server definition in WCC, save the changed and then add it back.