Unable to restore database from xml

[Teradici]

Hi guys, we were trying to migrate database from mysql to postgres database,

following the instructions, but we ended up with error.
What is happening???

Error importing data: org.xml.sax.SAXException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: 
.........

(SQL Exception while executing the following:INSERT INTO public.jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: invalid byte sequence for encoding "UTF8": 0x00))

[Nic Brough -Adaptavist-]

You have characters in your MySQL data that your Postgres database is not set up to support.

I would take the xml you've downloaded from the mysql service and run the xml cleaner on it first - see https://confluence.atlassian.com/jira/removing-invalid-characters-from-xml-backups-12079.html

[Teradici]

Thank you very much. Looks like it is the reason.

Found the record, and it works now