I have been getting the following error on restoring xml backup
==
com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Service Desk Notifications Plugin(com.atlassian.servicedesk.servicedesk-notifications-plugin) #3.12.0-REL-0008 (table AO_4E8AE6_NOTIF_BATCH_QUEUE):
at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:26)
at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.flush(DataImporter.java:429)
at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.close(DataImporter.java:434)
at com.atlassian.dbexporter.importer.DataImporter.importTable(DataImporter.java:120)
at com.atlassian.dbexporter.importer.DataImporter.access$000(DataImporter.java:41)
at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:71)
at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:64)
at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:28)
at com.atlassian.dbexporter.importer.DataImporter.doImportNode(DataImporter.java:64)
at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:44)
at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:69)
at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:151)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:577)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:751)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:324)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:60)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:157)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:133)
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)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xF0\x9F\x93\xB1</...' for column 'HTML_CONTENT' at row 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1162)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1778)
at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1262)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970)
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345)
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345)
at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.flush(DataImporter.java:422)
... 23 more
Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x93\xB1</...' for column 'HTML_CONTENT' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1756)
... 28 more
==
Jira DB and all tables in DB are utf8 character set with utf8_bin collation.
I have even done the Workaround section discussed https://confluence.atlassian.com/confkb/incorrect-string-value-error-thrown-when-restoring-xml-backup-in-confluence-777009599.html and it still gives the error show above.
Any assistance will be great, thank you.
