performance issue with report definition (Rule Resolution issue)
There is a performance issue with the report definition(RD).
The Rule Resolution query is timing out in the postgres DB.
RD times out.
Steps to Reproduce
1.Launh a portal go to the dashboard.
2.Click on the dashboard icon.
3.Click on Add widgets button.
We could observe that it no data populated.
DB parameter “ enable_material” has to be set to OFF in postgres.conf file.
Need tp update the code to enable a postgres related setting prior to query execution (and they would be reset once query executes)
HFix-24843 resolves the issue.