"A comment must have an issue id specified" error during project import
During project import, the error will thrown in the JIRA logs and stop the project import.
The following appears in the
2012-07-18 12:59:04,562 JiraTaskExectionThread-2 WARN vadmin45 778x2212x1 103sh2j 10.1.4.64 /secure/admin/ProjectImportSelectProject.jspa [imports.project.handler.ChainedSaxHandler] Encountered a parsing exception. com.atlassian.jira.exception.ParseException: A comment must have an issue id specified.
There are comments that are not referring to any issue.
Run the following to verify that there is comment that not referring to issue in database:
select * from jiraaction where issueid is null and actiontype = 'comment';
- If the above query returns any result, perform the following:
- Backup the source database
- Shutdown the source JIRA
Run the following to remove the entries:
delete from jiraaction where issueid is null and actiontype = 'comment';
- Restart JIRA
- Reindex your JIRA
- Export XML from the source JIRA
- Try to perform the project import again to target JIRA instance
Always backup your database before any import or database modification.
Reindexing will cause the system to be unaccessible.