Question
Areteans Technology Solutions
IN
Last activity: 8 Mar 2019 15:29 EST
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
Areteans Technology Solutions
IN
Can someone from pega product team please throw some light on this query of mine?
Regards
Abhi
Pegasystems Inc.
US
Hi Abhi,
This looks like an extreme edge case you are talking about here, which we have not heard from any other customers or seen in in-house testing.
Can you please give more details on this ? generally given the nature of volumes you see in Pega Marketing - locking would impact performance.
1. What is the channel in which you are sending and receiving responses ? - is it delivered and clicked through in email or outbound/inbound SMS or some other way ?
2. What is your offer send time and wait time ? is it under very short intervals your wait expires after the send happens ? - what's the high level life cycle of your offers ?
3. Is this a production issue or a simulated pre-production run test where you see this ?
4. Whats the overall customer volume of the campaign and how many customers responses had this issue ?
The above data would be useful to think within the Product Management of Pega Marketing to see if anything has to be done in this area.
Areteans Technology Solutions
IN
1. Currently we are sending and receiving responses through SMS, but we have other channels like Email, IVR for which we will launching campaigns in near future.
2.The wait time is in days, i.e after first promotional sms we send reminders after every 5-6 days, they are monthly campaigns, but we also have weekly and daily campaigns.
3. It is a production issue where we are dealing with considerable customer base.
4. Typically we have around 2 million customer base i each campaign, and we have seen it around 20-30 instances whenever coincidentally customer opts in almost at the same time when reminder is to be sent. Our client asks about explanation for the same.
Hope that helps, let us know your opinion
Regards
Abhi
CollabPartnerz
IN
Please find below link might help you
https://collaborate.pega.com/question/what-are-locking-mechanisms-pega
Pegasystems Inc.
US
Pegasystems Inc.
US
Thank you! We have updated your original post with your SR details and linked this post to the SR to help the Engineer who picks it up.
Updated: 8 Mar 2019 15:29 EST
Pegasystems Inc.
US
Upon reviewing the associated SR, the resolution stated for "This is very extreme case and if we try to lock on BatchOut table the performace will decrease as it is batch mode with huge no of records. Asked user to observe , if such cases occur in high number the user can reopen the SR."