upgrade of WCC failed.
Article ID: 254702
Updated On:
Products
Issue/Introduction
Below is current setup:
Autosys R11.3.6 SP8 installed.
EEM version Release: 12.6.0.5.
CA Workload Automation WCC 11.4 SP7.
Upgrade attempt to 12.1 failed, second attempt says successful
See below errors in the logs:
2022-11-18 07:16:26,880 [main] ERROR com.ca.wcc.db.DBChangesForUpgrade(230) - There was a problem with database while running the upgrade: ORA-00406: COMPATIBLE parameter needs to be 12.0.0.0.0 or greater
ORA-00722: Feature "SQL identity columns"
java.sql.SQLException: ORA-00406: COMPATIBLE parameter needs to be 12.0.0.0.0 or greater
ORA-00722: Feature "SQL identity columns"
aused by: Error : 406, Position : 0, Sql = CREATE TABLE CFG_COLLECTOR_NODES (NODE_ID NUMBER(10) GENERATED BY DEFAULT ON NULL AS IDENTITY (START with 1 INCREMENT by 1), COLLECTOR_NAME NVARCHAR2(255) NOT NULL, CLUSTERPORT NUMBER(10) NOT NULL, HEARTBEAT_TIME TIMESTAMP NULL, HOST NVARCHAR2(255) NOT NULL, INSTALLEDPATCHES NVARCHAR2(512) NULL, STATE NVARCHAR2(32) NULL, VERSION NVARCHAR2(255) NULL, PRIMARY KEY (NODE_ID)) tablespace ATO_DATA, OriginalSql = CREATE TABLE CFG_COLLECTOR_NODES (NODE_ID NUMBER(10) GENERATED BY DEFAULT ON NULL AS IDENTITY (START with 1 INCREMENT by 1), COLLECTOR_NAME NVARCHAR2(255) NOT NULL, CLUSTERPORT NUMBER(10) NOT NULL, HEARTBEAT_TIME TIMESTAMP NULL, HOST NVARCHAR2(255) NOT NULL, INSTALLEDPATCHES NVARCHAR2(512) NULL, STATE NVARCHAR2(32) NULL, VERSION NVARCHAR2(255) NULL, PRIMARY KEY (NODE_ID)) tablespace ATO_DATA, Error Msg = ORA-00406: COMPATIBLE parameter needs to be 12.0.0.0.0 or greater
ORA-00722: Feature "SQL identity columns"
Environment
Autosys 12.1
WCC
Cause
The Clients Oracle 19c database had the compatibility mode set to Oracle 11
Resolution
So overall high level -
1) Restore your WCC database to 11.4.x
2) DBA corrected the COMPATIBLE parameter on you oracle 19C database so that it is 12 or higher
3) restore EEM and WCC installation
4) make sure you can log into EEM and WCC
5) run the upgrade again following the below KB article
https://knowledge.broadcom.com/external/article?articleId=218331
6) Run the upgrade installer.
( if you run into the SDK error run the below command:)
rpm -ivhf ca-waae-sdk-11.3.6-1643.i386.rpm --justdb --nodeps
Feedback
