My Oracle Support Banner

OBIEE 12c: Invalid Data Filter is Replaced with "0=1" after "Checking In Changes" (Doc ID 2525627.1)

Last updated on OCTOBER 25, 2023

Applies to:

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

Symptoms

When editing the repository in the Administration Tool in online mode and executing "Checking In Changes", invalid data filter is replaced with "0=1" in 12c Administration Tool.

- Before "Checking In Changes", Data Filter was "EMP"."ENAME"=VALUEOF(NQ_SESSION."hoge"):


- After "Checking In Changes", the formula of Data Filter turned 0=1:


In the log of the server side (obis1-diagnostic.log), the following is output.

- obis1-diagnostic.log
-----------------------
[2019-03-25T05:36:49.946+00:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: <TID>]  [nQSError: 22024] A comparison is being carried out between non-compatible types VARCHAR and INTEGER.  [[
file: server\Query\Optimizer\ServiceInterfaceMgr\Utility\Src\SQOIUTypeVisitor.cpp; line: 112
.
.
[2019-03-25T05:36:49.952+00:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: <TID>]  [38197] Data filter expression "<SCHEMA>"."EMP"."ENAME" =  VALUEOF(NQ_SESSION."hoge") for User "<USER>" is considered as non conditional, error: [nQSError: 22024] A comparison is being carried out between non-compatible types VARCHAR and INTEGER. .
[2019-03-25T05:36:49.955+00:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: <TID>]  [nQSError: 22024] A comparison is being carried out between non-compatible types VARCHAR and INTEGER.  [[
file: server\Query\Optimizer\ServiceInterfaceMgr\Utility\Src\SQOIUTypeVisitor.cpp; line: 112
.
.
[2019-03-25T05:36:49.958+00:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 3548]  [88148] User "<USER>": data filters were modified.
-----------------------

Although [Check Global Consistency] - [Report Only] is executed before checking in changes via online mode, it does not detect the error. 

Changes

 

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
References


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