My Oracle Support Banner

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

Last updated on APRIL 09, 2019

Applies to:

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


Upgraded answer returns the following error.

View Display Error
Odbc driver returned an error (SQLExecDirectW).
  Error Details
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 and, but not with 11g: and



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

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