Translate

Wednesday 27 February 2013

Shahed

OBIEE 11.1.1.6.6 RPD Join Corruption Error nQSError: 46043

OBIEE 11.1.1.6.6 Error with RPD Administration tool  Corruption.

 

 

 

 


NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46043] Internal error: No matching table for expr MY_DIMENSION_TABLE.MY_LAST_COLUMN, File .\Src\SQOSPSimplifyJoin.cpp, line 118




Identify the Fact table and specific Dimension table where the error is occurring.


1st Solution


Once identified delete the physical and BMM logical joins from the dimension to fact table.

Recreate the physical and BMM Logical joins .

Save and Test


2nd Solution

In the Dimension table on the BMM Layer goto the Sources of the table . Double click a Source and check the content tab. Remove any where conditions or Fragmentation content or combination flag.

Then upload rpd and test again.

The above solutions can be done offline or online via Administration tool.

I will update my toolset to 11.1.1.6.8 and patch up OBIEE aswell to see how i get on.

Note: only a member of this blog may post a comment.



About Authors

Shahed Munir

Krishna Udathu

Shahed and Krishna are Oracle / Big Data Experts