Error parsing export file. Your export file is invalid. This may be due to a CDATA bug in older vers

[Karthikeyan_Rajagopal]

I have installed Jira and connect with MYSQL database now i want to import the xml dump which is exported from existing Jira with H2 database. when i am importing i got this error 

i am using Jira 8.20.1 version

Error parsing export file. Your export file is invalid. This may be due to a CDATA bug in older versions of JIRA (http://jira.atlassian.com/browse/JRA-4980). Exception is org.xml.sax.SAXParseException; lineNumber: 21551129; columnNumber: 20; The end-tag for element type "entity-engine-xml" must end with a '>' delimiter. 

how to resolve this 

[Fabio Racobaldo _Herzum_ · Accepted solution]

Hi @Karthikeyan_Rajagopal ,

please try to apply the following workaround https://confluence.atlassian.com/jira/removing-invalid-characters-from-xml-backups-12079.html

Fabio

[Karthikeyan_Rajagopal]

Thank you for the response. 

[Karthikeyan_Rajagopal]

Hi, I adapted the approach as you refer in the link but this time the error shifted to different  line number 

Error parsing export file. Your export file is invalid. This may be due to a CDATA bug in older versions of JIRA (http://jira.atlassian.com/browse/JRA-4980). Exception is org.xml.sax.SAXParseException; lineNumber: 21550662; columnNumber: 55; XML document structures must start and end within the same entity.