My Oracle Support Banner

Analysis Filter Throws "[nQSError:22024]A comparison is being carried out between non-compatible types BOOL and INTEGER" On Oracle Analytics (Doc ID 2744856.1)

Last updated on SEPTEMBER 27, 2021

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.


A filter applied on a column of 'boolean' data-type, which was working fine in OBIEE 11G version throws following error:

Column returns data as expected when included in the report criteria.


 OBIEE instance was migrated to 12c from OBIEE 11g. 


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.