Upgrades Web UI 12.0 to SP1 now getting error messages

Products

• CA Workload Automation AE - Scheduler (AutoSys)
• CA Workload Automation AE

Issue/Introduction

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:

Environment

Release : 12.0

Component : CA Workload Control Center

Cause

The ha.node=<hostname> in the connections.properties files contradicts the hostname of the WCC server.

Resolution

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.