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

Issues with Big Workflow Deliveries and Getting Errors on Broadlog

Avatar

Avatar
Validate 1
Level 1
becker77
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
becker77
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
becker77
Level 1

26-11-2020

Hello,

 

We use Adobe Campaign Classic.

 

We have a few workflows that run quite a bit of data through them (over 5 mill records).  We are splitting out by recency in our database and have multiple deliveries (with sometimes AB testing).  

 

Once in a while we get error message:

Status: Personalization or Count Failed

Error message: 

The delivery has failed

XSV-350122 An error occurred and the process has been stopped. SOP-330011 Error while executing the method 'PrepareMessage' of service 'nms:delivery'. SOP-330011 Error while executing the method 'PrepareMessageImpl' of service 'nms:delivery'. PGS-220000 PostgreSQL error: ERROR: duplicate key value violates unique constraint "nmsbroadlogrcp_id" DETAIL: Key (ibroadlogid)=(2062510602) already exists.

 

We have added in dedupe on the workflow, added in waits between firing off next delivery, waves for processing and put the delivery on low urgency.  The workflow processes fine and it always seems to be the individual deliveries that have the problem.

 

I don't really know what more to do to stop this from happening.  I should point out that using the same data set this doesn't happen all the time.  Maybe 1/20 messages we send to effectively the same data set with the same conditions - but potentially adding in more deliveries. Is it purely the number of deliveries in the workflow?

 

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

26-11-2020

Hi,

 

That field is a signed 32 bit integer, which you're approaching the end of.

See these pages for remedies:

 

Thanks,

-Jon

Answers (1)

Answers (1)

Avatar

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

134 likes

Total Posts

821 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

134 likes

Total Posts

821 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile
Sukrity_Wadhwa
Employee

03-12-2020

Hi @becker77,

Was the given solution helpful in resolving your query or do you still need help? Do let us know.

Thanks!