How are Issue ID numbers assigned in EPM?

[Ivor Davies]

Each SharePoint website in EPM DOES HAVE unique issue number ID’s.

I have confirmed this by going back to all of my project sites in EPM and
looking at the issues. Each site has a number 1 issue (for those that I
created issues for) .

If each project site in EPM has it's own unique issue numbering system and
the each project is not sharing a project site with any other project, then
we have a significant problem with the EPM Issue Management System!

We have currently opened 295 issues in EPM for one specific project. The
last issue opened in the site in EPM was logged as Issue ID #1968. If each
project site in EPM has it's own unique issue numbering system and the EPM
site is not sharing a project site with any other project, this means that
someone has logged and deleted 1673 issues. (True??).

I am very confident that no member of the projoect team has deleted any
issues, but even if every team member did delete one or two issues in error,
there is no way that we could have deleted 1673 issues.

So how come the last issue # is 1968?

How does EPM assign issue id numbers? I thought that it would be in a
sequential order? Is this not true?

Any assistance would be greatly appreciated.

Thank You.

Ivor

 

[Rod Gill]

Every time you make an edit to an Issue or Risk, SharePoint Services makes a
new record in the UserData table. Only the new version has the Current flag
set to 1. The Id you are looking at is possibly the one that reflects the
number of records. I think there is another ID that is just the number for
each Issue.

In addition, if you combine the Issue number with the site GUID you do get a
unique number for all issues across all projects.

 

[Ivor Davies]

Thanks Rod for your quick response.

This makes sense - I also was able to get an actual confirmation from
Microsoft and they concur with your resolution.

I will do some further investigation and testing to confirm.

Thank you very much again for getting back to me on this so quickly!

Take Care..

Ivor

 

[Ivor Davies]

Rod - one other question..

Does EPM use any logic when it re-numbers a Issue ID number whenever a new
version of an issue is saved / updated?

For example I have issue # 15 and the next issue is #22 (does this mean that
Issue #22 has seven updates - or does Issue #15 have seven updates?). I've
tried to come across some pattern in how the renumbering occurs, but so far I
haven't been able to decipher how EPM re-numbers the subsequent (following)
issues?

Any ideas?

Thanks so much!

Ivor

 

[Rod Gill]

As far as I'm aware there is the number used in PWA that increments one for
each new issue.

The internal ID increments one for each edit.