Error when migrating exported OnDemand data to self-hosted JIRA

Rory Kiefer January 22, 2014
The following error message appears when I try to import data from an OnDemand JIRA instance (clearslide.atlassian.net) to a self-hosted version of JIRA: Error importing data: org.xml.sax.SAXException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Action][id,12192][body,Got this error on Salesforce integration set up page: API Failed: ; nested exception is: java.lang.IllegalArgumentException: The char '0x1a' after '��-�' is not a valid XML character.][author,talwinder singh][updated,2013-12-10 16:39:27.069][created,2013-12-10 16:39:27.069][issue,11774][type,comment][updateauthor,talwinder singh] (SQL Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xEF\xBF\xBD\xEF\xBF\xBD...' for column 'actionbody' at row 1)) java.lang.Exception: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Action][id,12192][body,Got this error on Salesforce integration set up page: API Failed: ; nested exception is: java.lang.IllegalArgumentException: The char '0x1a' after '��-�' is not a valid XML character.][author,talwinder singh][updated,2013-12-10 16:39:27.069][created,2013-12-10 16:39:27.069][issue,11774][type,comment][updateauthor,talwinder singh] (SQL Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xEF\xBF\xBD\xEF\xBF\xBD...' for column 'actionbody' at row 1))

1 answer

1 accepted

1 vote
Answer accepted
AgentSmith
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 2, 2014

Just to follow up ... In this case, the MySQL DB wasn't established or configured.

https://confluence.atlassian.com/display/JIRA061/Connecting+JIRA+to+MySQL

Suggest an answer

Log in or Sign up to answer