Agent Inventory is not available
Article ID: 97349
CA Workload Automation AE - Scheduler (AutoSys)
CA Workload Automation AE
Agent inventory is not showing any data, and not even able to validate after providing wadl url in web services URL attribute.
Workload Automation AE 11.3.6 SP7
WCC 11.4 SP6
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
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.
(PROTOCOL = TCP)(HOST = XXXXXX)(PORT = 15XX))
(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXX)(PORT = 15XX))