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
- Execute a data flow.
- Include a Strategy component.
- 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
Tags:
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.