topic Re: Getting Duplicate Unique IDs with NextSequenceValue in Attribute Rules Questions

Getting Duplicate Unique IDs with NextSequenceValue

JennaWalz3 — Fri, 29 Mar 2024 15:26:22 GMT

I have created an attribute rule that creates a Unique ID based on the next number in the sql database sequence. When a public user submits an entry through Survey 123 it will create this Unique ID. I have noticed that sometimes two entries will have duplicate Unique IDs. I thought it could be a time delay issue but the creation date/time is a few hours apart. Any ideas?

Re: Getting Duplicate Unique IDs with NextSequenceValue

HusseinNasser2 — Mon, 01 Apr 2024 23:15:53 GMT

This should not be possible , as NextSequenceValue simply queries the database for the next sequence (using .nextval) and databases often handle that really well.

It could be that the app is overwriting the value somehow via an update. Check the creation user/last updated for the duplicate unique id which one is newer is probably the duplicate, also to be safe make the field uneditable.

If you are using branch versioning or archiving you can use the history to investigate how the unique id happened to be.

Do you know what is the database?

Re: Getting Duplicate Unique IDs with NextSequenceValue

JennaWalz3 — Tue, 02 Apr 2024 13:01:43 GMT

It is an SQL database, and we are using branch versioning.

Re: Getting Duplicate Unique IDs with NextSequenceValue

JennaWalz3 — Tue, 02 Apr 2024 13:07:32 GMT