Hi,
The report I am running is a Oracle 8.0.5 based report , run in Cognos8 using a stored procedure in SQL server.
This is the error I get when I run the report
RQP-DEF-0177 - An error occurred while performing operation 'sqlOpenResult' status='-28'.UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-EE-0011 A "freeform" number is invalid. UDA-SQL-0460 A general exception has occurred during local processing. RSV-SRV-0042 Trace back: RSReportService.cpp(595): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(177): QFException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_Request RSASyncExecutionThread.cpp(562): QFException: RSASyncExecutionThread::checkException ..blah..blah..blah..
Now this report I have run several times.It runs fine when I run this with choosing just a single value for the all the 3 parameters.I.e parameter a = value1
parameter b= value 1
parameter c and d (date range) 10th Jul,2007 to 11th Jul 2007.
But fails when I choose more than one value for one of the parameters
for eg.. parameter a = value 1
parameter b IN ( value2,value3,value4)
parameter c (date range as mentioned above)
So what could be happening here.?
Please let me know.
Thanks,
getanswers
Hi everybody,
I could solve this issue. The reason being, that there were datatype issues for all of my Coloumns in the List.
I think, since we used the stored procedure, and in the stored procedure there is the Oracle Query and the whole query is a string which needs to be executed whenever the report is executed.
I will explain with an example with two coloumns below,
Say we have Trx_Number VARCHAR, and Amount NUMBER datatypes In Oracle
Then in SQL Sever the stored procedure wriiten, we write the Query in the Stores Procedure as (with quotes) 'Select trx_number,Amount from table Invoices'
So now whole query above is a string and so I think at this point 'Amount column is a VARCHAR'
So in the reprt net the AMount column will act as a Varchar instead of Number
Therefore I was getting the error free form number is Invalid
hence the solution for that was in report net using Cast,(referring to one of the note earlier where for Number datatype I used Cast(cast(filedname,float),Integer) )Iwas able to convert it into a number and then execute.
Hope this helps for anybosy who faces this issue.
Thanks
getanswers
But the strange thing was why did it not error when I chose single values and errored only when I chose multiple values.
Thanks for taking the time to post your findings.
I am facing the same issue. But it does not come up when i change the database. For a particular database it gives problem I'm not sure what it is. Please help.
I m using Cognos 8.2
Sounds like you have a data type mismatch somewhere.
What database are you connecting to?
How is Cognos 8 connecting (ODBC or native)?
Which item(s) are giving problems?
How are they defined?
MF.