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

SMS Export takes hours to complete for large volume campaign

SA-35514

Summary



For large volume campaigns(>2 million), the data takes excessive time to move from staging to Template table. We also saw DB alerts and had to truncate staging table for this to move successfully.


Error Messages



Not Applicable

Steps to Reproduce



Enable the OutboundMaster agent.


Root Cause



A defect in Pegasystems’ code or rules. The number of threads configured in the topology landing page is being ignored and threads are defaulting to 2. Also, the template table should use an insert statement rather than a merge statement, as insert is faster. These are both fixed in Pega Marketing 7.22 already, so the changes were backported to 7.21.

Resolution



Apply HFIX-33234.
Suggest Edit

Published March 26, 2017 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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