WCC instance shuts down because the number of open cursors are exceeded.
Example of error message in the wcc.log file
INFO | jvm 1 | 2020/12/18 10:16:52 | 310 | @tomcat-resource <WrapperStartStopAppMain> [] WARN #ClusterProviderDAO # Lets give 5 more seconds for <default-collector> to get added, instancename : autosys-app-scheduler
INFO | jvm 1 | 2020/12/18 10:16:57 | 315 | @tomcat-resource <WrapperStartStopAppMain> [] WARN #ClusterProviderDAO # Wait complete, check again for <default-collector> node existance
INFO | jvm 1 | 2020/12/18 09:48:50 | 2317 | WARNING: select * from CFG_COLLECTOR_NODES where HOST=? AND CLUSTERPORT=?
INFO | jvm 1 | 2020/12/18 09:48:50 | 2317 | Dec 18, 2020 9:48:50 AM com.ca.wcc.dbresource.datasource.SlowQueryReportWithWhiteList reportFailedQuery
INFO | jvm 1 | 2020/12/18 09:48:50 | 2317 | WARNING: ORA-01000: maximum open cursors exceeded
INFO | jvm 1 | 2020/12/18 09:48:50 | 2317 | - Target cause: Error : 1000, Position : 0, Sql = select * from CFG_COLLECTOR_NODES where HOST=:1 AND CLUSTERPORT=:2 , OriginalSql = select * from CFG_COLLECTOR_NODES where HOST=? AND CLUSTERPORT=?, Error Msg = ORA-01000: maximum open cursors exceeded
INFO | jvm 1 | 2020/12/18 09:48:50 | 2317 |
INFO | jvm 1 | 2020/12/18 09:48:50 | 2317 | @tomcat-resource <WrapperStartStopAppMain> [] ERROR #ClusterProviderDAO # Error while checking <default-collector> : Error executing statement:
INFO | jvm 1 | 2020/12/18 09:48:50 | 2317 | select * from CFG_COLLECTOR_NODES where HOST=? AND CLUSTERPORT=?
INFO | jvm 1 | 2020/12/18 09:48:50 | 2317 | java.lang.RuntimeException: Error executing statement:
The ha.node=<hostname> in the connections.properties files contradicts the hostname of the WCC server.
Release : 12.0
Component : CA Workload Control Center
The connection.properties file contains entry for ha.node is which different than the hostname of the WCC server.
1. Modify the ha.node=<hostname> entry in the connection.properties file is located in these directories.
/opt/CA/WorkloadAutomationAE/wcc/data/config/application/config/resources
/opt/CA/WorkloadAutomationAE/wcc/collectors/WCC_COLLECTOR/data/config/application/config/resources
2. Restart the WCC services.