Error ORA-00904 CONDITIONORDER invalid identifier after AAI 24.4 upgrade

Products

• Automation Analytics & Intelligence

Issue/Introduction

Gemini said

Automation Analytics and Intelligence (AAI) remains in an initializing state for an extended period and completely fails to start immediately after upgrading to release 24.4.

Error Message:

ORA-00904: SC1_0.CONDITIONORDER: invalid identifier

Symptoms:

• The AAI system hangs in an "initializing" state post-upgrade.

• The hibernate.log displays ORA-00904 errors.

• The jaws.log displays JammerManager DataAccessException errors.

• Impact: The AAI application is completely inaccessible.

Environment

AAI 24.4

Cause

The database is unable to initialize because it cannot find the expected tables or columns. The required database schema changes for version 24.4 were bypassed or not applied during the initial upgrade process.

Resolution

Prerequisites: * Database Administrator (DBA) access

• AAI application server access

Step 1. Stop the Application Service

• Action: Stop the AAI service.

• Expected Result: The service stops completely.

Step 2. Apply the Database Upgrade Script

• Action: Run the upgradeTo24.4*.sql script against the AAI database which is located in the <AAI Install Dir>/scripts directory.

• Expected Result: The schema upgrades successfully without errors.

 

Step 3. Restart the Application Service

• Action: Start the AAI service.

• Expected Result: The service initializes properly without database errors.

 

Verification

To verify the fix was successful:

• Check that the AAI application is now fully accessible.

• Verify that the hibernate.log and jaws.log no longer display SQL exceptions.