I've just imported a large number of issues to JIRA from an issue tracker used internal in our company. The conversion is done by transferring the data (of course they are modified to fit the JIRA structure) direkte into Microsoft SQL Server.

After the import JIRA i re-indexed and the Integrity Checker is run. The integrity checker reports errors regarding the Workflow integrity, but the Integrity Checker corrects the errors by itself.

My questions:

1. Are there any problems in this procedure. Do i miss something?

2. When creating new issues, i cant get the pcounter to be correct. If my last imported issue has no. 1000 and i don't have an issue with no. 1, then the new issue that is created from scratch in JIRA is created with no. 1 instead of 1001. I've tried to update the pcounter field in the project table, but this does not solve the problem. Could you point out where the attribute is set.

3. Do i have to update some of the values manually in then SEQUENCE_VALUE_ITEM table after the import? How is this table used?

Thanks for your help.