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 JANUARY 22, 2021

Applies to:

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

Symptoms


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.

Changes

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

Cause

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
Symptoms
Changes
Cause
Solution


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