Support Article
JVM hangs when grid displays large number of results
SA-73540
Summary
JVM hangs when a grid sourced from a report definition returns a large number of results (2.5M). This occurs on enabling paging on the grid.
Error Messages
com.pega.pegarules.pub.context.RequestorLockException: Unable to synchronize on requestor HA4295E7DB00C63DDA96F9D9ABA92CF83 within 120 seconds: (thisThread = WebContainer : 15) (originally locked by = WebContainer : 3) (finally locked by = WebContainer : 3)
Steps to Reproduce
Display the grid.
Root Cause
In this configuration, the Max Records limits in the report definition on the Report Viewer tab were not considered. This was because the system retrieved the entire result set to accurately present the paging interface on the grid. Hence, setting those limits was ineffective.
Resolution
Perform the following local-change:
On the Query tab of the report definition, use the 'Top/Bottom rank' settings to limit the number of results retrieved.
Published March 8, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.