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 Join to answer
Community showcase
Emilee Spencer
Published 6 hours ago in Marketplace Apps

Marketplace Spotlight: DeepAffects

Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...

30 views 0 3
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot