OBIEE 11g - BIN In Answers Gives Error 'Nonexistent column:' xxxx When Using Another Analysis From A Different Subject Area (Doc ID 2065359.1)

Last updated on JULY 11, 2022

Applies to:

Symptoms

When using BINS which point to a different Subject Area than the current Subject Area being reported on in OBIEE 11g, you see the following error message :

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27045] Nonexistent column: "Sample Targets Lite"."Orders"."Order Type". (HY000)
SQL Issued: SELECT 0 s_0, "Sample Targets Lite"."Products"."Brand" s_1, CASE WHEN "Sample Targets Lite"."Products"."Product" IN (SELECT saw_1 FROM (SELECT "Sample Targets Lite"."Products"."Product" saw_0,"Sample Targets Lite"."Orders"."Order Type" saw_1,"Sample Targets Lite"."Base Facts"."Revenue" saw_2,DESCRIPTOR_IDOF("Sample Sales Lite"."Products"."Product")saw_3 FROM "Sample Sales Lite")nqw_1) THEN 'Others' ELSE "Sample Targets Lite"."Products"."Product" END s_2, DESCRIPTOR_IDOF("Sample Targets Lite"."Products"."Brand") s_3, "Sample Targets Lite"."Base Facts"."Target Revenue" s_4 FROM "Sample Targets Lite" FETCH FIRST 65001 ROWS ONLY

Cause

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