Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sorry to duplicate a question, but I was really hoping someone may be able to help with this error:
I keep getting an oledb read fail from the following. Not a complex query at all and I cannot figure out what could be causing the error. I have followed some of the recommendations throughout other posts on this issue but still seem to get the error 'OLEDB READ FAIL".
When I run the query in toad, it runs with no problem (very fast). However, when I run it in qlikview, it errors. out. We are connecting to an oracle db. Not a complex query at all and I cannot figure out what could be causing the error. Here is my script:
RA_ADDRESSES_ALL:
LOAD
ADDRESS_ID2 as ADDRESS_ID,
SITE_NUMBER2 as SITE_NUMBER;
SELECT /*+RULE */
HCSU.CUST_ACCT_SITE_ID ADDRESS_ID2,
HZPS.PARTY_SITE_NUMBER SITE_NUMBER2
FROM
HZ_CUST_ACCT_SITES_ALL HCAS,
HZ_CUST_SITE_USES_ALL HCSU,
HZ_PARTY_SITES HZPS
WHERE
HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
AND HCAS.PARTY_SITE_ID = HZPS.PARTY_SITE_ID
AND HCSU.SITE_USE_CODE = 'BILL_TO';
STORE RA_ADDRESSES_ALL INTO RA_ADDRESSES_ALL.QVD;
DROP TABLE RA_ADDRESSES_ALL;
Any help is greatly appreciated.
Here is my script:
RA_ADDRESSES_ALL:
LOAD
ADDRESS_ID2 as ADDRESS_ID,
SITE_NUMBER2 as SITE_NUMBER;
SELECT /*+RULE */
HCSU.CUST_ACCT_SITE_ID ADDRESS_ID2,
HZPS.PARTY_SITE_NUMBER SITE_NUMBER2
FROM
HZ_CUST_ACCT_SITES_ALL HCAS,
HZ_CUST_SITE_USES_ALL HCSU,
HZ_PARTY_SITES HZPS
WHERE
HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
AND HCAS.PARTY_SITE_ID = HZPS.PARTY_SITE_ID
AND HCSU.SITE_USE_CODE = 'BILL_TO';
STORE RA_ADDRESSES_ALL INTO RA_ADDRESSES_ALL.QVD;
DROP TABLE RA_ADDRESSES_ALL;
Any help is greatly appreciated.
The difference could be Toad doesn't use oledb to geet Oracle data
Some thing you can try :
1
for hint you have to add
SET StripComments = 0;
but I don't think this is the problem (just Oracle skip the hint; and Oracle strongly advise to use the CBO)
2
try with a single table and char or varchar field (no number, no date); I once had a problem (oledb read failed) with oledb and regional settings, incorrect data or oledb read error with number (because off . ,) and date
I mean with OLEDB you have to use "as" for renaming columns or tables (standard sql). In oracle sql using of "as" is optional.
RA_ADDRESSES_ALL:
LOAD
ADDRESS_ID2 as ADDRESS_ID,
SITE_NUMBER2 as SITE_NUMBER;
SELECT
HCSU.CUST_ACCT_SITE_ID as ADDRESS_ID2,
HZPS.PARTY_SITE_NUMBER as SITE_NUMBER2
FROM
HZ_CUST_ACCT_SITES_ALL as HCAS,
HZ_CUST_SITE_USES_ALL as HCSU,
HZ_PARTY_SITES as HZPS
WHERE
HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
AND HCAS.PARTY_SITE_ID = HZPS.PARTY_SITE_ID
AND HCSU.SITE_USE_CODE = 'BILL_TO';