Oracle Analytics Cloud and Server

Products Banner

How do I resolve: FETCH FIRST 500001 ROWS ONLY

Received Response
267
Views
1
Comments

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

Answers

  • FPonte
    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