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)

Atlassian JIRA | David Currie [Atlassian] | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    h3. Summary In certain cases, the full exception is not displayed h3. Steps to Reproduce Restore a problematic data set (OD was used in this example). h3. Expected Results The backup restores without fail, or if there is an exception it displays the actual stack trace rather than {{getNextException}}. h3. Actual Results The below exception is thrown: {noformat} 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 {noformat}

    Atlassian JIRA | 3 years ago | David Currie [Atlassian]
    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)
  2. 0

    h3. Summary In certain cases, the full exception is not displayed h3. Steps to Reproduce Restore a problematic data set (OD was used in this example). h3. Expected Results The backup restores without fail, or if there is an exception it displays the actual stack trace rather than {{getNextException}}. h3. Actual Results The below exception is thrown: {noformat} 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 {noformat}

    Atlassian JIRA | 3 years ago | David Currie [Atlassian]
    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)

    Root Cause Analysis

    1. 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)

      at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection()
    2. com.atlassian.dbexporter
      DataImporter.doImportNode
      1. com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:31)
      2. com.atlassian.dbexporter.importer.DataImporter.doImportNode(DataImporter.java:63)
      2 frames