Agent Inventory is not available
book
Article ID: 97349
calendar_today
Updated On:
Products
CA Workload Automation AE - Scheduler (AutoSys)
Autosys Workload Automation
Show More
Show Less
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))
Feedback
thumb_up
Yes
thumb_down
No