Upgrade WCC to R12 that went from a derby db to an Oracle db prior to upgrade
Article ID: 194676
Updated On:
Products
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 SP7
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.
Feedback
