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
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.