Thursday, February 14, 2013

OBIEE 11g - Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P


Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14025] No fact table exists at the requested level of detail:

Solution:  This happens when you have one hierarchy but multiple dimensions. In such case leave the Fact table's Content > Logical Level as blank, otherwise the fact table will be restricted only to that specific hierarchy and will throw error by not recognizing the other dimensions details.