Agent Inventory is not available

Products

• CA Workload Automation AE - Scheduler (AutoSys)
• Autosys Workload Automation

Issue/Introduction

 Agent inventory is not showing any data, and not even able to validate after providing wadl url in web services URL attribute. 

Environment

Workload Automation AE 11.3.6 SP7 
WCC 11.4 SP6 
Oracle 11g 
 

Cause

The ca-wcc.log has the following error 

NFO | jvm 1 | 201X/XX/XX 12:23:47 | 693014 | @asi <ForkJoinPool-132-worker-1> [] ERROR #SchedulerAgentsDAO # Exception writing Agents to database : Internal error parsing response from Scheduler XXX 
INFO | jvm 1 | 201X/XX/XX 12:23:47 | 693014 | com.ca.workload.services.exceptions.WlaInternalServerErrorException: Internal error parsing response from Scheduler XXX 

The webserver log also had the following error 

201X-XX-XX 12:23:47,699 [AEConnMgr Monitor] ERROR com.ca.waae.dbaccess.dao.AEConnection - createEntityManager [EventServer_1] -> IllegalStateException encountered. Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException 
Internal Exception: java.sql.SQLRecoverableException: IO Error: could not resolve the connect identifier "XXXXX" 

The problem was Autosys webserver not able to connect with AE database 

Resolution

The issue is with  Oracle $TNS_ADMIN/tnsnames.ora file has special chars and formatting problem. Problem resolved after correcting the Oracle tnsnames.ora  format and permissions 

Changed the Address string  from displaying in multiple lines to a single line.

(ADDRESS = 
        (PROTOCOL = TCP)(HOST = XXXXXX)(PORT = 15XX))

TO

(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXX)(PORT = 15XX))