Question

11
Replies
664
Views
ABHINANDAN Member since 2011 27 posts
Areteans Technology Solutions
Posted: 2 years ago
Last activity: 1 year 6 months ago
Closed

Locking mechanism of Pega Marketing BatchOut table

In our project we are using PM 7.22 on top of Pega 7.3.

We have faced a recent issue where the offer flow is still in Wait status even though customer has opted in , offer got activated and IH updated successfully.

This has occured for number of cases for the campaign we recently launched.

While investigating it seems that customer has opted in almost at the same time when next reminder was sent. So for optin the offer got activated and IH updated, however just before commiting the batchout table update to complete the flow status, the DF_Wait started processing the same offer to send reminder,hence it changes override the previous change of Flow status completion.

We looked into the PegaMKT-Work-Offer.ProcessOffer OOTB activity, and we didn't saw any locking mechanism on BatchOut table records leading to simultaneous update possible and loss of data.

Please kindly check let us if this analysis of our is correct or not, if yes is there any fix for this because it is serious concern.

Regards

Abhi

Pega Marketing SR Created
Moderation Team has archived post
Share this page LinkedIn