Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Why might I see duplicate issue numbers in the Issue Manager GUI or Database?

Why might I see duplicate issue numbers in the Issue Manager GUI or Database?

Problem:

Why might I see duplicate issue numbers in the Issue Manager GUI or Database?

Resolution:

ANSWER
----------------------------------
Duplicate issue numbers may be created if users continue to create issues during an upgrade or when a database is being imported.
This will happen because during an import the appsetting table containing the current highest DefectID is imported first then the import of the Defects themselves starts (this may take some time). If a new issue is entered between importing the appsetting table and finishing the defect import the appsetting table is no longer up-to-date. Therefore the system will think that it can use numbers from the appsetting table in sequence even though those numbers have already been allocated in the DefectID table.

To avoid this happening ensure that no users attempt to log new issues during a database import.

If you experience this issue please contact support before attempting to delete or change duplicate database entries. Failure to do so could result in database failure.

Old KB# 23693

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:37
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.