Incorrect string value

[Brent Deirocini]

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.

[sergeyprikhodko]

Hello @Brent Deirocini

Did you fix your problem? I have the same problem while migrating, there is no solution in whole internet :(

[Petter Gonçalves]

Hello Brent,

Sorry to hear you are facing problems to import your XML backup.

Searching for similar errors, I was able to find two possible scenarios that could be causing it:

1 - JIRA throws a Syntax error when restoring from a XML backup

2 - There was an error during import/export with <unknown plugin>:Could not import data

Please, check if one of the articles above helps.

If both scenarios above do not apply to you, please provide us the following information:

- Have you taken the XML backup from a different instance?

- Does the version from the XML file and your current JIRA server instance match?

- Is the Service Desk Notifications Plugin inactive in your JIRA instance? 

Let us know if this information helps.

[Brent Deirocini]

Hello Petterson,

Thank you for taking your time to assist. The provided links are something I have looked into but does not match my issue.

1- All primaryKey parameters are set for each table with only ONE set to true in each table section.

2- Nothing too big for the columns as the columns with paragraphs or comments are set to Longtext data type.

Questions/Answers
- Have you taken the XML backup from a different instance?

--- The XML backup is from our current JIRA instance which is on a Windows Server and I am migrating to a Linux instance

- Does the version from the XML file and your current JIRA server instance match?

--- Yes, they are currently both on version 7.9.0. Once I can migrate successfully, I will be updating to the latest version I can without breaking any Plugins we use.

- Is the Service Desk Notifications Plugin inactive in your JIRA instance? 

--- No, the Service Desk plugin is enabled.

[Petter Gonçalves]

Hello Brent,

Thank you for your detailed answer.

Per your description, I think we will need to go deeper in the JIRA logs to better troubleshoot the problem.

That been said, please contact our internal support so you can provide them with your log files:

https://support.atlassian.com/contact/