Hi all,
We are in process of changing from using existing Query DB Node to write to DS Node by using CDTs and we are storing process ID as the primary key into the user business/secondary table. But We are getting a duplicate primary key issue when running for some of the instance.
can appian duplicate process id for different process instance .Any assistance on this would be of great help!!
Discussion posts and replies are publicly visible
According to the documentation, Process IDs are unique within a given Appian instance.
Does all of your data stem from the same environment, or was any migrated from a different environment? In general, we recommend to use an auto-generated primary key, so issues like this don't arise.
Previous post I referenced linked here.
Hi sunnya527 please make sure that you are using process instance id but not the process model id.
As for multiple instances of the same process will produce the same process model Id but different instance id.