-
Bug
-
Resolution: Fixed
-
Low
-
JCMA - 1.11.13, JCMA - 1.12.6
-
None
-
8
-
Minor
-
4
Issue Summary
Once the JCMA assessment is ready, an error like the examples below may be encountered:
Oracle:
<TIMESTAMP> <THREAD_NAME> url: /internal-error ERROR [jira.web.servlet.InternalServerErrorServlet] {errorId=8a62fb7e-7333-46b0-b806-85946c556458, interpretedMsg=, cause=com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: {DATABASE_INFO} java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (JIRADC03.fk_ao_6ff49d_node_n1642083336) violated - child record found , stacktrace=com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: {DATABASE_INFO} java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (JIRADC03.fk_ao_6ff49d_node_n1642083336) violated - child record found ... Caused by: Error : 2292, Position : 0, Sql = DELETE FROM "AO_6FF49D_NODE_INFRASTRUCTURE" WHERE "ID" IN (:1 ), OriginalSql = DELETE FROM "AO_6FF49D_NODE_INFRASTRUCTURE" WHERE "ID" IN (?), Error Msg = ORA-02292: integrity constraint (JIRADC03.fk_ao_6ff49d_node_n1642083336) violated - child record found at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) [ojdbc8.jar:ABCD_ip_123.0] ... 367 more
Postgres
"url": "https:/jira.exampleserverurl.com/rest/migration/latest/instance/assessment/csv", "compression": -30, UUID: dd1a9999-6899-999e-xxxx-9898f01ab9c Referer URL: https://jira.exampleserverurl.com/secure/migration-appaction.jspa com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:14.10t- minor version:10 - major version:14 Driver: - name:PostgreSQL JDBC Driver - version:42.7.2 org.postgresql.util.PSQLException: ERROR: update or delete on table "AO_6FF49D_NODE_INFRASTRUCTURE" violates foreign key constraint "fk_ao_6ff49d_node_network_infrastructure_id" on table "AO_6FF49D_NODE_NETWORK" Detail: Key (ID)=(1) is still referenced from table "AO_6FF49D_NODE_NETWORK". There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:14.10 - minor version:10 - major version:14 Driver: - name:PostgreSQL JDBC Driver - version:42.7.2 org.postgresql.util.PSQLException: ERROR: update or delete on table "AO_6FF49D_NODE_INFRASTRUCTURE" violates foreign key constraint fk_ao_6ff49d_node_network_infrastructure_id on table "AO_6FF49D_NODE_NETWORK" Detail: Key (ID)=(1) is still referenced from table "AO_6FF49D_NODE_NETWORK"
Steps to Reproduce
We weren't able to determine how to reproduce this on our end in our test environments.
Expected Results
The customer will be able to download the report.
Actual Results
The customer encounters a 500 error. SQL constraint violation errors are logged by Jira.
Workaround
- Log into the Jira Database
Create a backup of the Database
- Run these 2 SQL queries in the order specified below:
-- Execute this first DELETE * FROM "AO_6FF49D_NODE_NETWORK"; -- Execute this second DELETE * FROM "AO_6FF49D_NODE_INFRASTRUCTURE";
- Try to download the report again
- is related to
-
MIG-1956 Jira Cloud Migration plugin causes intensive resource consumption
-
- Short Term Backlog
-
- relates to
-
ASSESS-645 Loading...