If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

"freeform" number is invalid.

Started by getanswers, 19 Jul 2007 01:54:25 PM

Previous topic - Next topic

getanswers

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

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.

MDXpressor

Thanks for taking the time to post your findings.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

jobby

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

MFGF

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.
Meep!