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
  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)
  3. 0

    h4. Summary of the issue Importing XML site backup from a SQL Server-based or PostgreSQL-based Confluence to a MySQL-based Confluence fails due to size limit for DATA column in AO_9412A1_AOREGISTRATION table (maximum size limit is 65535). In SQL Server-based or PostgreSQL-based Confluence database, DATA column in AO_9412A1_AOREGISTRATION table datatype is set to {{NTEXT}} and {{TEXT}} respectively. These 2 datatypes can hold string up to 1GB or 1073741823 bytes/characters. In the other hand, it seems that in the Active Object, the biggest string-based data type for MySQL is TEXT. Which could only hold data up to 65535 characters/bytes. Therefore, any data/value in TEXT/NTEXT-based column that contains more than 65535 characters/bytes in the SQL Server-based or PostgreSQL-based Confluence database, would fail/skipped during the import to MySQL-based Confluence. The following appears in the log: {code} 2012-12-27 15:03:02,109 WARN [Long running task: Importing data] [activeobjects.confluence.backup.LoggingRestoreProgressMonitor] beginRestore Begin restoring Active Objects backup, adjust log level for com.atlassian.activeobjects.confluence.backup for more detailed logging. -- referer: http://localhost:8090/admin/backup.action | url: /admin/restore-local-file.action | userName: admin | action: restore-local-file 2012-12-27 15:03:04,360 ERROR [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import -- referer: http://localhost:8090/admin/backup.action | url: /admin/restore-local-file.action | userName: admin | action: restore-local-file com.atlassian.confluence.importexport.ImportExportException: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Notifications and Tasks - Host Plugin(com.atlassian.mywork.mywork-confluence-host-plugin) #1.0.3:Could not import data in table 'AO_9412A1_AOREGISTRATION' column #1, value is too big for column which size limit is 65535, value is: {<A very long value is here>} at com.atlassian.activeobjects.confluence.backup.ActiveObjectsBackupRestoreProvider.restore(ActiveObjectsBackupRestoreProvider.java:39) at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importPluginData(FileBackupImporter.java:353) at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:134) at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:151) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:143) at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75) at com.atlassian.confluence.importexport.DefaultImportExportManager.doImport(DefaultImportExportManager.java:67) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy102.doImport(Unknown Source) at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:81) at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:26) at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:35) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Notifications and Tasks - Host Plugin(com.atlassian.mywork.mywork-confluence-host-plugin) #1.0.3:Could not import data in table 'AO_9412A1_AOREGISTRATION' column #1, value is too big for column which size limit is 65535, value is: {<A very long value is here>} at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportException(ImportExportErrorServiceImpl.java:24) at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.setString(DataImporter.java:363) at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.setValue(DataImporter.java:409) at com.atlassian.dbexporter.importer.DataImporter.importTable(DataImporter.java:123) at com.atlassian.dbexporter.importer.DataImporter.access$000(DataImporter.java:33) at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:73) at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:62) at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:31) at com.atlassian.dbexporter.importer.DataImporter.doImportNode(DataImporter.java:61) at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:49) at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:158) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy338.restore(Unknown Source) at com.atlassian.activeobjects.confluence.backup.ActiveObjectsBackupRestoreProvider.restore(ActiveObjectsBackupRestoreProvider.java:35) ... 28 more {code} h4. Workaround Rather than importing the Site XML backup during setup wizard, install a fresh MySQL-based Confluence. Then go to Confluence Admin > Backup & Restore > Restore the site XML backup. The import should finish successful, but the affected data/rows will be skipped and not imported to the new Confluence database. h4. References - https://developer.atlassian.com/display/AO/AO+0.18.x+Upgrade+Guide#AO0.18.xUpgradeGuide-TypeChanges - http://www.electrictoolbox.com/maximum-length-mysql-text-field-types/ - http://msdn.microsoft.com/en-us/library/ms187993.aspx - http://stackoverflow.com/questions/10395975/maximum-size-of-text-datatype-in-postgresql - Same log with DEBUG logging enabled on: com.atlassian.activeobjects.confluence.backup com.atlassian.dbexporter net.java.ao.sql {code} .... 2012-12-27 19:40:43,596 DEBUG [Long running task: Importing data] [net.java.ao.sql] executeUpdate DROP TABLE AO_9412A1_AOREGISTRATION .... 2012-12-27 19:40:44,818 INFO [Long running task: Importing data] [activeobjects.confluence.backup.LoggingRestoreProgressMonitor] beginTableCreationRestore Begin table creation for : AO_9412A1_AOREGISTRATION 2012-12-27 19:40:44,820 DEBUG [Long running task: Importing data] [net.java.ao.sql] executeUpdate CREATE TABLE AO_9412A1_AOREGISTRATION ( DATA TEXT, ID VARCHAR(255), UPDATED DATETIME, PRIMARY KEY(ID) ) ENGINE=InnoDB 2012-12-27 19:40:44,908 INFO [Long running task: Importing data] [activeobjects.confluence.backup.LoggingRestoreProgressMonitor] endTableCreationRestore Completed table creation for : AO_9412A1_AOREGISTRATION .... 2012-12-27 19:40:45,291 INFO [Long running task: Importing data] [activeobjects.confluence.backup.LoggingRestoreProgressMonitor] beginTableDataRestore Begin restoring table data for : AO_9412A1_AOREGISTRATION 2012-12-27 19:40:45,403 ERROR [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import -- referer: http://localhost:8090/admin/backup.action | url: /admin/restore-local-file.action | userName: admin | action: restore-local-file com.atlassian.confluence.importexport.ImportExportException: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Notifications and Tasks - Host Plugin(com.atlassian.mywork.mywork-confluence-host-plugin) #1.0.3:Could not import data in table 'AO_9412A1_AOREGISTRATION' column #1, value is too big for column which size limit is 65535, value is: {<A very long value is here>}} at com.atlassian.activeobjects.confluence.backup.ActiveObjectsBackupRestoreProvider.restore(ActiveObjectsBackupRestoreProvider.java:39) at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importPluginData(FileBackupImporter.java:353) at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:134) at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:151) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:143) at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75) at com.atlassian.confluence.importexport.DefaultImportExportManager.doImport(DefaultImportExportManager.java:67) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy81.doImport(Unknown Source) at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:81) at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:26) at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:35) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Notifications and Tasks - Host Plugin(com.atlassian.mywork.mywork-confluence-host-plugin) #1.0.3:Could not import data in table 'AO_9412A1_AOREGISTRATION' column #1, value is too big for column which size limit is 65535, value is: {<A very long value is here>} at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportException(ImportExportErrorServiceImpl.java:24) at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.setString(DataImporter.java:363) at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.setValue(DataImporter.java:409) at com.atlassian.dbexporter.importer.DataImporter.importTable(DataImporter.java:123) at com.atlassian.dbexporter.importer.DataImporter.access$000(DataImporter.java:33) at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:73) at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:62) at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:31) at com.atlassian.dbexporter.importer.DataImporter.doImportNode(DataImporter.java:61) at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:49) at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:158) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy325.restore(Unknown Source) at com.atlassian.activeobjects.confluence.backup.ActiveObjectsBackupRestoreProvider.restore(ActiveObjectsBackupRestoreProvider.java:35) ... 28 more .... {code} - {code:title=home/halatas/src/atlassian/plugins/activeobjects/activeobjects-plugin-0.19.12-sources/net/java/ao/types/TypeManager.java} .... public static TypeManager derby() { return new TypeManager.Builder() .addMapping(blobType(), schemaType("BLOB")) .addMapping(booleanType(), schemaType("SMALLINT").jdbcWriteType(TINYINT).precisionAllowed(true), qualifiers().precision(1)) .addMapping(dateType(), schemaType("DATETIME")) .addMapping(doubleType(), schemaType("DOUBLE")) .addMapping(integerType(), schemaType("INTEGER")) .addMapping(longType(), schemaType("BIGINT")) .addStringTypes("VARCHAR", "CLOB") .build(); } public static TypeManager hsql() { return new TypeManager.Builder() .addMapping(blobType(), schemaType("LONGVARBINARY")) .addMapping(booleanType(), schemaType("BOOLEAN")) .addMapping(dateType(), schemaType("DATETIME")) .addMapping(doubleType(), schemaType("DOUBLE")) .addMapping(integerType(), schemaType("INTEGER")) .addMapping(longType(), schemaType("BIGINT")) .addStringTypes("VARCHAR", "LONGVARCHAR") .build(); } public static TypeManager mysql() { return new TypeManager.Builder() .addMapping(blobType(), schemaType("BLOB")) .addMapping(booleanType(), schemaType("BOOLEAN")) .addMapping(dateType(), schemaType("DATETIME")) .addMapping(doubleType(), schemaType("DOUBLE")) .addMapping(integerType(), schemaType("INTEGER")) .addMapping(longType(), schemaType("BIGINT")) .addStringTypes("VARCHAR", "TEXT") .build(); } public static TypeManager postgres() { return new TypeManager.Builder() .addMapping(blobType(), schemaType("BYTEA")) .addMapping(booleanType(), schemaType("BOOLEAN")) .addMapping(dateType(), schemaType("TIMESTAMP")) .addMapping(doubleType(), schemaType("DOUBLE PRECISION")) .addMapping(integerType(), schemaType("INTEGER")) .addMapping(longType(), schemaType("BIGINT")) .addStringTypes("VARCHAR", "TEXT") .build(); } public static TypeManager sqlServer() { return new TypeManager.Builder() .addMapping(blobType(), schemaType("IMAGE")) .addMapping(booleanType(), schemaType("BIT")) .addMapping(dateType(), schemaType("DATETIME")) .addMapping(doubleType(), schemaType("FLOAT")) .addMapping(integerType(), schemaType("INTEGER")) .addMapping(longType(), schemaType("BIGINT")) .addStringTypes("VARCHAR", "NTEXT") .build(); } public static TypeManager oracle() { return new TypeManager.Builder() .addMapping(blobType(), schemaType("BLOB")) .addMapping(booleanType(), schemaType("NUMBER").precisionAllowed(true), qualifiers().precision(1)) .addMapping(dateType(), schemaType("TIMESTAMP")) .addMapping(doubleType(), schemaType("DOUBLE PRECISION")) .addMapping(integerType(), schemaType("NUMBER").precisionAllowed(true), qualifiers().precision(11)) .addMapping(longType(), schemaType("NUMBER").precisionAllowed(true), qualifiers().precision(20)) .addStringTypes("VARCHAR", "CLOB") .build(); } .... {code} - {code:title=/home/halatas/src/atlassian/plugins/activeobjects/activeobjects-plugin-0.19.12-sources/com/atlassian/dbexporter/importer/DataImporter.java line#352-367} ... private void setString(String value) throws SQLException { if (value == null) { ps.setNull(col, Types.VARCHAR); } else { int maxSize = maxColumnSize.get(col); if (maxSize != -1 && value.length() > maxSize) { throw errorService.newImportExportException(tableName, "Could not import data in table '" + tableName + "' column #" + col + ", value is too big for column which size limit is " + maxSize + ", value is:\n" + value + "\n"); } ps.setString(col, value); } } ... {code}

    Atlassian JIRA | 4 years ago | Husein Alatas [Atlassian]
    com.atlassian.confluence.importexport.ImportExportException: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Notifications and Tasks - Host Plugin(com.atlassian.mywork.mywork-confluence-host-plugin) #1.0.3:Could not import data in table 'AO_9412A1_AOREGISTRATION' column #1, value is too big for column which size limit is 65535, value is: {<A very long value is here>}
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    h3. Summary After restoring a FishEye backup to an Oracle database, the ORA-00955 error may be presented when trying to create AO tables. h3. Environment * Oracle database, configured according to [https://confluence.atlassian.com/fisheye/migrating-to-oracle-298976836.html] h3. Steps to Reproduce # Have a FishEye backup. # Restore it pointing to an Oracle database. h3. Expected Results * Migration completes succesfully and the application runs fine. h3. Actual Results FishEye may fail after some time, with the following showing up in the logs: {noformat} ** Creating table 'AO_2913F5_COMMENT_ISSUE' ERROR: problem running command java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.cenqua.fisheye.FishEyeCtl.mainImpl(FishEyeCtl.java:101) at com.cenqua.fisheye.FishEyeCtl.main(FishEyeCtl.java:44) Caused by: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Inline Issue Creation Plugin for Crucible(com.atlassian.crucible.plugins.jira-ril) #3.5.5-raabb646 (table AO_2913F5_COMMENT_ISSUE):Error executing update for SQL statement 'CREATE SEQUENCE "AO_2913F5_COMMENT_ISSUE_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1' at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:30) at com.atlassian.activeobjects.backup.SqlUtils.onSqlException(SqlUtils.java:53) at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:42) at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:84) at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:62) at com.atlassian.dbexporter.importer.TableDefinitionImporter.doImportNode(TableDefinitionImporter.java:50) at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:49) at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:158) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.atlassian.applinks.host.OsgiServiceProxyFactory$DynamicServiceInvocationHandler.invoke(OsgiServiceProxyFactory.java:111) at com.sun.proxy.$Proxy27.restore(Unknown Source) at com.atlassian.crucible.migration.item.ActiveObjectsBackup$ActiveObjectsRestorer.restore(ActiveObjectsBackup.java:122) at com.cenqua.fisheye.ctl.Restore.run(Restore.java:197) at com.cenqua.fisheye.ctl.Restore.main(Restore.java:273) ... 6 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object {noformat} h3.Workaround # Identify the sequence that is causing the error - this can be done by reviewing the error in the logs. You may find the problematic sequence as follows: {noformat} <CREATE SEQUENCE "AO_60DB71_ISSUERANKING_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1> {noformat} # Stop FishEye/Crucible. # Have your Oracle DBA deleting the existing sequence. # Start FishEye/Crucible. *Note*: the process above may need to be repeated further times if FishEye presents errors for other sequences. It should seize failing again after all the problematic sequences have been deleted.

    Atlassian JIRA | 9 months ago | Gustavo Refosco [Atlassian]
    java.lang.reflect.InvocationTargetException
  6. 0

    h3. Steps to Reproduce: # Create a "Rapid" Board # Configure -> Card Colors -> Queries # Add a long JQL Query (more than 255 characters in length). For example: {noformat} (Status = Open AND "Start Date" >= startOfDay() AND "Start Date" <= startOfDay("+1d")) OR (Status = "Work Started" AND "Start Date" >= startOfDay("-3d") AND "Start Date" < startOfDay("-1d")) OR (Status = "Halfway through" AND "Start Date" >= startOfDay("-9d") AND "Start Date" < startOfDay("-7d")) OR (Status = "Nearly Completed" AND "Start Date" >= startOfDay("-13d") AND "Start Date" < startOfDay("-11d")) {noformat} # Perform an XML Backup. # Perform an XML Restore. h3. Expected Results The Card colour configuration is successfully imported. h3. Actual Results The restore process throws an SQL exception as shown below and the card colour configuration is not restored. {code} 2013-02-28 17:58:08,976 JiraImportTaskExecutionThread-1 ERROR admin 1078x226x1 6zz1tf 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [jira.bc .dataimport.DefaultDataImportService] Error during ActiveObjects restore com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Atlassian GreenHoppe r(com.pyxis.greenhopper.jira) #6.1.1 (table AO_60DB71_CARDCOLOR):Could not import data in table 'AO_60DB71_CARDCOLOR' column #6, value is to o big for column which size limit is 255, value is: (Status = Open AND "Start Date" >= startOfDay() AND "Start Date" <= startOfDay("+1d")) OR (Status = "Work Started" AND "Start Date" >= startOfDay("-3d") AND "Start Date" < startOfDay("-1d")) OR (Status = "Halfway through" AND "Start Date" >= startOfDay("-9d") AND "Start Date" < startOfDay("-7d")) OR (Status = "Nearly Completed" AND "Start Date" >= startOfDay("-13d") AND "Start Date" < startOfDay("-11d")) at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportException(ImportExportErrorServiceImpl.java:24) at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.setString(DataImporter.java:363) at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.setValue(DataImporter.java:409) at com.atlassian.dbexporter.importer.DataImporter.importTable(DataImporter.java:123) at com.atlassian.dbexporter.importer.DataImporter.access$000(DataImporter.java:33) at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:73) at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:62) at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:31) at com.atlassian.dbexporter.importer.DataImporter.doImportNode(DataImporter.java:61) at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:49) at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:158) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:439) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:627) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:251) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61) at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) {code} h5. Workaround # Ensure that the JQL queries are less than 255 characters before the export # OR before importing the backup, edit the {{activeobjects.xml}} in the backup zip file and carefully ensure that the JQL queries are modified to the less that 255 characters.

    Atlassian JIRA | 4 years ago | Michael Stelzner [Communardo]
    com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Atlassian GreenHoppe r(com.pyxis.greenhopper.jira) #6.1.1 (table AO_60DB71_CARDCOLOR):Could not import data in table 'AO_60DB71_CARDCOLOR' column #6, value is to o big for column which size limit is 255, value is: (Status = Open AND "Start Date" >= startOfDay() AND "Start Date" <= startOfDay("+1d")) OR (Status = "Work Started" AND "Start Date" >= startOfDay("-3d") AND "Start Date" < startOfDay("-1d")) OR (Status = "Halfway through" AND "Start Date" >= startOfDay("-9d") AND "Start Date" < startOfDay("-7d")) OR (Status = "Nearly Completed" AND "Start Date" >= startOfDay("-13d") AND "Start Date" < startOfDay("-11d"))

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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