After Upgrade From 11g, Some Analysis Error With [nQSError: 22024] A Comparison Is Being Carried Out Between Non-compatible Types
(Doc ID 2683404.1)
Last updated on SEPTEMBER 27, 2021
Applies to:Business Intelligence Suite Enterprise Edition - Version 126.96.36.199.0 to 188.8.131.52.200414 [Release 12g]
Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.
After migration from OBIEE 11g to 12c/OAS, some analyses which connect to MS SQL Server DB result in following error:
Issue could be narrowed down to few measure columns. The issue can occur with a single column in the analysis.
Following example provides a better picture on the issue:
1. An analysis with Column named "Quantity" results in the error mentioned above.
2. In the BMM layer of the RPD, column source for "Quantity" is defined as follows:
sum(case when FACT.orig_qty = '1' then 1 else 0 end )
3. In the RPD physical layer, the column "orig_qty" is defined with a datatype as BIT.
The expression- "case when FACT.orig_qty = '1' " is a comparison of BIT against a VARCHAR.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document