ca-wcc-services will not start after upgrade to R12.01 due to Derby database not upgraded
search cancel

ca-wcc-services will not start after upgrade to R12.01 due to Derby database not upgraded

book

Article ID: 216158

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

It has been observed on a few scenarios after upgrading to WebUI to R12.01, the  WebUI process CA-wcc-services would fail to start.

Environment

AutoSys Workload Automation  12.X
AutoSys Workload Automation WebUI (WCC)

Cause

Upon investigation, the problem identified is due to the Derby database did not get upgraded as part of the WebUI upgrade.

 

Resolution

The Derby database is not designed to be a production database for WCC. This is been a quoted text during the installation (popup appears upon selecting the default derby db) and in the following documentation as well:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0-01/installing/ca-wcc-installation/Web-UI-Database-and-Dependencies.html

The recommendation is to migrate to one of the supported enterprise database solutions (Oracle Or Microsoft SQL Server) for WebUI, besides AutoSys Workload Automation server.

While the exact root cause for the particular problem is unknown, This scenario of skipping the Derby database schema upgrade is not often seen.

Unfortunately, The product installer does not have an option to upgrade the database schema alone if it is derbydb.

The following steps can be taken as a precautionary prior to running the upgrade. This will help in not losing the existing views and configurations for the WebUI - 

- Backup the WCC objects (Monitoring views, configurations, saved ECLI commands..etc) prior to running the upgrade.

https://knowledge.broadcom.com/external/article/33269/how-to-export-wcc-monitoring-views-to-a.html 

https://knowledge.broadcom.com/external/article/33327/how-to-export-wcc-configuration-to-a-fil.html 

- A complete file system backup of WCC install directory after stopping all the services (If the existing WCC is hosted on a VM, take a snapshot).

If this issue arises, the existing WCC can be safely uninstalled to perform a fresh installation of WebUI 12.01. Subsequently, the exported objects (views and alert policies) can be imported to the newly installed version.

Additional Information

WebUI Upgrade Considerations: 

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-1/upgrading/autosys-upgrade-considerations/web-ui-(upgrade-considerations).html