My Oracle Support Banner

OBIEE 12c: Report_Max Function Returns Internal Assertion: Condition it != m_unionBreaks.end() (Doc ID 2419020.1)

Last updated on JULY 17, 2018

Applies to:

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

Symptoms

Upgraded answer returns the following error.

ERROR (*)
-------
View Display Error
 
Odbc driver returned an error (SQLExecDirectW).
  Error Details
Error Codes: OPR4ONWY:U9IM8TAC: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: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 46036. [nQSError: 46036] Internal Assertion: Condition it != m_unionBreaks.end(), file
server/Query/Execution/Utility/Src/SQXUHashColumnIndex.cpp, line 2288. (HY000)
SQL Issued: Set Variable LOGLEVEL=7; SELECT 0 s_0, "Sample Sales Lite"."Time"."Per Name Month" s_1, "Sample Sales Lite"."Time"."Per Name Year"
s_2, '' s_3, REPORT_MAX("Sample Sales Lite"."Time"."Per Name Month" BY ) s_4
FROM "Sample Sales Lite" FETCH FIRST 40001 ROWS ONLY


This answer has Report_Max function.
--------------------
1.Create an answer with Sample Sales Lite.

We found out that this can be reproduced with 12.2.1.3.0 and 12.2.1.2.0, but not with 11g: 11.1.1.9.x and 12.2.1.4.0.

 

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.