Question4Replies740Views Sharg Member since 2017 11 posts NCS Group Ltd Posted: February 6, 2018Last activity: April 3, 2018 Closed Basic and Advance Control Palette on the section not Showing up due to Report definition time outHi All,We are facing issues with the Basic and Advance Control Palette display on the section due to the Following report definition getting timeout.We have currently set the Timeout to 120 sec for a work around.RD List:-1. pyGetBasicPegaControlsForPalette 2. pyGetAdvancedPegaControlsForPalette 3. pyGetAdvancedNonPegaControlsForPalettePEGA Table: rules.pr4_rule_html_propertyThe System is a new PEGA 731 System with only one Application.Please let us know what DB level update need to be performed so as to reduce the performance issue to 30 sec . Low-Code App Development System Administration Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 2 years agoRonLee_GCS PEGA replied to ShargHi, What database are you on? There is a known issue with these report definitions that I believe affects MS SQLServer more acutely. Please submit an SR to request HFix-39255. Posted: 2 years agoSharg NCS Group Ltd replied to RonLee_GCSHi Ron, Thanks, yes we are using MS SQLServer Database, will raise an SR to get the HFix. - Gaurav Posted: 2 years agoSharg NCS Group Ltd replied to ShargWe have Added the HFIX into the system still the Pega Table are taking more time and still we are getting SQL Timeout exception, however the Palette issue is not having. Posted: 2 years agoRett_Hean_GCS PEGA replied to ShargGlad to hear the palette issue is resolved. I would personally spin a new thread on your SQL timeout exception problem. I would be sure to include the exception details, query being used, and related scenario which triggered it.