Hi folks,
Almost all reports with very large sorts cause this error.
Cognos is highly tuned. 64GB memory, 400GB disk space available. Temp folder empty.
It runs like a dream (10.2.1.2)
Also, the report takes very little time to get to this point. Run time maybe 60 seconds for a month's data.
Nothing I can see that matches the usual reasons for this error.
Has anyone come across this? Any solutions?
Extremely frustrating :-\
Cheers,
Locus
For the benefit of others that have experienced this issue, it was down to temp space allocation on the DB.
In my case for Informix... 'NTEMP' and also allocated sort space.
We added 2GB chunks until we reached 50GB (Starting out at 9GB), and the reports started to run.
We are running very big tables with often no purge programs in place (A business requirement), so it took a lot of resources to get passed this.
Locus
Thanks for posting Locus. As an aside, could you filter the tables in FM so that less data is passed to the report? The unfiltered table would still be on your database as per the business requirement, but it might ease some of your reporting issues...
Hi Chris,
There are a wide variety of reports accessing these tables via the model, but maybe using discreet namespaces in FM for report groups and filtering by requirement would be a solution.
Thanks for the input.
Cheers,
Locus