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

Error during validation

Started by ccbarbeau, 30 Aug 2011 02:32:37 PM

Previous topic - Next topic

ccbarbeau

Hi all,

I am writing a report in RS 8.4 (DB2 database) and the data comes from 2 tables. I have mathematical expressions as query calculations (i.e. [Sales Jan]-[Demand Jan]) as well as some extract functions on dates as data items. It was working well until I changed a parameter, now I get the following error when I try and run the report and/or validate the report:

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'.
UDA-SQL-0460 A general exception has occurred during local processing.
UDA-EE-0094 The operation "greater" is invalid for the following combination of data types: "packed decimal" and "character"

RSV-VAL-0004 Unable to find query information for the item Line

Etc etc.... I get the RSV-VAL-0004 for a bunch of my data items but not all of them. I've tried casting all my calculations as char, but it didn't work.

Any ideas as to how to fix this?

Thanks!

CC

navissar

My first guess is that you're looking at a problem with a layout calculation/variable/conditional value, perhaps set like this: "[Data Item]>ParamDisplayValue('Param')", or something of that sort. You'd be comparing a string and a number, and that won't do.
If that's the case, try using the data casting functions for these calculations (number2string and so on).
My second guess would be a summary filter which compares a string parameter value and a number.

lucasdnd

It could be that this new parameter you changed is now receiving a Char value, instead of a Decimal.

Make sure it is getting a numeric value and also try casting it to Decimal.