Cognos Bursting Issue

[mrcool]

Hi Gurus,

I am facing serious performance issue while bursting a report. When run interactively/scheduled this report is running fine but once I enable the bursting it is failing in between with following error:

DPR-ERR-2087 The request has exceeded the execution time limit. It will be cancelled. Handler trace back: [the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler [the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler [service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler [load_balancer] com.cognos.pogo.handlers.logic.ChainHandler [lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler [batchreportservicechain] com.cognos.pogo.handlers.logic.ChainHandler [warptask_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler [do_batch_warp] com.cognos.pogo.handlers.logic.ChainHandler [warptaskmtaChain] com.cognos.pogo.handlers.logic.ChainHandler [warptaskmta] com.cognos.pogo.reportservice.BatchReportServerHandler

I have server level setting of 30 mins as execution time limit but this report is failing in 10 mins. It is generating 3-4 burst ouputs but failing with this error without completing for all the burst key values.
I would also like to know why the performance is pretty bad during the bursting. I do not have any master detail relationship and I am using single query for burst groups and burst Recipients.

Your help would be highly appreciated.

Thanks,
Mc

[jackg_tor]

FWIW, I've just been doing some performance analysis of our reports and found that turning on the "Audit the native query for report service" property was really helpful for showing me where the time was being used.  To do that, launch Cognos Admin, go the status tab then System and edit the logging properties of your server or dispatcher.  Then, you can use logviewer2 to look at <install-dir>\logs\cogserver.log.

Jack Goldstein

[duykhoatr]

Hi,
I got the same problem when run report in Query Studio. Did you solved it?

Hi Gurus,

I am facing serious performance issue while bursting a report. When run interactively/scheduled this report is running fine but once I enable the bursting it is failing in between with following error:

DPR-ERR-2087 The request has exceeded the execution time limit. It will be cancelled. Handler trace back: [the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler [the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler [service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler [load_balancer] com.cognos.pogo.handlers.logic.ChainHandler [lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler [batchreportservicechain] com.cognos.pogo.handlers.logic.ChainHandler [warptask_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler [do_batch_warp] com.cognos.pogo.handlers.logic.ChainHandler [warptaskmtaChain] com.cognos.pogo.handlers.logic.ChainHandler [warptaskmta] com.cognos.pogo.reportservice.BatchReportServerHandler

I have server level setting of 30 mins as execution time limit but this report is failing in 10 mins. It is generating 3-4 burst ouputs but failing with this error without completing for all the burst key values.
I would also like to know why the performance is pretty bad during the bursting. I do not have any master detail relationship and I am using single query for burst groups and burst Recipients.

Your help would be highly appreciated.

Thanks,
Mc

[duykhoatr]

Hi all,

I modified governor limit 100 MB and the report can be run with some filter.

It returned about 200,000 rows. But I want it return more rows, how can I configure the execution time limit?

Thank you