Upgrade WCC to R12 that went from a derby db to an Oracle db prior to upgrade

book

Article ID: 194676

calendar_today

Updated On:

Products

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

Issue/Introduction

Trying to upgrade WCC from 11.4 SP7, using the latest R12 ISO. WCC is connected to an external oracle DB, but was first installed with internal Derby database and then connected to oracle using the wcc_config.sh EG: ./wcc_config.sh -u $USER -p $PASSWD --dbplatform ORACLE --dbuser WCC_WRITE --dbpassword `cat /var/tmp/dbpass` --dbhost <db_host> --dbport 6336 --dbname <db_name> --dbapp WCC
The upgrade failed with the following error messages -

2020-06-15 09:29:42,487 [main] ERROR com.ca.wla.ae.installer.logger.LogHelper - [CAUAJM_E_116003] Configuration file is corrupted. null

Cannot proceed with the selected instance or Web UI. Check the configuration file.

2020-06-15 09:29:42,487 [main] DEBUG com.ca.wla.ae.installer.logger.LogHelper - Setting the result variables:$AE_DATABASE_SERVER_UPGRADE_ORA_SYB_VAR_RETURN_STATUS$ to:E_AE_Config_File_Corrupted :$AE_DATABASE_SERVER_UP

GRADE_ORA_SYB_VAR_RETURN_MSG$ to:[CAUAJM_E_116003] Configuration file is corrupted. null

Cannot proceed with the selected instance or Web UI. Check the configuration file.

2020-06-15 09:29:42,487 [main] ERROR com.ca.wla.ae.installer.customaction.initialize.AEDBSetUpgradeOraHomeSybVar - Instance Error list:{Web UI=[CAUAJM_E_116003] Configuration file is corrupted. null

Cannot proceed with the selected instance or Web UI. Check the configuration file.}

2020-06-15 09:29:42,487 [main] ERROR com.ca.wla.ae.installer.logger.LogHelper - [CAUAJM_E_112539] Encountered warnings while processing the database information of the below instances. Refer the log file for a detaile

d list error messages.

Web UI

2020-06-15 09:29:42,487 [main] DEBUG com.ca.wla.ae.installer.logger.LogHelper - Setting the result variables:$AE_DATABASE_SERVER_UPGRADE_ORA_SYB_VAR_RETURN_STATUS$ to:E_AE_DB_upgrade_DB_Multiple_Instance_Err :$AE_DATA

BASE_SERVER_UPGRADE_ORA_SYB_VAR_RETURN_MSG$ to:[CAUAJM_E_112539] Encountered warnings while processing the database information of the below instances. Refer the log file for a detailed list error messages.

Web UI

Not sure what configuration file it is looking for, but guessing I need to create one with the database connection profile. Can you let me how to do that?

Environment

Release : 11.4

Component : CA Workload Automation AE (AutoSys)

Resolution


Attempted to run the upgrade with no services running, including the derby database service. The upgrade failed at the same point as before –

Database Validation

-------------------



Error:

[CAUAJM_E_112539] A few warnings occurred while processing the database

information of the below instances. For more information, refer to the log

file.

"Web UI"



Added the following to the connection.properties file (with null values)

wcc.database.tnsname=

reporting.database.tnsname=

wcc.database.tnspath=

reporting.database.tnspath=

wcc.database.port=

wcc.database.host=

reporting.database.host=

reporting.database.port=



Restarted the upgrade and this time the database properties were successfully recognized -

Web UI Database Properties

--------------------------



Specify the following information of schema admin to upgrade the database.


Database type: ORACLE

Service Name:  <Oracle service name>

Database host: <Oracle machine name>

Database TCP port: <Oracle database port>



This time the upgrade ran through to completion and /etc/profile.CA contained the correct WCC install location –

CA_WCC_INSTALL_LOCATION=/opt/CA/WorkloadAutomationAE/wcc; export CA_WCC_INSTALL_LOCATION



After copying the keystore file to the correct location and updating the server.xml and wrapper.conf files, WCC started successfully.