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 18.104.22.168 and later
Primavera Analytics - Version 22.214.171.124 and later
Information in this document applies to any platform.
After adding a sort option to an analysis column, attempting to view results or run the analysis fails with the following error:
Odbc driver returned an error (SQLExecDirectW).
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
The issue can be reproduced at will with the following steps:
- Login to Analytics
- Click the catalog link
- Locate the analysis in question and click Edit
- Note, the results page loads and displays the analysis without issue
- Click the criteria tab
- Find the column you wish to add a sort option and click the column properties (gear icon)
- Click Sort then chose any of the following:
- Add Ascending Sort
- Add Descending Sort
- Click the Results tab
- Note the error which occurs when attempting to display the analysis results.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!