NMSRECIPIENT.IRECIPIENTID reset

[Prasanna_Soni]

It appears we have taken over all values of NMSRECIPIENT.IRECIPIENTID and its time to reset? Anyone else faced similar issue ? 

[Amine_Abedour · Accepted solution]

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

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 :

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

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

[Jyoti_Yadav]

Hi @Prasanna_Soni ,

Are you keeping all the records since the start of application? If no, then you must have designed some cleanup workflow to delete recipient data after 'n' number of years.

In that case, you can design another workflow to look for primary key gaps in your recipient table and then point out your Id to start counting for that point. Make sure the gap is sufficient enough to add data in the table without giving 'Primary Key Exhaustion'  or 'Primary Key already exist' error.

Thanks,

Jyoti