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

 

Error message when copying data from Excel to filter with a prompt in Cognos 11

Started by sepusa, 13 Oct 2022 01:33:44 PM

Previous topic - Next topic

sepusa

There is a prompt for a list of part numbers.

If I enter them one by one in the prompt, it works fine.  If I hard code it in the Qry, it works fine.

If I paste a list of parts from an excel file, it fails with this message.  What am I doing wrong?

Error Message:
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 "add" is invalid for the following combination of data types: "varchar" and "integer"

Thanks in advance.

bus_pass_man

What are the data types for the objects in question?  Is the error message correct?  That would be the first place I'd start and, presumably, that's where you started.  What did you observe?

https://www.ibm.com/support/pages/uda-ee-0094-error-when-creating-filter-or-calculation

dougp

paste where?

Are you using the Filter Conditions dialog and clicking "manually input items"?  What do you have selected in the list that begins with "Use Comma as keyword delimiter"?

Are you using a textbox prompt with Multi-select = Yes and Multi-line = Yes?