Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!
SOLVED

facing error in delivery sending; Cannot insert duplicate key row in object in neolaneprod.elcbroadlogdcns with unique index id

Avatar

Level 4

Shrutii_0-1701327795158.png

Hi All, 

 

I am facing error in delivery sending; Cannot insert duplicate key row in object in neolaneprod.elcbroadlogdcns with unique index id

upon checking i identified this same duplicate broadlog id is present for one the delivery sent in 2013

Shrutii_1-1701328143053.png

here elcbroadlogdcns  is custom table same as broadlogrcp keep broadlog enteriescan someone please help me with quick resolution for this??

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi Shrutii,

Typically duplicate keys occur when the sequence in the table is close or has run out of available IDs within its 32bit sequence. To address this, there are a few best practices:

 

1) Ensure that in the Deployment wizard that you are keeping only the minimum required logs (see the purge settings in deployment wizard) as long log retention uses up available IDs.

2) Ensure that the Database Cleanup workflow is running fully as that workflow is in charge of purging logs and old deliveries, etc. noted in step 1.

3) Ensure that tables are using custom sequences versus the out of the box xtkNewID. This was one of the biggest causes of this issue, as in older versions of Campaign the tables all shared the same sequence, meaning that the number of available IDs would run out very quickly.

4) If none of the above works, you can consider deploying negative IDs which effectively doubles the amount of available IDs for any given sequence.

 

This type of error has been covered multiple times within the forums and in Campaign Support if you need additional details and assistance. See below:

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/error-duplicate-ke...

Regards,

Craig

View solution in original post

4 Replies

Avatar

Community Advisor

Hi @Shrutii ,

Restart your workflow, mostly this error will get fixed. 

And, to troubleshoot further, go to Tools > Advanced > Deployment wizard > Next > Purge Data

Check how many days has been specified for delivery logs.

ParthaSarathy_0-1701351404470.png

By default it will be 180 days. When it is set to 180 days, 6 months old record will get deleted from cleanup workflow. If the primary key sequence for broad Log schema exhaust, it will again start from beginning. If the delivery log value has been modified in your instance to store delivery logs more than 180 days (Not recommended though...), then you might get this error. 

Avatar

Correct answer by
Employee Advisor

Hi Shrutii,

Typically duplicate keys occur when the sequence in the table is close or has run out of available IDs within its 32bit sequence. To address this, there are a few best practices:

 

1) Ensure that in the Deployment wizard that you are keeping only the minimum required logs (see the purge settings in deployment wizard) as long log retention uses up available IDs.

2) Ensure that the Database Cleanup workflow is running fully as that workflow is in charge of purging logs and old deliveries, etc. noted in step 1.

3) Ensure that tables are using custom sequences versus the out of the box xtkNewID. This was one of the biggest causes of this issue, as in older versions of Campaign the tables all shared the same sequence, meaning that the number of available IDs would run out very quickly.

4) If none of the above works, you can consider deploying negative IDs which effectively doubles the amount of available IDs for any given sequence.

 

This type of error has been covered multiple times within the forums and in Campaign Support if you need additional details and assistance. See below:

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/error-duplicate-ke...

Regards,

Craig

Avatar

Level 4

@Craig_Thonis 

 

please tell me where and how we can change the sequence

 

please help to share screenshot if poosible

reaally looking for quick response as this is impacting the prod

Avatar

Level 4

4) If none of the above works, you can consider deploying negative IDs which effectively doubles the amount of available IDs for any given sequence.

 

 

how and where we can do this