Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12c Error in BI Answers
Hi,
Might be a long shot but worth a try, anyone seen the following error before in analysis with OBIEE 12.2.1.2.0. We've encounter this issue in a test environment but is fine in our dev environment which is running the same OBIEE version and database. The two tables are unrelated so theres no need for a physical join.
State: HY000. Code: 14046.
[nQSError: 14046] No physical join relationships exist between any of the following tables: left = [ <physical table name> AS <logical table name>] and right =
[ <physical table name> AS <logical table name>]]. (HY000)
Thanks
Answers
-
879721 wrote:We've encounter this issue in a test environment but is fine in our dev environment which is running the same OBIEE version and database.
Neither OBIEE version nor database are impacting that -. you have to look at the logical query that's being produced and the RPD model!
0 -
Thanks Christian.
The logical query of the analysis is the same in both environments. Unfortuantely we can't get the phyiscal query in the test environment as the analysis errors out.
0 -
So the RPD must be different. You have to look at all the logs. OBIPS, OBIS etc.
0 -
I have the same issue right now. These two tables are not related and there is no need for any joins between them. I looked at the logs, it doesn't give any key info. They only have a record of presentation level query. However, in OBIS log, where the error is written I have one more line.
physical join relationships exist between any of the following tables: left = [ [[file: server/Query/Optimizer/Navigator/Src/SQONPathJoinConstructor.cpp; line: 720
Table A T44064] and right = [Table B T93025].
It refers to the cpp file, maybe it could have an answer.
0 -
If you have a problem, open a thread. This one was abandoned by the OP who gave up and never replied.
0