Issues Not Imported from Bugzilla
Symptoms
Importing issues from Bugzilla into JIRA runs fine with everything imported including users, projects, versions, components, etc. However, 0 (zero) issues is imported.
The following appears in the import log (available upon import completion):
2014-07-03 15:48:54,887 INFO - Importing: Issues
2014-07-03 15:48:54,887 INFO - ------------------------------
2014-07-03 15:48:54,887 INFO - Only new items will be imported
2014-07-03 15:48:55,012 INFO - 0 issues successfully created
2014-07-03 15:48:55,012 INFO - ------------------------------
2014-07-03 15:48:55,013 INFO - Finished Importing : Issues
2014-07-03 15:48:55,013 INFO - ------------------------------
2014-07-03 15:48:55,015 INFO - Rewriting old issue keys for 0 issues
Diagnosis
The step of importing issues finishes very quickly and the following message is displayed on JIRA UI (always 0 issues):
Troubleshooting further, there's no External Issue ID custom field created in JIRA, which should be a must.
Usually Bugzilla is installed with MySQL. If the database that Bugzilla uses is actually MySQL, then this article is applicable.
Cause
There's no MySQL Connector/J driver in JIRA or the version of this driver is older than 5.1.13.
If Bugzilla is using MySQL, then a MySQL Connector/J driver needs to be available in JIRA, no matter whether JIRA is using MySQL or not. More information can be found here.
If no driver is available or the version is older than 5.1.13, JIRA will fail to retrieve issues from Bugzilla.
Resolution
- Download a newer version of MySQL Connector/J than 5.1.13
- Put it into the folder JIRA_Install/lib
- Restart JIRA and try the import again