My Oracle Support Banner

OBIEE 12c - Error: "Exceeded The Maximum Query Governing Memory Limit" Thrown From Upgraded Reports that Have Long Logical Query (Doc ID 2187713.1)

Last updated on MAY 01, 2018

Applies to:

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

Symptoms

On : Oracle Business Intelligence Enterprise Edition (OBIEE) 12c, Analytics

After Migration from OBI 11.1.1.7.140715 to OBI 12.2.1.1.0 , reports that have long logical query or with many columns throw the following error:

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: 59151. [nQSError: 59151] The user query with request id:988086297 and logical hash:1701842858 exceeded the maximum query governing memory limit. (HY000)

 

Changes

 Upgrade from OBIEE 11g to OBIEE 12c

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.