Throwing error in PDF, excel formats

[Gnani]

Hi gurus,
I have one burning issue which needs the solution very urgent..
When i run the list report in HTML format, it runs fine but when i run in PDF or excel then it throws below error.

RSV-BBP-0021
The operation 'getOutput' is not allowed at this time.

Details 
RSV-SRV-0042 Trace back: RSReportService.cpp(629): RSException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(177): RSException: CCL_RETHROW: RSReportServiceMethod::process(): reportGetOutput_Request RSASyncSession.cpp(275): RSException: CCL_THROW: RSASyncSession::processGetOutputRequest

My list report has 9000records for 30 columns. I use c8.2version.
How can i solve this issue.

Thanks in advance
Gnani

[tupac_rd]

http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bRSV-BBP-0021&uid=swg21341756&loc=en_US&cs=utf-8&cc=us&lang=all


or as per this link below, you might have to upgrade to 8.4.1 FP2

http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bRSV-BBP-0021&uid=swg1PM05514&loc=en_US&cs=utf-8&cc=us&lang=all

[Gnani]

Thanks for ur reply..
I don't have any grouping column in the report and don't have calculation or filter with CASE statement...


Gnani..

[Gnani]

I have scheduled a Job to run twice a day which includes 5 reports. It used to run without errors. But now it is getting failed and throws error as per below for each report in the run history.

CM-SYS-5043 Content Manager failed to create an object.[IBM][CLI Driver][DB2/NT] SQL0968C The file system is full. SQLSTATE=57011 
July 7, 2010 2:12:33 AM    RSV-DST-0014 An error occurred. See the run history details for more information.

I have been struggling with this issue for 2days.


Gnani

[mvjcognos]

the report which u r running is migrated from any prior version or from starting it is running in the same version...

For this type of issues u need to run the report in html and check one by one page till bottom dont go from 1st  to bottom page it is mandatory that u need to check all pages then find any error coming in the html output...

If u get any error then because of that u are unable to run excel and pdf.
pdf and excel will run once and extract complete output where as html will run for every page.........

U will get error like sql preparations or pid is missing or data compatibilty.........

[Deepa]

the report which u r running is migrated from any prior version or from starting it is running in the same version...

For this type of issues u need to run the report in html and check one by one page till bottom dont go from 1st  to bottom page it is mandatory that u need to check all pages then find any error coming in the html output...

If u get any error then because of that u are unable to run excel and pdf.
pdf and excel will run once and extract complete output where as html will run for every page.........

U will get error like sql preparations or pid is missing or data compatibilty.........

[Arsenal]

I have scheduled a Job to run twice a day which includes 5 reports. It used to run without errors. But now it is getting failed and throws error as per below for each report in the run history.

CM-SYS-5043 Content Manager failed to create an object.[IBM][CLI Driver][DB2/NT] SQL0968C The file system is full. SQLSTATE=57011 
July 7, 2010 2:12:33 AM    RSV-DST-0014 An error occurred. See the run history details for more information.

I have been struggling with this issue for 2days.


Gnani

Are you by any chance using the With clause in FM? My understanding is that this causes the underlying DB (if it supports With clause and DB2 does) to use sort of temp tables (for lack of a better term)  to join sub queries together and the UID Cognos uses for this may not be having enough space assigned to it on the DB for this operation. Or maybe the volume of data has grown so large over a period of time that a temp table needs more space than it used to

Just a thought and easy enough to check by turning off With in FM, publishing a temporary package, creating a copy of the failing report, pointing it to this temporary package and running it.

[PRIT AMRIT]

CM-SYS-5043 Content Manager failed to create an object.[IBM][CLI Driver][DB2/NT] SQL0968C The file system is full. SQLSTATE=57011 
July 7, 2010 2:12:33 AM    RSV-DST-0014 An error occurred. See the run history details for more information.

As Arsenal suggested,

Or maybe the volume of data has grown so large over a period of time that a temp table needs more space than it used to

Pls also check your file location has enough space to save those PDF files?

Thanks
Prit