Error during upgrade to AAI 24.2 - ORA-02292: integrity constraint (JAWS_DBO.XFKALERTACTIVATIONAA_DISTTYPE)

Products

• Automation Analytics & Intelligence

Issue/Introduction

When upgrading to 24.2 you may run into the error below when upgrading the database by running the upgradeJawsDbTo24.2.0.sqL script

  1  DELETE FROM AlertActivation_DistType WHERE alertActivationId IN (

  2      SELECT alertActivationId FROM AlertActivation WHERE alertType IN ('JOBSTREAM_CHECKPOINT', 'JOBSTREAM_NOT_STARTED')

  3* )

DELETE FROM AlertActivation WHERE alertType in ('JOBSTREAM_CHECKPOINT', 'JOBSTREAM_NOT_STARTED')

*

ERROR at line 1:

ORA-02292: integrity constraint (JAWS_DBO.XFKALERTACTIVATIONAA_DISTTYPE)

violated - child record found

If you attempt to start AAI you may see the error below in the jaws.log

Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "MRR1_0"."STARTTOSTARTLATENCY": invalid identifier

Environment

24.2

Resolution

Open the upgradeJawsDbTo24.2.0..sql file in a text editor and search for the line below

 

DELETE FROM AlertActivation WHERE alertType in ('JOBSTREAM_CHECKPOINT', 'JOBSTREAM_NOT_STARTED')

 

Then copy all of the SQL statement below this line and run each of those SQL statements against the AAI database, and this will complete the upgrade.