ORA-02429 during dbload in DROP INDEX NK_XEVT1_OTYPE

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

While attempting to upgrade the database from 21.0.11 to 24.4.1 using the ucybdbld tool, the following error is encountered and the upgrade stopped:

 

U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-02429: cannot drop index used for enforcement of unique/primary key

ORA-06512: at line 7'
20250904/143846.526 - U00038077 Do you want to ignore this error?

Please note: Do not continue without contacting Automic Support!

This occurs during the step to drop the index of the table XEVT1, on this instruction:

EXECUTE IMMEDIATE 'DROP INDEX NK_XEVT1_OTYPE';

 

Environment

Automation Engine with Oracle Database being upgraded to 24.2.x or superior

Cause

The index NK_XEVT1_OTYPE cannot be dropped as it has a primary key constraint PK_XEVT1

Resolution

Please ask the DBA to drop the primary key PK_XEVT1 in case the error occurs so that the index can be dropped consequently when running the dbload and that should do.

These tables XEVT* are only used for the integration with AAI and should be empty in case this is not being used so no data should be within these tables.