Tag Archive

Issue with invalid or corrupted repository joins

Published on April 12, 2013 By Ignacio de la Torre

Symptom: The following error message is displayed: [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46043] Internal error: No matching table for expr D_OPER_UNIT_XL.OPER_UNIT_SID, File .\Src\SQOSPSimplifyJoin.cpp, line 118. Cause: This symptom is associated with corrupted physical layer join relationships. The best way to test for a root cause is to isolate the […]

OBIEE Logical Table vs Logical Table Sources – Best Practice

Published on December 15, 2010 By Ignacio de la Torre

The difference between Logical Tables, Logical Table Sources (LTS) and the physical tables that compose a Logical Table Source, here are some basic guidelines that have helped me get this concept to seat more clearly in my mind.