My Oracle Support Banner

OAC : Exporting To CSV Getting [nQSError: 60008] "exceeded the maximum query governing rows 1100000 from the database" (Doc ID 2672442.1)

Last updated on MARCH 03, 2024

Applies to:

Oracle Analytics Cloud - Version 106.3.0 to 105.6.0 [Release 106 to 105.3]
Data Intelligence - Version 23.R1.x to 23.R4.x [Release 23]
Information in this document applies to any platform.

Goal

Try to Export unformatted Report to CSV Format

after export found the following Error in CSV File 

[messageid: USER-34] [requestid: 638c0002] [sessionid:638c0000] [username: UserName@<domainname>] -------------------- Query
Status: [nQSError: 60008] The query for user 'UserName@<domainname>' exceeded the maximum query governing rows 1100000 from the database 'DB0'. [[
[nQSError: 43119] Query Failed:
[nQSError: 43121] Max Row Limit Exceeded

 Please check the customer OCPU Limit https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsom/create-services-oracle-analytics-cloud.html#GUID-164D8568-9AE3-4A74-9F1A-0D87B78713C9__TABLE1

Solution

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
Goal
Solution
References


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