Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-38241

Exception is not displayed, only getNextException when importing an XML backup with AO data

    XMLWordPrintable

Details

    Description

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      Summary

      In certain cases, the full exception is not displayed

      Steps to Reproduce

      Restore a problematic data set (OD was used in this example).

      Expected Results

      The backup restores without fail, or if there is an exception it displays the actual stack trace rather than getNextException.

      Actual Results

      The below exception is thrown:

      2014-05-09 09:52:11.237158500 2014-05-09 09:52:11,231 JiraImportTaskExecutionThread-1 ERROR sysadmin 589x503x1 1wxmsp1 59.167.133.1,59.167.29.217 /secure/admin/StudioImport!import.jspa [jira.bc.dataimport.DefaultDataImportService] Error during ActiveObjects restore
      2014-05-09 09:52:11.237162500 com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin CustomWare JIRA Connector Plugin(net.customware.plugins.connector.atlassian.jira-connector-plugin) #1.4.7 (table AO_3A3ECC_JIRACOMMENT_MAPPING):
      2014-05-09 09:52:11.237182500 at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:30)
      2014-05-09 09:52:11.237184500 at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.flush(DataImporter.java:539)
      2014-05-09 09:52:11.237186500 at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.close(DataImporter.java:545)
      2014-05-09 09:52:11.237187500 at com.atlassian.dbexporter.importer.DataImporter.importTable(DataImporter.java:137)
      2014-05-09 09:52:11.237188500 at com.atlassian.dbexporter.importer.DataImporter.access$000(DataImporter.java:35)
      2014-05-09 09:52:11.237189500 at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:75)
      2014-05-09 09:52:11.237202500 at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:64)
      2014-05-09 09:52:11.237203500 at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:31)
      2014-05-09 09:52:11.237203500 at com.atlassian.dbexporter.importer.DataImporter.doImportNode(DataImporter.java:63)
      2014-05-09 09:52:11.237204500 at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:49)
      2014-05-09 09:52:11.237206500 at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73)
      2014-05-09 09:52:11.237207500 at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:158)
      2014-05-09 09:52:11.237208500 at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:503)
      2014-05-09 09:52:11.237210500 at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:690)
      2014-05-09 09:52:11.237212500 at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:299)
      2014-05-09 09:52:11.237213500 at com.atlassian.jira.studio.importer.StudioDataImportAsyncCommand.call(StudioDataImportAsyncCommand.java:156)
      2014-05-09 09:52:11.237214500 at com.atlassian.jira.studio.importer.StudioDataImportAsyncCommand.call(StudioDataImportAsyncCommand.java:55)
      2014-05-09 09:52:11.237218500 at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179)
      2014-05-09 09:52:11.237219500 at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:150)
      2014-05-09 09:52:11.237220500 at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      2014-05-09 09:52:11.237221500 at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      2014-05-09 09:52:11.237266500 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      2014-05-09 09:52:11.237267500 at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      2014-05-09 09:52:11.237268500 at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      2014-05-09 09:52:11.237269500 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      2014-05-09 09:52:11.237270500 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      2014-05-09 09:52:11.237272500 at java.lang.Thread.run(Thread.java:662)
      2014-05-09 09:52:11.237272500 Caused by: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO public."AO_3A3ECC_JIRACOMMENT_MAPPING" ("COMMENT_ID", "ID", "ISSUE_ID", "IS_NATIVE", "NATIVE", "PARENT_ID", "REMOTE_ID", "REMOTE_OBJECT_TYPE", "REMOTE_SYSTEM_ID") VALUES ('18698', '41', '17153', NULL, NULL, '12', 'TicketSharing', 'comment', '23') was aborted.  Call getNextException to see the cause.
      2014-05-09 09:52:11.237279500 at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2586)
      2014-05-09 09:52:11.237281500 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1811)
      2014-05-09 09:52:11.237282500 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
      2014-05-09 09:52:11.237283500 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2725)
      2014-05-09 09:52:11.237284500 at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      2014-05-09 09:52:11.237286500 at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      2014-05-09 09:52:11.237287500 at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.flush(DataImporter.java:528)
      2014-05-09 09:52:11.237288500 ... 25 more
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              dcurrie@atlassian.com Dave C
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated: