ORA-04098: trigger 'AO_8BAD1B_BOOTSTRAP_ID_autoinc' is invalid and failed re-validation

[Prakash Selladurai]

We have processed xml data restore in our Lower env. TEST jira with production xml data. After 90% of the xml data restore. its was stopped and nothing with show. So We did manual full re-indexing. 

After that we have issue an issue in structure and xray plugins,

There are a couple of different things here:

• These logs show us that the index is inconsistent:

2022-11-07 09:36:15,354-0500 Structure-Jobs599bbb51 Queue-Thread#28 WARN anonymous [c.a.j.issue.index.IndexConsistencyUtils] Index consistency check failed for index 'Issue': expectedCount=1142551; actualCount=0

Since Structure relies on Jira’s index to load data, it will show these warnings when the index is inconsistent. This can't be solved without a full reindex.

Recommended to re-indexing the jira instance. but still we have the below error message.

The logs are full of DB errors similar to this one involving Structure:

2022-11-09 00:46:43,068-0500 https-jsse-nio-9007-exec-23 WARN prakash.selladurai@Fiserv.com 46x100467x1 1u5ggx7 10.189.238.215,127.0.0.1 /secure/admin/ViewLogging.jspa [c.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'com.almworks.jira.structure.api.error.StructureRuntimeException - com.google.common.util.concurrent.UncheckedExecutionException: com.almworks.jira.structure.api.error.StructureRuntimeException: com.google.common.util.concurrent.UncheckedExecutionException: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:     
- name:Oracle     
- version:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production    
Version 19.15.0.0.0     
- minor version:0     
- major version:19    
Driver:     
- name:Oracle JDBC driver     
- version:19.3.0.0.0        
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("JIRADEV2"."AO_8BAD1B_BOOTSTRAP"."ID") 

Also we have done full re-indexing and also enabled the disabled triggers, but we have the below error messages,

ORA-04098: trigger 'JIRADEV2.AO_8BAD1B_BOOTSTRAP_ID_autoinc' is invalid and failed re-validation at com.almworks.jira.structure:ww-structure//templates/structure/admin/configuration.vm[line 14, column 18] 

...

..

Caused by: Error : 4098, Position : 12, Sql = INSERT INTO "AO_8BAD1B_BOOTSTRAP" ("C_IS_LOCKED") VALUES (:1 ) RETURNING ID INTO :2 , OriginalSql = INSERT INTO "AO_8BAD1B_BOOTSTRAP" ("C_IS_LOCKED") VALUES (?) RETURNING ID INTO ?, Error Msg = ORA-04098: trigger 'JIRADEV2.AO_8BAD1B_BOOTSTRAP_ID_autoinc' is invalid and failed re-validation at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ... 422 more 

[Prakash Selladurai]

Hi Team, I have tried one more time xml data restore with DB cleanup. But again after 90% xml data restore has been blocked. Nothing has been moved. Later i have restarted and started full re-indexing. 

But Application is not good and few data are missing and few tables are missing.