issue restoring xml backup

Hi,

We are trying to migrate JIRA from windows to linux, JIRA installation has done on linux machine JIRA version 7.

We have copied attachments directory from windows to linux server, facing issue while restoring XML backup zip formate getting below error please suggest.

As checked on windows JIRA  "dbconfig.xml" it's using HSQL database, On linux JIRA using MYSQL.

 

Error importing data: org.xml.sax.SAXException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Action][updateauthor,meenu][issue,14069][author,meenu][created,2015-02-24 18:57:53.037][id,14091][type,comment][body, Queue panel to be shifted upwards, below the NDNC panel.(Links in the admin panel would be displayed by priority.)---new  Search option on click Enter--new  On demand refresh button on the queue panel(Ph 2)--new  Clickable are on the queue panel needs to be on the entire row.--New  A call to be marked as missed Call Back in the queue panel.—New  Pull time column too be added on the queue panel.----New ][updated,2015-02-24 18:57:53.037] (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\x83\x98\x09Qu...' for column 'actionbody' at row 1)) java.lang.Exception: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Action][updateauthor,meenu][issue,14069][author,meenu][created,2015-02-24 18:57:53.037][id,14091][type,comment][body, Queue panel to be shifted upwards, below the NDNC panel.(Links in the admin panel would be displayed by priority.)---new  Search option on click Enter--new  On demand refresh button on the queue panel(Ph 2)--new  Clickable are on the queue panel needs to be on the entire row.--New  A call to be marked as missed Call Back in the queue panel.—New  Pull time column too be added on the queue panel.----New ][updated,2015-02-24 18:57:53.037] (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\x83\x98\x09Qu...' for column 'actionbody' at row 1)) 

Regards,

 

Vivek Pal.

 

2 answers

1 accepted

Thanks David, Now issue has been resolved we have recreated database with utf-8. it's working fine. Thanks.

do you check the database user defined in dbconfig.xml exist in your MySQL server?

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Fadoua M. Boualem
Published Monday in Trello

Using Trello to manage events

As a Jira power user, I was at first doubtful that Trello could benefit my workflow. Jira already uses boards (ones you can customize!), so why would I even need to use Trello?! In this post you will...

502 views 8 9
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you