Translate

Wednesday, 27 February 2013

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.

No comments:

Post a Comment

Google Big Query Clone / Copy DataSets / Tables - PROD --> TEST --> DEV Projects

Google Big Query Cloning of Datasets & Tables across GCS Projects. We searched the internet and could not find a simple cloning / ...