Avatar

Correct answer by
Level 4

Hello @Prasanna_Soni ,

 

The OOTB schema nms:recipient is set to use the sequence ''XtkNewId'' from table ''XtkNewId'' (yes the sequence and the table share the same name :face_savoring_food:).

 

Amine_Abedour_1-1644335560334.png

The default StoredProcedure that manage the sequences is set to loop back to negative idSeed if the current Seed is greater than 2 100 000 000 :

 

Amine_Abedour_3-1644335636756.png

 

So, theoretically you do not have to worry about it :beaming_face_with_smiling_eyes:.

 

P.S : all the above is true for an instance under the build 8984 using Microsoft SQL Server for database.

 

last but not least, i would like to direct you to this article that explains the sequences exhaustion problem and how to avoid it : https://helpx.adobe.com/customer-care-office-hours/campaign/sequences-exhaustion-campaign-classic.ht...

 

Br,

 

Amine

 

 

 

 

 

View solution in original post