I'm using pp!id of a process instance value as orderId field for my db, As I thought it is unique for all process instances, but when I checked It was not. I was wondering is it really unique?
Discussion posts and replies are publicly visible
No. Process IDs are reused.
I just noticed this thread from a few weeks ago - I actually don't expect process IDs to be reused. In the documentation we mention that the IDs are unique and cannot be reused, which allows you to store the process ID in a database table and be confident that you are pointing to the correct process instance in the future: https://docs.appian.com/suite/help/latest/Process_and_Report_Data.html#process-properties
Can you clarify where you're seeing the process instance ID being the same across multiple instances? Do you have a screenshot / example?
Hi Peter,
My assumption is based on the range of numbers I see used for process ids and that each exec engine seems to have its own range. When running a few million processes a day, I have some doubts that the number will last forever.
It is true that each exec engine has different buckets of IDs to use, but the processes should naturally load balance across the engines to have a similar number for each of them.
I think you may have missed Stefan's point (unless I myself am missing something here) --
To reiterate, If a few million processes execute each day, and assuming the Process ID is constrained by the "unsigned integer" boundary, that means all possible unique process IDs may have been used at least once inside... maybe a year, with a heavy enough load? If so, how would they be unique, while still having new ones to assign for new process instances?
Whoops you're right, looks like I submitted without answering the whole question. It is true that this is a limitation, but one that is unlikely to be reached unless there is pretty extreme, extended volume of processes.
Process IDs are not reused but there is a max. Ids range from −2,147,483,647 2,147,483,647. If you use up all 4 billion process ids you won't be able to start any more processes. Even running a 1 million a day, you could run for more than 10 years. We have not had anyone run out of ids so far.