COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: vivek.bevan on 09 Sep 2008 08:44:50 AM

Title: Urgent Help needed
Post by: vivek.bevan on 09 Sep 2008 08:44:50 AM
Hey Guys,

Any idea about the following error:
-------------------------------
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-EE-0092 Data exception occurred. String data has been right truncated. UDA-SQL-0460 A general exception has occurred during local processing. RSV-SRV-0042 Trace back: RSReportService.cpp(747): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(217): QFException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_Request
-------------------------------

This error is eating my brain out. Any help is appreciated.

Thanks,
Vivek
Title: Re: Urgent Help needed
Post by: vivek.bevan on 09 Sep 2008 09:11:20 AM
Got the issue here. I was casting a field for varchar and it looks like the character limit i had given was less for some cases. When i increased the varchar limit the error was gone.

~Vivek