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
