Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Delivery Personalization - The count of message prepared is decreased

Venu_Reddy
Community Advisor
Community Advisor

Hi All,

Recently i have faced one issue with delivery personalization and the details below:

I have created a workflow with a delivery and added personalization blocks in the delivery and ran the workflow.

To sent: 500K

Processed: 500

Success : 498

The processed target audience is very less and never seen before this much less count (0.2 %).

In audit logs, we have seen a warning as below:

" DLV-490124 The count of message prepared (500) is less than the number of messages to send (500K). Most likely there is an issue with an outer join used to load personalization information. "

Anyone faced this situation and how we have to fix it?

Why the personalization information failed for almost 99% target audience ?

The message/email preparation  will happen in the server where MTA installed? (while personalizing the message body)

1 Accepted Solution
Venu_Reddy
Correct answer by
Community Advisor
Community Advisor

Hi Kapil,

Thank you for your response.

I'm facing exactly opposite scenario that COUNT OF MESSAGE PREPARED IS VERY LESS COMPARED TO TARGET AUDIENCE.

For better understanding i gave brief count details in the description.

View solution in original post

7 Replies
kapilKochar
Community Advisor
Community Advisor

Hi Venu,

This may happen when you have several personalization combination for a contact. Please check your personalization definition.

Also, Try  by including duplicates in the "to" section of the delivery.

Let me know if this works.

Thanks,

Kapil

Venu_Reddy
Community Advisor
Community Advisor

Hi Kapil,

Thank you for your response.

We used to send several personalization blocks by adding in a delivery earlier but never faced this issue.

I'm not sure why we need to add duplicates in the "to" section and the target is high ~500K

Regards,

Venu

Venu_Reddy
Correct answer by
Community Advisor
Community Advisor

Hi Kapil,

Thank you for your response.

I'm facing exactly opposite scenario that COUNT OF MESSAGE PREPARED IS VERY LESS COMPARED TO TARGET AUDIENCE.

For better understanding i gave brief count details in the description.

View solution in original post

Venu_Reddy
Community Advisor
Community Advisor

Can you please provide some inputs which helps me to avoid the same mistake in future campaigns

Amit Kumar-mm9Mvg

Adhiyan

Raj_bounteous
Community Advisor
Community Advisor

Hi,

Please check this

When a delivery fails, the following error can appear in the delivery logs: DLV-XXXX The count of message prepared (123) is greater than the number of messages to send (111). Please contact support.

Usually, this error means that there is a personalization field or block within the email that has more than one values for the recipient. A personalization block is being used and it is fetching more than one record for a particular recipient.

To solve this, check the personalization data used, and then check the target for recipients that have more than one entry for any of those fields. You can also use a Deduplication activity in the targeting workflow prior to the delivery activity to check there is only one personalization field at a time. For more information on deduplication, refer to this page .

Monitoring a delivery

Raj_bounteous
Community Advisor
Community Advisor

@Venu_Reddy  did you ever figure out what exactly is the issue for this?