WCC login page does not load

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

When trying to log on to WCC User Interface, the login page does not load and remains blank. No errors are displayed.

Environment

WCC 11.3.6, RHEL 6.6

Cause

The problem was caused by a corrupted WCC Derby database. The following errors were recorded in the WCC logs:

 

INFO | jvm 1 | 2016/10/19 13:40:11 | SEVERE: Cannot get database connection 

 

INFO | jvm 1 | 2016/10/19 13:40:11 | java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Failed to start database 'WCC_MAIN' with class loader sun.misc.Launcher$AppClassLoader@596b753, see the next exception for details.::SQLSTATE: XSAI2The conglomerate (16) requested does not exist.

 

 

 

 

 

Resolution

Rebuild the WCC Derby database:

 

• Export configuration and monitoring policies/views (this may or may not work depending on the severity of the Derby database corruption). If this does not work, WCC configuration and monitoring policies and view will be lost and will have to be added to the new database manually later: 

# cd $CA_WCC_INSTALL_LOCATION/bin 

# ./wcc_monitor.sh -u <user name> -p <password> -x /tmp/monitor.txt 

# ./wcc_config.sh -u <user name> -p <password> -x /tmp/config.txt 

 

• Stop all WCC services. 

 

• Go to the $CA_WCC_INSTALL_LOCATION/derby/DB_FILES directory and rename the WCC_MAIN directory to, for example, WCC_MAIN-original. This will preserve the original DB files. 

 

• Restart WCC services. A new WCC_MAIN directory will be created with the new database files.

 

• Log on to WCC to verify it is working now. 

 

• Import configuration and monitoring policies/views back to the database: 

# cd $CA_WCC_INSTALL_LOCATION/bin 

# ./wcc_monitor.sh -u <user name> -p <password> -i /tmp/monitor.txt 

# ./wcc_config.sh -u <user name> -p <password> -i /tmp/config.txt