How to find out missing numbers from workitem ID sequence?
![]()
I added 2 work items and the sequencing was off. 406 (SCR work item type) and 427 (SIR work item type).
But I see that there are no other workitems created between 406 and 427, how to figure out what happened with the sequencing and what took away the missing numbers from sequence? |
4 answers
![]()
I mentioned before, the number is 'taken' at the beginning of workitem create, when the editor comes up if there is a ui, long before the save. if the save never happens the number is still consumed, but not used.. abandonded if you will.
the only thing you CAN say is that the number ill INCREASE between two workitems created in sequence. the internal details of when the counter gets increments are not documented. |
![]()
Type any of those 'missing' numbers in the 'Search Work Items' textbox in the upper right corner.
As someone highlighted in another post, you may not have access to those work items or they might have been deleted.
Comments It was late night and I don't think any body must have created so many workitems in one night and deleted them. Am I missing something that I need to be aware of from workitems ID generation? I tried searching for workitems 407, 420, and get the below error:
Error!
Error fetching or storing Work Item 420 | Details: Could not load work item. A work item with that number may not exist
Hence I believe they don't exist. Please let me know your thoughts
Why is this such a burning issue ? There is a single counter for work item id used by all project areas within an RTC repository. Unless you are a JazzAdmin you could get the error because you cannot read some work item or another because it is not in a project area for which you have read authority. I'd suggest taking this up with the administrators of your rtc repository.
Thanks for your response. I understand this is not a burning issue but it will be to the project when I start migrating workitems from my current system into RTC and the workitem ID's go off sequence with I having no proper explanation on why it happened... I am the JazzAdmin for the project area but was still getting the error (that I provided above) while trying to access workitems between 406-427. What are your thoughts, why would the ID's disappear? If you import from another system, you can add a custom attribute of type text where you can store the original number for reference in older documents. You will never be able to import the work items with the same numbers of your old system.
yes, got that. I am referring to, if I import 999 workitems, there ID that get generated are expected to be sequential...but from above scenario it doesn't look confirmed. Also, if my last workitem in RTC is 101, will the next one that I import be 102 for sure?
If nothing else is happening on this server, it should be sequential, but there is no guaranty. when I worked on a migration process at one prior customer, we imported 15,000 workitems on a system where my job was the only one doing this work.
showing 5 of 6
show 1 more comments
|
![]()
Pravin,
I've never experienced the behaviour you described.
Unfortunately, RTC does not keep track of deleted work items.
I would suggest to contact IBM support to see if they can help to locate those 'missing' IDs.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.