Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Incorrect string value

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.

2 answers

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.

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.

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/

Hello @Brent Deirocini

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

4,396 views 5 15
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you