CA Workload Automation AE - Business Agents (AutoSys)CA Workload Automation AE - Scheduler (AutoSys)Workload Automation Agent
Issue/Introduction
The alerts does not show any jobs in WCC The monitoring views are not updating. The status shows 9 PM whereas the current time is 10 PM There is a error message that there are no active filters against the views.
Environment
Workload Automation AE 11.3.6 SP7 HA with single event server Oracle WCC 11.4 sp6 HA with load balancing using Oracle database
Cause
Monitoring.log has the following error
2018-09-20 23:07:07,963 @monitoring <10.218.4.218 justinor ~799> [] ERROR EventResource Internal Exception: java.sql.SQLDataException: ORA-01843: not a valid month
Resolution
Stopped WCC services on both the WCC nodes Started services only on one WCC node To clear the bad data we refreshed the WCC database using " wcc_monitor -u <username> -p <password> -d ALL"
Now the views have number of jobs with status and the view status time is also updated But there are no jobs and alerts listed for the views in monitoring tab.
Collected the logs after server restart and we could see this error in monitoring logs