Illegal Data Type Conversion From Source Type: LONG VARCHAR To Target Type: UNKNOWN (Doc ID 2763975.1)

Last updated on SEPTEMBER 03, 2021

Applies to:

Symptoms

On : 11.13.21.01.0 version, Technology Management - Reports/Analytics

illegal data type conversion from source type: LONG VARCHAR to target type: UNKNOWN


You have created an analysis based on Expenses - Expense Transactions Real Time and Payables Invoices - Installments Real Time. This analysis is contained in a dashboard and is being filtered out based on dashboard prompts. The prompts are using presentation variables to filter the data as needed.
However, for Business Unit prompt, when two or more values are selected, the following error occurs:

State: HY000. Code: 59030. [nQSError: 59030] Illegal data type conversion from source type: LONG VARCHAR to target type: UNKNOWN. (HY000)

Please note that the analysis works fine with All Values prompt and single value passed for this column.

Can you advise what is wrong?
Though I have searched there seems to not be available any documentation on this specific situation.

ERROR
-----------------------
illegal data type conversion from source type: LONG VARCHAR to target type: UNKNOWN

State: HY000. Code: 59030. [nQSError: 59030] Illegal data type conversion from source type: LONG VARCHAR to target type: UNKNOWN. (HY000)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Run analysis with two or more values are selected for Business Unit prompt


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Run analysis with two or more values are selected for Business Unit prompt

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.