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 laterInformation 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 |