Upgrades Web UI 12.0 to SP1 now getting error messages

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• CA Workload Automation Agent
• 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:

Cause

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

Environment

Release : 12.0

Component : CA Workload Control Center

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.