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