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.