Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
How do I resolve: FETCH FIRST 500001 ROWS ONLY
Summary
Need all rows returned: not just FETCH FIRST 500001 ROWS ONLYContent
| 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 '[email protected]' exceeded the maximum query governing rows 1100000 from the database ''[email protected]'.'BHS_ADWC_PSOFT''. (HY000) |
| SQL Issued: SET VARIABLE ENABLE_DIMENSIONALITY = 1; SELECT |
| 0 s_0, |
| CASE WHEN XSA('[email protected]'.'FACT_VOUCHER_COUNTS')."Columns"."PO_ID" is null THEN 'DELETED' WHEN LENGTH(XSA('[email protected]'.'FACT_VOUCHER_COUNTS')."Columns"."PO_ID")>3 THEN 'PO' ELSE 'NON-PO' END s_1, |
Tagged:
0