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

Large number of IH records retrieved

SA-104282

Summary



Post Pega Platform 8.3.1 upgrade, the pzExecuteIHLoadSQL fails with a PRRuntimeException. The number of rows retrieved is higher than the set Threshold of 450.


Error Messages



PRRuntimeException: Too may IH records retrieved


Steps to Reproduce

  1. Execute a data flow.
  2. Include a Strategy component.
  3. Import an Interaction History (IH) in the Strategy.


Root Cause



According to the design change in Pega Platform8.3.x, the pxExecuteIHLoadSQL function code is modified. Hence, whenever the number of records retrieved from the IH exceeds the configured threshold, the RunTimeException is generated in the logs (according to the logic).


Resolution



Here’s the explanation for the reported behavior:

The display of the RunTimeException is a design change to prevent system crashes. Importing many IH records  leads to out-of-memory; hence the system stops processing. The exception is introduced to prevent this.

Set the Threshold based on the client testing and provide it as the value for the below Dynamic System Setting (DSS),

prconfig/alerts/interactionhistoryreadrowsthreshold/default

 

Published December 2, 2021

Was this useful?

100% 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?

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