Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Vmouse on 25 Oct 2012 04:52:55 AM

Title: Report suddenly running slowly but only in one enviroment
Post by: Vmouse on 25 Oct 2012 04:52:55 AM
Hi all,
a bit of a weird one this. I've got a report which was working fine in both LIVE and Dev environments but is now suddenly running slow in Live (from 20 seconds to 6 minutes). The Cogsever.log is flooded with the attached doc being a partial example.
Windows 2008 r2 & Cognos 10.1.1.

Any Ideas and thanks.
Title: Re: Report suddenly running slowly but only in one enviroment
Post by: Rahul Ganguli on 25 Oct 2012 12:12:47 PM
Hi,

Have you enabled audit in LIVE environment?
Is this issue related only a single report or multiple reports?
What is datasource of your reports? Is the database performing well?
How much time is it taking to return tabular data?
What kind of report is it, list crosstab or multiple?

Regards,
Rahul
Text only | Text with Images