F140202 Unable to make initial connection to database at jdbc:derby://localhost:1527/wccmonitor;create=true;collation=TERRITORY_BASED;territory=en_US. Shutting down.

Products

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

Issue/Introduction

The WCC monitoring services (CA-uwccmonitoring and CA-uwccmonitoringcollector) keep shutting down. We are also getting the following error in our logs:

[ <WrapperStartStopAppMain> [] ] FATAL 2017-03-10 12:59:29,810 com.ca.wcc.monitor.service.CollectorService F140202 Unable to make initial connection to database at jdbc:derby://localhost:1527/wccmonitor;create=true;collation=TERRITORY_BASED;territory=en_US. Shutting down.

[ <WrapperStartStopAppMain> [] ] FATAL 2017-03-10 13:04:52,999 com.ca.wcc.monitor.service.CollectorService F140202 Unable to make initial connection to database at jdbc:derby://localhost:1527/wccmonitor;create=true;collation=TERRITORY_BASED;territory=en_US. Shutting down.

[ <WrapperStartStopAppMain> [] ] FATAL 2017-03-10 13:07:56,012 com.ca.wcc.monitor.service.CollectorService F140202 Unable to make initial connection to database at jdbc:derby://localhost:1527/wccmonitor;create=true;collation=TERRITORY_BASED;territory=en_US. Shutting down.

 

Environment

CA Workload Control Center r11.3 SP1 using a Derby Database

Cause

The Derby database is corrupted. 

Resolution

The Derby database needs to be rebuilt. Follow the instructions provided below:

 

===============

UNIX/LINUX

===============

 

Start by navigating to your $CA_WCC_INSTALL_LOCATION/bin directory

 

1. Export all views, their filters, alert policies, and jobs (if you have any to back up ) using the following command:

./wcc_monitor.sh -u username -p password -x output_file

2. Export all job status console defintions (if you have any to back up ) using the following command:

./wcc_jsc.sh -u user_name -p password -x output_file 

3. Export all configurations to the file for backup using the following command:

./wcc_config.sh -u user_name -p password -x output_file 

4. Stop WCC Services

./StopWCCServices.sh

5. Backup $CA_WCC_INSTALL_LOCATION/MonitorDB/wccmonitor and backup $CA_WCC_INSTALL_LOCATION/ReportsDB/reports by renaming the directories to something like wccmonitor_bkup and reports_bkup

6. Restart WCC services (this will force WCC to recreate the DB)

./StartWCCServices.sh 

7. Confirm you can log into WCC (it will take a while to log into WCC because the database is being created at this time) 

8. Import config backup files (if you backed up any)

./wcc_config.sh -u username -p password -i input_file

9. Add/validate/deploy AE server (if it's not done already)

10. Import monitor backup files (if you backed up any)

./wcc_monitor.sh -u username -p password -i input_file 

11. Import JSC backup files (if you backed up any)

./wcc_jsc.sh -u username -p password -i input_file

 

===============

WINDOWS

===============

 

Start by navigating to your %CA_WCC_INSTALL_LOCATION%\bin directory using a command prompt window

 

1. Export all views, their filters, alert policies, and jobs (if you have any to back up ) using the following command:

wcc_monitor -u username -p password -x output_file

2. Export all job status console defintions (if you have any to back up ) using the following command:

wcc_jsc -u user_name -p password -x output_file

3. Export all configurations to the file for backup using the following command:

wcc_config -u user_name -p password -x output_file

4. Stop all WCC services

5. Backup %CA_WCC_INSTALL_LOCATION%\MonitorDB\wccmonitor and backup %CA_WCC_INSTALL_LOCATION%\ReportsDB\reports by renaming the directories to something like wccmonitor_bkup and reports_bkup

6. Restart WCC services (this will force WCC to recreate the DB)

7. Confirm you can log into WCC (it will take a while to log into WCC because the database is being created at this time)

8. Import config backup files (if you backed up any)

wcc_config -u username -p password -i input_file

9. Add/validate/deploy AE server (if it's not done already)

10. Import monitor backup files (if you backed up any)

wcc_monitor -u username -p password -i filename

11. Import JSC backup files (if you backed up any)

wcc_jsc -u username -p password -i filename