Large number of IH records retrieved
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.
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.
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).
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),