com.atlassian.activeobjects.spi.ActiveObjectsImportExportException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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}
    via by David Currie [Atlassian],
  • 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}
    via by 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) at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:31) at com.atlassian.dbexporter.importer.DataImporter.doImportNode(DataImporter.java:63)
    No Bugmate found.