You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How do I resolve: FETCH FIRST 500001 ROWS ONLY

Accepted answer
19
Views
1
Comments
edited Dec 13, 2019 3:10PM in Oracle Analytics 1 comment

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 '[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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!