My Oracle Support Banner

Error: "The user query with request id:### and logical hash:0 exceeded the maximum query governing memory limit. (HY000)" After Adding A Sort Option To Analysis Column (Doc ID 2426047.1)

Last updated on JULY 23, 2018

Applies to:

Primavera Analytics Cloud Service - Version 17.11.0.0 and later
Primavera Analytics - Version 17.11.0.0 and later
Information in this document applies to any platform.

Symptoms

After adding a sort option to an analysis column, attempting to view results or run the analysis fails with the following error:

ERROR
-----------------------
Odbc driver returned an error (SQLExecDirectW).

Error Details
Error Codes: OPR4ONWY: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: 59151. [nQSError: 59151] The user query with request id:### and logical hash:0 exceeded the maximum query governing memory limit. (HY000)
SQL Issued: $SQL Statement


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Login to Analytics
  2. Click the catalog link
  3. Locate the analysis in question and click Edit
  4. Note, the results page loads and displays the analysis without issue
  5. Click the criteria tab
  6. Find the column you wish to add a sort option and click the column properties (gear icon)
  7. Click Sort then chose any of the following:
    • Add Ascending Sort
    • Add Descending Sort
  8. Click the Results tab
  9. Note the error which occurs when attempting to display the analysis results.

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!


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