Consistency Check Error 38118: Join type in table source of logical table does not match the join
(Doc ID 2532812.1)
Last updated on AUGUST 16, 2019
Applies to:Business Intelligence Server Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
OBIEE is upgraded from 126.96.36.199.0 to 188.8.131.52.0.
On the upgraded 184.108.40.206.0 rpd, Consistency check is reporting Error number 38118 on some LTS objects. This wasn't an issue in 220.127.116.11.0.
Join type between OBJECT1 and OBJECT2 below is Left Outer
Post upgrade, the Consistency Check (File-> Check Global Consistency) reports following error:
Error number 38118 Join type in table source OBJECT1 of logical table OBJECT2 does not match the join.
This join type changes from Left Outer to Inner when Auto Fix (File -> Check Global Consistency -> Auto-Fix) is run.
See below, post upgrade:
It causes the analysis/dashboards to show incorrect and unexpected results.
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