CA Workload Control Center URL does not load
search cancel

CA Workload Control Center URL does not load

book

Article ID: 191289

calendar_today

Updated On:

Products

CA Workload Automation AE

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

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.

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