How do I resolve: FETCH FIRST 500001 ROWS ONLY

Brian666H

Summary

Need all rows returned: not just FETCH FIRST 500001 ROWS ONLY

Content

Odbc driver returned an error (SQLExecDirectW).

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: 43121. [nQSError: 43121] Max Row Limit Exceeded

(HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed:

(HY000)

State: HY000. Code: 60008. [nQSError: 60008] The query for user 'oacadmin@bhsi.com' exceeded the maximum query governing rows 1100000 from the database ''oacadmin@bhsi.com'.'BHS_ADWC_PSOFT''. (HY000)

SQL Issued: SET VARIABLE ENABLE_DIMENSIONALITY = 1; SELECT

0 s_0,

CASE WHEN XSA('oacadmin@bhsi.com'.'FACT_VOUCHER_COUNTS')."Columns"."PO_ID" is null THEN 'DELETED' WHEN LENGTH(XSA('oacadmin@bhsi.com'.'FACT_VOUCHER_COUNTS')."Columns"."PO_ID")>3 THEN 'PO' ELSE 'NON-PO' END s_1,

COUNT(DISTINCT XSA('oacadmin@bhsi.com'.'FACT_VOUCHER_COUNTS')."Columns"."VOUCHER_ID") s_2,

REPORT_AGGREGATE(COUNT(DISTINCT XSA('oacadmin@bhsi.com'.'FACT_VOUCHER_COUNTS')."Columns"."VOUCHER_ID") BY ) s_3

FROM XSA('oacadmin@bhsi.com'.'FACT_VOUCHER_COUNTS')

FETCH FIRST 500001 ROWS ONLY

FPonte

Hi Brian.

Please have a look at these Docs.

Oracle Support Document 2288114.1 (OAC : How to increase number of rows for Exported to CSV/Excel in Oracle Analytics Cloud Service)

Oracle Support Document 2397833.1 (OAC : What Is The Mapping Between The Compute Shapes and DefaultRowsDisplayedInDownload, CubeMaxRecords, DEFAULT_DB_MAX_ROWS,etc Settings in Oracle Analytics Cloud(OAC)/OAAC)

It may have the solution for your case.

Cheers

Fernando