Uploaded image for project: 'Migration Platform'
  1. Migration Platform
  2. MIG-1973

When trying to download the JCMA's Assessment report, a 500 error is displayed and a database constraint violation error is reported

XMLWordPrintable

    • 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

              Unassigned Unassigned
              fbeck Fábio W. [Atlassian] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: