Wednesday, 27 February 2013


OBIEE RPD Join Corruption Error nQSError: 46043

OBIEE 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 and patch up OBIEE aswell to see how i get on.

About Authors

Shahed Munir

Krishna Udathu

Shahed and Krishna are Oracle / Big Data Experts