Friday, March 1, 2013

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.