Hi guru's
We have been facing a strange issue for past few months and need your suggestion to overcome the same.
We have set the report query execution time limit in FM to 2hrs (7200sec). However we have observed some reports still run beyond 2hrs and sometimes even runs more than 10hr. We have to manually abort such reports from BIBUS services. If we don't kill such report then the PROD system becomes extremly slow :(
Have anyone encountered such an issue and how it was resloved?
Many thanks for your quick response.
Regards,
Prit
It seems like setting under FM for query execution time limit does not apply for the time limit of entire request. Please refer below link for more details.
http://www-01.ibm.com/support/docview.wss?uid=swg21339772
Report execution time limit can be handled by below two settings under administration.
Maximum execution time for the batch report service (seconds) - for scheduled reports
Maximum execution time for the report service (seconds) - for interactive report.
Thanks SK for your quick response.
Maximum execution time for the report service (seconds) - for interactive report. -- We have set this to 7200sec. Let's see if this indeed resloves the issue. I shall keep you posted.
Regards,
Prit