Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Monitoring techincal workflow monitor the BROADLOGID sequences EXHAUSTION limit finer

Avatar

Level 4

Hi All, in my case

 

the primary key sequence for broad Log schema is near to exhaustion  exhaust

 

please help to provide a monitoring techincal workflow if anyone created to monitor the sequences

 

 

 

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,

I'm not sure about a specific workflow to monitor the sequences. However, I recommend the two articles below to ensure that sequence hygiene practices are followed.

 

Unless you are processing a massive amount of data daily, with best practices being followed, it should be pretty hard to hit sequence exhaustion.

 

Specifically, you should:

1) Limit the amount of log data that is being kept to the bare minimum (reduce the purge range in the deployment wizard)

2) Ensure that the DB Cleanup workflow is running daily and completed, as it removes old data and frees up IDs

3) Do not use the out-of-the-box xtkNewID sequence; configure custom sequences (especially for heavily used tables such as the broadlogrcp table)

4) Do not share sequences

5) If you are still churning through IDs, you may want to consider implementing negative ids which effectively doubles the amount of IDs available but can have drawbacks.

 

Data model best practices

https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/data-mod...

 

Office Hours which covers handling sequences

https://helpx.adobe.com/customer-care-office-hours/campaign/sequences-exhaustion-campaign-classic.ht...

 

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

Hi Shrutii,

I'm not sure about a specific workflow to monitor the sequences. However, I recommend the two articles below to ensure that sequence hygiene practices are followed.

 

Unless you are processing a massive amount of data daily, with best practices being followed, it should be pretty hard to hit sequence exhaustion.

 

Specifically, you should:

1) Limit the amount of log data that is being kept to the bare minimum (reduce the purge range in the deployment wizard)

2) Ensure that the DB Cleanup workflow is running daily and completed, as it removes old data and frees up IDs

3) Do not use the out-of-the-box xtkNewID sequence; configure custom sequences (especially for heavily used tables such as the broadlogrcp table)

4) Do not share sequences

5) If you are still churning through IDs, you may want to consider implementing negative ids which effectively doubles the amount of IDs available but can have drawbacks.

 

Data model best practices

https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/data-mod...

 

Office Hours which covers handling sequences

https://helpx.adobe.com/customer-care-office-hours/campaign/sequences-exhaustion-campaign-classic.ht...