My Oracle Support Banner

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 to [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

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