My Oracle Support Banner

OBIEE 12c: Measure With Fragmented Content Error Out "[nQSError: 46043] Internal error: No matching table" (Doc ID 2403813.1)

Last updated on MAY 31, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

On :  12.2.1.3.0 version, Analytics

Any measure with multiple logical table sources with fragmented content and including ToDate function in its calculation does not work with time dimension and results in report throwing error.


ERROR
-----------------------

Error Message:
Compound Layout
  Error
  View Display Error
  Odbc driver returned an error (SQLExecDirectW).
   Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 46043. [nQSError: 46043] Internal error: No matching table for expr D0.c1, File server/Query/Optimizer/SmartScheduler/PhysicalRequestGenerator/Src/SQOSPSimplifyJoin.cpp, line 202. (HY000)
SQL Issued: SELECT 0 s_0, "SWC_Sales Revenue and Goals"."Hawthorn Sales Detail"."Referring LOB" s_1, "SWC_Sales Revenue and Goals"."Month Dimension"."Year" s_2, CASE WHEN SUBSTRING("SWC_Sales Revenue and Goals"."Sales AMR Market"."Market Name" FROM 1 FOR 8)='Hawthorn' THEN "SWC_Sales Revenue and Goals"."Sales AMR Market"."HAWK Region Name" ELSE "SWC_Sales Revenue and Goals"."Sales AMR Market"."WMG Region Name" END s_3, "SWC_Sales Revenue and Goals"."Hawthorn Sales Detail"."YTD Total Sales Revenue" s_4, REPORT_AGGREGATE("SWC_Sales Revenue and Goals"."Hawthorn Sales Detail"."YTD Total Sales Revenue" BY ) s_5 FROM "SWC_Sales Revenue and Goals" FETCH FIRST 5000001 ROWS ONLY


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.