Skip navigation
Currently Being Moderated

Process ID numbering

Nov 2, 2011 12:04 AM

Hi,

 

We have a long-lived Process, which my client has noticed some inconsistency in the numbering.

 

i.e. In the Admin UI Process List, we can see (in Chronological order from oldest to newest creation date) the following IDs:

 

  • 901
  • 915
  • 916
  • 810
  • 923
  • 926
  • 927
  • 812
  • 816
  • 817
  • 818

 

Can someone explain why the ordering appears out of order (note - this is not a cluster, but a single server running on SQL server database).  Also, can you confirm it will maintain referential integrity ... i.e. if the number keeps incrementing from 818, we won't get a duplicate of a previous ID such as 901

 

Thanks!

 
Replies
  • Currently Being Moderated
    Nov 2, 2011 7:51 AM   in reply to Tim Goodman

    Is it possible you are looking at a view by status? For example, the list contains completed processes in chronological order.

     

    Steve

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 13, 2011 9:28 PM   in reply to Tim Goodman

    The list is ordered in most recently updated Process Instance at top.

     

    i.e. If you notice the Update Date/Time, you will find that the recently modified process will appear first. That is how it is ordered.

     

    Nith

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 23, 2011 7:28 AM   in reply to Tim Goodman

    As odd as it sounds there is no guarantee that the process ids,or Task Ids, will be in consecutive order. 

     

    Numbers are assigned in blocks (task are blocks of 100, not sure block size for proc instances). When the server starts it looks for next starting block number. That's why you get taskid = 1 for a new install and then after restarting the server you get taskid starting at 101.  The same conept works with Process IDs as well.

     

    If you require an ID value to be in a consecutive order then your best bet would be to assign your own ID as process field and then expose that process field to the end user which would allow the user to sort on that ID.

     

    Hope that helps,

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 24, 2011 7:26 PM   in reply to Tim Goodman

    In normal scenarios, the Process Id will be in the order of increasing

    sequence. However, sometimes we noticed that there is a deviation in that.

     

    At any case, the Process Id is always unique across each server / server

    clusters.

     

    Nith

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points