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 JUNE 15, 2023

Applies to:

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

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