What is "Counting in progress" and how to accelerate this? | Community
Skip to main content
G
god_prophet
Level 6
September 19, 2023
Solved

What is "Counting in progress" and how to accelerate this?

  • September 19, 2023
  • 3 replies
  • 1460 views

We have a delivery, where the workflow started at 10 am and contact date is "inmidiatlt". But it is still in Counting in progresss... what is it: Is counting all the recipients?

Is there any configuration, we can apply to accelerate this next time?




It seems audit is not updated, and showing last action at 10 am, when it is 4 pm.

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Craig_Thonis

Hi ogonzalesdiaz,

Counting in progress is similar to the personalization step. It counts the recipients but also ensures that the expected count is the same as the actual count. If the count is misaligned, an error will be thrown, and the delivery will fail.

The count could fail due to personalizations being called within the delivery that incorrectly leverage a 1-N table and cause the number of targeted recipients to be inflated.


The preparation step heavily interacts with the database. So, if you want to improve this step, there are numerous optimizations:

1) Check the current delivery content and ensure that any personalization or count requests within the content are properly joined on keys and not doing full table scans

2) Ensure referenced tables are indexed

3) Ensure that the database cleanup workflow, maintenance scripts, and temp space are cleaned


If you are still unable to determine the problem, I recommend turning on SQL logging to see what queries are being executed and then either reach out to your database administrator or to Campaign Support, who can review the queries when the delivery is executed. This way, they can see if an inefficient query is being executed or perhaps there is another conflicting query from another workflow that is locking the table and causing delays in the count.


Regards,

Craig

3 replies

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity Advisor
Community Advisor
September 20, 2023

Hello @god_prophet ,

when delivery is executed there is bunch of things happening one of which is "counting in progress" where all your filtering typology rules are applied.

If you are using custom filtering typology rules they may slow the process, so if you do so you should optimize them.

But that time is way too long. Have you refreshed the page btw 🙂

 

Marcel Szimonisz

LakshmiPravallika
Community Advisor
LakshmiPravallikaCommunity Advisor
Community Advisor
September 20, 2023

Hi @god_prophet ,

 

Please check whether the recipients have received the delivery in your delivery logs or else workflow restart is required if not received the emails.

 

Also, the SQL Typology rules needs to be optimized(if filtering is done on a column, please create an index on it to faster the selection ),and also if it is an external Database to which these are applied, it can also slow down the performance.

 

Regards,

Pravallika.

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
September 20, 2023

Hi ogonzalesdiaz,

Counting in progress is similar to the personalization step. It counts the recipients but also ensures that the expected count is the same as the actual count. If the count is misaligned, an error will be thrown, and the delivery will fail.

The count could fail due to personalizations being called within the delivery that incorrectly leverage a 1-N table and cause the number of targeted recipients to be inflated.


The preparation step heavily interacts with the database. So, if you want to improve this step, there are numerous optimizations:

1) Check the current delivery content and ensure that any personalization or count requests within the content are properly joined on keys and not doing full table scans

2) Ensure referenced tables are indexed

3) Ensure that the database cleanup workflow, maintenance scripts, and temp space are cleaned


If you are still unable to determine the problem, I recommend turning on SQL logging to see what queries are being executed and then either reach out to your database administrator or to Campaign Support, who can review the queries when the delivery is executed. This way, they can see if an inefficient query is being executed or perhaps there is another conflicting query from another workflow that is locking the table and causing delays in the count.


Regards,

Craig

    G
    god_prophetAuthor
    Level 6
    September 21, 2023

    Hi Craig, how to do step 1? Any tutorial or guide?

    Thank you.

    Terms & ConditionsAccessibility statement

    Loading footer...