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

1 vote
Accepted answer
David Currie Atlassian Team Oct 11, 2015

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

What if I have exactly same issue using MS SQL? All settings done same as provided on website guide. 

Getting same error for PostgreSQL to MS SQL migration.

 

Error importing data: org.xml.sax.SAXException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:IssueLinkType][inward,is duplicated by][id,10000][linkname,Duplicate][outward,duplicates] (SQL Exception while executing the following:INSERT INTO JiraProdSchema.issuelinktype (ID, LINKNAME, INWARD, OUTWARD, pstyle) VALUES (?, ?, ?, ?, ?) (Violation of PRIMARY KEY constraint 'PK_issuelinktype'. Cannot insert duplicate key in object 'JiraProdSchema.issuelinktype'. The duplicate key value is (10000).)) java.lang.Exception: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:IssueLinkType][inward,is duplicated by][id,10000][linkname,Duplicate][outward,duplicates] (SQL Exception while executing the following:INSERT INTO JiraProdSchema.issuelinktype (ID, LINKNAME, INWARD, OUTWARD, pstyle) VALUES (?, ?, ?, ?, ?) (Violation of PRIMARY KEY constraint 'PK_issuelinktype'. Cannot insert duplicate key in object 'JiraProdSchema.issuelinktype'. The duplicate key value is (10000).))

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
Community showcase
Posted yesterday in Statuspage

How do your teams prepare for really high (planned) traffic days like Cyber Monday?

Hi there! Shannon from Statuspage here.  👋  With Cyber Monday quickly approaching, we're looking to hear from Atlassian customers – specifically from teams who touch incident response li...

42 views 0 4
Join discussion

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