Migration error

[Wilco van Rooij]

Hi all,

We recently went from onDemand to the Hosted version of Jira.
I've been trying to import all our existing issues without any success unfortunately.

Getting the following error after about 30% of the import:

Error importing data: org.xml.sax.SAXException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Action][id,16121][body,😳][author,wilco][updated,2013-11-29 14:44:04.14][created,2013-11-29 14:44:04.14][issue,15326][type,comment][updateauthor,wilco] (SQL Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xF0\x9F\x98\xB3' for column 'actionbody' at row 1)) java.lang.Exception: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Action][id,16121][body,😳][author,wilco][updated,2013-11-29 14:44:04.14][created,2013-11-29 14:44:04.14][issue,15326][type,comment][updateauthor,wilco] (SQL Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xF0\x9F\x98\xB3' for column 'actionbody' at row 1))

Seems to be a database error, however I do not know how to fix this.

systeminfo:

Windows server 2008 R2 Enterprise (VM)
Apache 2.2.21
Latest Jira installation (6.2)

Thanks in advance!

[Timothy · Accepted solution]

Looks like there are some corrupted content in your data. I would recommend opening up the XML files and cleaning them out manually.