Support Article
Preflight report generation times out
SA-1825
Summary
You experience a timeout during preflight report generation.
Resolution
The root of the problem is a large amount of data in the tables with no index results in the operation timing out before results are returned. This is addressed by Hfix-5751 and its dependencies. Additionally, the bellow queries should be run in the data base. The indeices it creates should improve the performance of database.
create index pr4_rule_vw_tidx1 on pr4_rule_vw("PXOBJCLASS","PXUPDATEDATETIME")
create index pr4_rule_tidx1 on pr4_rule("PYPRODUCTNAME","PYPRODUCTVERSION","PXOBJCLASS")
create index pr4_rule_vw_tidx2 on pr4_rule_vw(PXINSNAME, pxobjclass, PYRULESETVERSION,PYRULESET)
create index pr_index_warnings_tidx1 on pr_index_warnings(PXREFERENCINGRULEINSKEY, PXOBJCLASS)
RUNSTATS ON TABLE pr4_rule_vw
RUNSTATS ON TABLE pr4_rule
RUNSTATS ON TABLE pr_index_warnings
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.