Cognos 8.4 Error
Posted on 2010-11-18
I am trying to Drill through to my detail report and am getting a UDA-SQL-0460 error. The parameter it's balking at is data like '15-19', '20-25'. Obviously defined as char in the db but I think it's trying to add the numbers together and then complains that I am adding characters. Here is the first line of the error message. The rest is the usual gibberish.
UDA-SQL-0460 A general exception has occurred during local processing.UDA-EE-0094 The operation "add" is invalid for the following combination of data types: "character" and "double"
Apparently this is not a big issue in ReportNet. Any help would be greatly appreciated. Thanks, steve.