If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Reports are running longer than the time limit set in FM

Started by PRIT AMRIT, 15 Jul 2015 10:47:57 PM

Previous topic - Next topic

PRIT AMRIT

 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

sunosoft

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

PRIT AMRIT

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