Campaigns related to segment refresh fail
Campaigns related to segment refresh, fail.
PEGA0106 database deadlock detected. User 'mktdata' PID 5586 blocked by 'mktdata' PID 4908. Blocked statement was - TRUNCATE MKTSEGANNUAL_PLAN_MAIN. Blocking statement was - SELECT "A"."pygroupid" AS "pyGroupID" , "A"." partitionkey" AS "PartitionKey" , "A"."pysubjectid" AS "pySubjectID" FROM customerdata.MKTSEGANNUAL_PLAN_MAIN "A" WHERE ( ( ( "A"."partitionkey" = $1 ) ) ) ORDER BY 3 ASC
Steps to Reproduce
- Use a segment to configure multiple campaigns.
- Schedule the campaigns to run in parallel.
This behavior is as per Pega product design.
Perform either of the following or both approaches such that the campaigns do not fail:
- Schedule campaigns that re-use a particular segment such that they do not overlap.
- Use Transactional Refresh (refer to the Pega Marketing User Guide).
0% found this useful