Support Article
Reports do not display on the report browser
SA-56597
Summary
Reports do not display on the report browser. On each public category, 0 displays indicating that there are no reports.
Error Messages
"pzRBShortcuts ** ** Retrieving the report data exceeded the limit of 30 seconds. Please try making the report more specific by further limiting which rows to include.
Steps to Reproduce
- Open the report browser
- Click a category to open
Root Cause
A defect or configuration issue in the operating environment. The issue was traced on the pzRBShortcutsByCategory report definition that was run to populate the report browser. The query issued by the report, timed out. The Structured Query Language (SQL) server was the database of the system. The statistics it used to formulate the execution plan for the query, got out of sync with the actual data and therefore, it needed an update.
Resolution
Perform the following local-change:
Run the below queries on the SQL server to update the statistics on the relevant tables:
- update statistics pr4_rule_vw;
- update statistics pr_sys_ruleset_index;
- update statistics pr4_rule_shortcut;
- update statistics pr_sys_class_ancestors;
Published February 28, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.