COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Gnani on 22 Feb 2011 09:01:33 AM

Title: Operation failed attempting to get page offset beyond limit.
Post by: Gnani on 22 Feb 2011 09:01:33 AM
I am getting below error message when i am trying to generate report in Excel with 300,000 records.

"RSV-SRV-0040
An application error has occurred. Contact your Administrator

CCLSystemError:2000:Fatal: Operation failed attempting to get page offset beyond limit. RSV-SRV-0042 Trace back:RSReportService.cpp(802): CCLSystemError: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(252): CCLSystemError"

In Details
I already set up rows per page option to 60000. When i try to run getting above error. But if i remove one column it was getting executed. I conclude that it was because of the column which has huge amount characters in each row. But i need the column in the report. i can't take it out.

Any ideas...?

Pls focus ur light here. Ur help is highly appreciated.

Thanks in Advacne
Gnani