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