0 Replies Latest reply: Nov 4, 2015 4:36 PM by Luciano Palacios RSS

    OLEDB Read Fail

    Luciano Palacios

      Wondering if anyone can help with this issue. 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. 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.