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

Products

• CA Workload Automation AE

Issue/Introduction

After upgrading to WCC R12.01, cannot start the CA-wcc-services process.
In reviewing the CA-wcc.log, the Derby database did not get upgraded successfully.

 

Environment

Autosys  12.X
WORKLOAD CONTROL CENTER
WCC

Resolution

When upgrading from WCC 11.3.6.0 to the WCC 12.0.01 release, the Derby database was not upgraded.
There is no option in the install.bin to choose to only upgrade the Derby database.

The only options were Oracle and Microsoft SqlServer.
The Derby database is not designed to be a production database in WCC as stated during the installation and in the following documentation:

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

If Deby MUST be used please reach out to support to engage L2