Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Campaigns related to segment refresh fail



Campaigns related to segment refresh, fail.

Error Messages

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

  1. Use a segment to configure multiple campaigns.
  2. Schedule the campaigns to run in parallel. 

Root Cause

This behavior is as per Pega product  design.


Perform either of the following or both approaches such that the campaigns do not fail:
  1. Schedule campaigns that re-use a particular segment such that they do not overlap.
  2. Use Transactional Refresh (refer to the Pega Marketing User Guide).

Published December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us