Poor Performance of Scheduled Reports
SummaryThe limit for the Property Reference cache was previously increased to 1,000,000 for the system. However, one particular scheduled report is still triggering numerous PEGA0017 alerts. This report has 77 columns and typically contains about 60,000 rows. It is exported to Excel for distribution to the recipients.
Error Messages2016-11-02 14:37:43,643 GMT*8*PEGA0017*30000*30000*a94bef516b2dc3620bcd24db08c8ae55*NA*NA*HDE57E9F67D10F07FEDC65517E779EE20*EVOC FileServiceAdmin*BAC-GBAM-Work*GBAM:01.01.01*ea4f2f87ee3153515f6e3690756e4075*Y*51*HDE57E9F67D10F07FEDC65517E779EE20*7*WebContainer : 0*TABTHREAD1*com.pega.pegarules.data.internal.clipboard.PropertyReferencePoolImpl*(...)|nnn.nnn.nn.nn*Activity=ShowStream*Rule-Obj-Activity:ShowStream*RULE-OBJ-REPORT-DEFINITION PZCREATEEXPORTDATA #20140903T071016.942 GMT Step: 1 Circum: 0------pxTotalReqTime=106.69;pxInteractions=1;pxAlertCount=119;pxRulesUsed=166;pxRunStreamCount=287,145;pxOtherIOElapsed=0.14;pxRulesExecuted=41;pxInputBytes=1,723;pxTrackedPropertyChangesCount=1;pxRuleCount=8;pxDBInputBytes=116,088;pxRDBIOCount=1;
Steps to ReproduceCreate a large scheduled report that creates an Excel report, and sends out an email that has a link to this Excel report.
Root CauseDuring the export to Excel process, this report generates additional 1,600,000 unique property references.
ResolutionPerform the following local-change:
Increase the limit for the Property Reference cache to more than 1,600,000. If excessive numbers of PEGA0017 alerts are still generated, continue to increase the limit until the number of alerts drops to five or six alerts per day.
Use an alternate method to generate and export the report, like BIX, if increasing the size of the cache has negative impact on the system's performance or if the number of alerts cannot be reduced.
Published January 19, 2017 - Updated February 10, 2017