OBIEE 11g: Error: "Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P...[nQSError: 46036] Internal Assertion: Condition logicalSubRequest" After Filtering On Hierarchy Column (Doc ID 1393344.1)

Last updated on JANUARY 23, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] to 11.1.1.5.0 [1308] [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 20-Nov-2013***

Symptoms

You have, among others, three dimensional columns in a report.  Two of these columns are used to filter data via a Dashboard prompt.
Initially all hierarchical columns are showing the grand total level.
After selection (in selection step) of some child levels the following error occurs.

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: 46036] Internal Assertion: Condition logicalSubRequest->GetProjection()->GetNumColumns() == navigatedSubRequest->GetProjection()->GetNumColumns(), file server\Query\Optimizer\Navigator\Src\SQONProcessingPathGraph.cpp, line 1169. (HY000)

The issue occurs only when in NQSConfig.ini you have the following settings:

CACHE=YES
DISABLE_SUBREQUEST_CACHING=NO

Cause

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 hundreds of Community platforms