Expand my Community achievements bar.

SOLVED

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

Avatar

Level 5

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?


ogonzalesdiaz_0-1695156786705.png

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

ogonzalesdiaz_1-1695156834427.png

 

 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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

View solution in original post

4 Replies

Avatar

Community Advisor

Hello @ogonzalesdiaz ,

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

Avatar

Community Advisor

Hi @ogonzalesdiaz ,

 

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.

Avatar

Correct answer by
Employee Advisor

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

Avatar

Level 5

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

Thank you.