Restoring jira from XML - problem restoring ActiveObjects data for the plugin Email This Issue

[Tomáš Burda]

Hello,

we are using facing following problem:

Via jira gui (/secure/admin/XmlRestore!finish.jspa) I can see:

There was a problem restoring ActiveObjects data for the plugin Email This Issue(com.metainf.jira.plugin.emailissue) #7.0.21-jira6 plugin. Importing table AO_544E33_AUDIT_LOG_ENTRY failed. Please check the log for details.

Jira version: 6.4.14

Email this issue version: 7.0.21-jira6

We were using Mysql and we are migrating to PostgreSQL

Log output can be seen in comments.

We welcome any advice.

[cuong hoang]

For us null values were causing this error. We found only 4 email log entries with null by querying the database, then we deleted through the user interface.

[Thorsten Letschert [Decadis AG]]

Any updates on this? We ran into a similar case last week and were unable to find a workaround yet.

[Thorsten Letschert [Decadis AG]]

@Tomáš_Burdahave you been successful in the meantime?

[Tomáš Burda]

Hello.

i workarounded this by doing database dump

and restore to new db.

But we had to still use mysql.

[Tomáš Burda]

2017-04-06 14:48:15,176 JiraImportTaskExecutionThread-1 WARN admin 875x162x1 17m1ei6 10.32.126.106,0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [dvcs.dao.impl.CachingOrganizationDaoImpl] onImportCompleted - clearing cache !!
2017-04-06 14:48:15,181 JiraImportTaskExecutionThread-1 INFO admin 875x162x1 17m1ei6 10.32.126.106,0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Importing data is 100% complete...
2017-04-06 14:48:15,181 JiraImportTaskExecutionThread-1 INFO admin 875x162x1 17m1ei6 10.32.126.106,0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished.

[Tomáš Burda]

Caused by: java.sql.BatchUpdateException: Batch entry 1,461 INSERT INTO public."AO_544E33_AUDIT_LOG_ENTRY" ("ADD_COMMENTS", "ADD_TO_WATCHERS", "ATTACHMENTS", "BCC", "CC", "EMAIL_BODY", "EMAIL_FORMAT", "EMAIL_SUBJECT", "FROM", "FROM_NAME", "ID", "ISSUE_ID", "ISSUE_KEY", "ISSUE_SUMMARY", "MAIL_AS_ME", "REPLY_TO_ME", "SENDER_KEY", "SENDER_NAME", "SEND_TIME_STAMP", "SOURCE", "TEMPLATE_ID", "TEMPLATE_NAME", "TO", "TYPE", "RECIPIENTS") VALUES ('0', '0', NULL, NULL, NULL, .......

[Tomáš Burda]

was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:459)
at org.postgresql.core.v3.QueryExecutorImpl$ErrorTrackingResultHandler.handleError(QueryExecutorImpl.java:348)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1090)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:398)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.flush(DataImporter.java:528)
... 24 more

[Tomáš Burda]

[jira.bc.dataimport.DefaultDataImportService] Importing data is 89% complete...
2017-04-06 14:47:59,324 JiraImportTaskExecutionThread-1 INFO admin 875x162x1 17m1ei6 10.32.126.106,0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Importing data is 90% complete...
2017-04-06 14:48:04,854 JiraImportTaskExecutionThread-1 INFO admin 875x162x1 17m1ei6 10.32.126.106,0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Finished storing Generic Values.
2017-04-06 14:48:15,151 JiraImportTaskExecutionThread-1 ERROR admin 875x162x1 17m1ei6 10.32.126.106,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 Email This Issue(com.metainf.jira.plugin.emailissue) #7.0.21-jira6 (table AO_544E33_AUDIT_LOG_ENTRY):
at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:30)
at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.flush(DataImporter.java:539)
at ...

[Tomáš Burda]

at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.executePS(DataImporter.java:515)
at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.execute(DataImporter.java:473)
at com.atlassian.dbexporter.importer.DataImporter.importTable(DataImporter.java:127)
at com.atlassian.dbexporter.importer.DataImporter.access$000(DataImporter.java:35)
at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:75)
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)
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:164)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:572)

[Tomáš Burda]

at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:773)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:332)
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:177)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:148)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)