Support Article
Large JSON response causes REST Timeout
SA-15372
Summary
Connect-REST is slow and system hangs when the JSON response is large.
Error Messages
Not Applicable
Steps to Reproduce
Invoke Connect-REST and map lengthy or complex JSON.
Root Cause
A defect in Pegasystems’ code or rules. DatabaseImp.executeRDB() executes below query 2000+ times:
"SELECT pyPropertyName AS "pyPropertyName", pyPageClass AS "pyPageClass", pyPropertyMode AS "pyPropertyMode" FROM PEGARULES.pr4_rule_property "property" WHERE (pxObjClass = 'Rule-Obj-Property') AND (pyClassName = ?) AND (pyRuleAvailable = 'Yes') "
Resolution
Apply HFix-24437
Published January 31, 2016 - 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.