NMSRECIPIENT.IRECIPIENTID reset

Question

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

Amine_Abedour · Accepted Answer

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

Br,

Amine

Translate

Jyoti_Yadav · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO