Discussion
Maximum elapsed time crossed and showing Interaction limit exceeded 30s
Hi all,
I am working in Production Support.
There is some problem while report definiton is executing with certain search criteria.
This particular report definition has 2 sub-reports and one drill down report.
when it executes at run time will execute all the sub-reports ot will it execute main report?
If at all it executes main report,here the main report is having very simple select query.
if not,the quey is very complex which is 2 left outer joins in single query on single work table.
Is it gud to execute report query's on Work table?
***Updated by moderator: Lochan to add Categories***
if the issue is on 7.1.8, could we quick test by updating the field 'Maximum elapsed time in seconds' under Data access tab of report definition?
also, please try simplifying the query, optimize columns or enable database index for query performance instead of updating the value...