Agent Inventory is not available

Document ID : KB000097349
Last Modified Date : 22/05/2018
Show Technical Document Details
Issue:
 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))