Jobs do not show when listed in quickview


Article ID: 209974


Updated On:


CA Workload Automation AE


Based on below log entries there is a disconnect between Application Server database which could cause the issue

 CAUAJM_E_18601 SQLSTATE: 01000, Native error: 10,054, Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).
 CAUAJM_E_18601 SQLSTATE: 08S01, Native error: 11, Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation [02/21/20** 10:49:55]     CAUAJM_E_18611 Event Server: <autosysprddb,1433:AEDB>  Failed Query: <update ujo_alamode set int_val = (select int_val from ujo_alamode where type='DB') where type = 'DB'>
 CAUAJM_E_18600 Database function call <SQLDriverConnect> failed in <connect SQLDriverConnect Failed> with return code: -1
 CAUAJM_E_18601 SQLSTATE: IM008, Native error: 0, Message: [Microsoft][ODBC SQL Server Driver]Dialog failed
 CAUAJM_E_30034 Client [CA WAAE API JNI:1684][10][***.**.**] [3B848118][02/21/20** 10:50:19.588][1:atsysuser<@hostname1,hostname2> 1] is not reachable. API ID [348] execution terminated. Total time: 67.23 seconds.



From Application Server Logs, Error messages indicate the there is an issue with network communication.

Database indicates cannot be reachable.


Release : 11.3.6*

Component : CA Workload Automation AE (AutoSys)


WCC UI could not fetch job details, If  Application server was not communicating to AE Database.

WCC Collector Fails/retries to fetch job details when such issues occur.

should work with network admins team to find out cause for disconnection.

Please troubleshoot and follow up below list to make sure you address network issue

Database Drivers Connectivity  

Port Communication Blockages/changes

FQDN/DNS name resolution or IP address changes




Additional Information

Environment Variables -- Network Communication