COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: rprameshwor on 17 Jun 2013 11:06:33 PM

Title: Error: Rowcount limit exceeded
Post by: rprameshwor on 17 Jun 2013 11:06:33 PM
I have a report when I drill down a field I get the following error:

QuoteRQP-DEF-0177

An error occurred while performing operation 'sqlOpenResult' status='-28'.

UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.UDA-SQL-0107 A general exception has occurred during the operation "open result".ERROR: 174762 : Partition rowcount limit exceeded RSV-SRV-0042 Trace back:RSReportService.cpp(722): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(263): QFException: CCL_RETHROW

But when I apply some filters to the report, the report runs fine. So, I guess it is due the huge number of data rows.

So, is there any way to fix this? :'(
Title: Error: Rowcount limit exceeded
Post by: Lynn on 19 Jun 2013 04:00:45 PM
Yes. Apply filters to the report

:-D


Sent from my iPhone using Tapatalk