My Oracle Support Banner

OBIEE 11g: Internal Assertion Error when Sorting on the Pivot View that "Include rows / columns with only Null values" (Doc ID 2195234.1)

Last updated on MARCH 18, 2019

Applies to:

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

Symptoms

Sorting a hierarchy column or a measure on the pivot view that "Include rows / columns with only Null values" may lead the internal assertion error:

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: 46036] Internal Assertion: Condition pColumn, file
server\Query\Src\SQEngineImpl.cpp, line 2676. (HY000)

 

The issue can be reproduce with the following steps:

1. Create an analysis with: Per Name Year, Product Hierarchy and Revenue.

2. Add pivot view.

3. Edit the pivot view and open the pivot view properties.
    Check the options of Null values "Include rows with only Null values" and "Include columns with only Null values". 

4. Drill down "All Products"

5. Drill down BizTech and drill down Communication.

6.Tried to sort Cell Phones' revenue.


 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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