1.

While importing JIRA XML to JIRA Instance with PostGre SQL following exception is thrown; what is the reason?

Answer»

GenericEntityException: ERROR importing data: java.lang.Exception:

com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while

inserting: [GenericEntity:Action][id,31274][body......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)

The import process to POSTGRESQL is trying to interpret plain-text comments as UTF-8 characters

and will END up with the above errors because of the NULL values in the data.

Solution is to unzip the FILE and remove null characters or use utility like XMLCleaner to remove

such NULL Characters.


Discussion

No Comment Found

Related InterviewSolutions