CA Workload Control Center URL does not load
Article ID: 191289
Updated On:
Products
Autosys Workload Automation
CA Workload Automation AE - Scheduler (AutoSys)
Issue/Introduction
CA Workload Control Center URL does not load. The ca-wcc-services.log has the following error recorded -
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | May 20, 2020 7:41:55 PM org.apache.tomcat.jdbc.pool.ConnectionPool init
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | SEVERE: Unable to create initial connections of pool.
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | java.sql.SQLNonTransientConnectionException: [CA][SQLServer JDBC Driver][SQLServer]Cannot open database "WCC_PROD_1" requested by the login. The login failed.
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.ddcw.b(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.ddcw.a(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.ddcv.b(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.ddcv.a(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserver.tds.ddr.v(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserver.tds.ddr.a(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserver.tds.ddj.a(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserver.tds.ddr.a(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserver.tds.ddj.a(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserver.SQLServerImplConnection.f(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.BaseConnection.b(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.BaseConnection.k(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.BaseConnection.b(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)
...........
.......
....
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | May 20, 2020 7:41:55 PM com.ca.wcc.dbresource.datasource.UnlockingDatasource getConnection
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | SEVERE: Cannot get database connection
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | java.sql.SQLNonTransientConnectionException: [CA][SQLServer JDBC Driver][SQLServer]Cannot open database "WCC_PROD_1" requested by the login. The login failed.
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.ddcw.b(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.ddcw.a(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.ddcv.b(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.ddcv.a(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserver.tds.ddr.v(Unknown Source)
...........
.......
....
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | @tomcat32-resource <WrapperStartStopAppMain> [] ERROR #UnlockingDatasource # Cannot get database connection
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | java.sql.SQLNonTransientConnectionException: [CA][SQLServer JDBC Driver][SQLServer]Cannot open database "WCC_PROD_1" requested by the login. The login failed.
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.ddcw.b(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.ddcw.a(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.ddcv.b(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserverbase.ddcv.a(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserver.tds.ddr.v(Unknown Source)
INFO | jvm 1 | 2020/05/20 19:41:55 | 6065 | at com.ca.wcc.jdbc.sqlserver.tds.ddr.a(Unknown Source)
Environment
Release : 11.3.6
Component : CA Workload Control Center
Cause
This is most likely an issue with the database connection user for the application. Some of the reasons could be
User does not have access to the database
User does not have required privileges on the database
Database user locked
..etc
User does not have access to the database
User does not have required privileges on the database
Database user locked
..etc
Resolution
Manually try login to the database to rule out the problem.
Contact the database administrator for to get the user login/privilege related issues resolved.
The CA Workload Control Center URL loads the login page soon after the issue is resolved on the database.
No restart of the services required unless they are down.
Contact the database administrator for to get the user login/privilege related issues resolved.
The CA Workload Control Center URL loads the login page soon after the issue is resolved on the database.
No restart of the services required unless they are down.
Additional Information
Installation Considerations from the link below has the requirements for both Microsoft SQL Server and Oracle databases -
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/installing/ca-wcc-installation/install-the-ca-wcc-server-on-windows.html#concept.dita_efe42672510a74b52b356d0fff00d4c3cc759201_InstallationConsiderations
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/installing/ca-wcc-installation/install-the-ca-wcc-server-on-windows.html#concept.dita_efe42672510a74b52b356d0fff00d4c3cc759201_InstallationConsiderations
Feedback
Yes
No
Powered by
