ORA-01450 error during the v21 > v24 upgrade with DB Load

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The customer is facing an issue with the DB load process when upgrading from V21 to V24 during the last step. The following error occurs:

    IF i = 0 THEN 
      dbms_output.Put_line('You do not have Oracle Enterprise in use. It will take some time until all indices are rebuilt. Index:  NK_EH_HOST');
      EXECUTE IMMEDIATE 'CREATE INDEX NK_EH_HOST ON EH(EH_OType, EH_SubType, EH_EventSubType, EH_Status, EH_HostDst, EH_HostSrc, EH_Hostfsc, EH_HostVara) TABLESPACE UC4V12_INDEX';
    ELSE 
      dbms_output.Put_line('You have Oracle Enterprise in use. Now we create an index with option ONLINE. Index:  NK_EH_HOST');
      EXECUTE IMMEDIATE 'CREATE INDEX NK_EH_HOST ON EH(EH_OType, EH_SubType, EH_EventSubType, EH_Status, EH_HostDst, EH_HostSrc, EH_Hostfsc, EH_HostVara) TABLESPACE UC4V12_INDEX ONLINE';
    END IF; 
END; 
'
20250617/103940.913 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-01450: maximum key length (3215) exceeded
ORA-06512: at line 15'
20250617/103940.914 - U00038068 ABORTING due to error. 

The loading process was terminated abnormally. The Database might be in an inconsistent condition. Please contact Automic Support.

Environment

Oracle DB

Cause

This is an Oracle issue

Resolution

See attached PDF files for additional information.

Please contact Oracle to resolve this.