1 Reply Latest reply: Sep 8, 2011 11:53 AM by Marc Livingston RSS

    OLEDB read failed

      This is my script:

      PODetail:
      LOAD 
          company & '-' & vendornum as vendorlink,
          baseqty as podetailbaseqty,
          baseuom as podetailbaseuom,
          company & '-' & ponum & '-' & poline as porellink,
          company & '-' & partnum as podetailcompany,
          ium as poium,
          poline as popoline,
          ponum as poponum,
          pum as popum,
          unitcost as POunitcost ;
      SQL SELECT baseqty,
          baseuom,
          btoordernum,
          company,
          ium,
          partnum,
          poline,
          ponum,
          pum,
          unitcost,
          vendornum
      FROM epicor904.dbo.podetail
      WHERE btoordernum=0;
      
      PORel:
      Inner Keep (PODetail)
      LOAD
          baseqty as porelbaseqty,
          baseuom as porelbaseqty,
          company & '-' & ponum & '-' & poline as porellink,
          date(duedate) as PODue,
          porelnum as poporelnum,
          receivedqty as POreceivedqty,
          relqty,
          smircvdqty,
          xrelqty;
      SQL SELECT 
          baseqty,
          baseuom,
          company,
          duedate,
          openrelease,
          poline,
          ponum,
          porelnum,
          receivedqty,
          relqty,
          smircvdqty,
          xrelqty
      FROM epicor904.dbo.porel Where openrelease=1;
      

      This is the error:

       

      OLEDB read failed
      SQL SELECT 
          baseqty,
          baseuom,
          company,
          duedate,
          openrelease,
          poline,
          ponum,
          porelnum,
          receivedqty,
          relqty,
          smircvdqty,
          xrelqty
      FROM epicor904.dbo.porel Where openrelease=1
      

       

       

      My eyes do not see any issue with my script, but it is probably something simple that I am just  missing.

        • Re: OLEDB read failed

          Found the issue.

          PORel:
          Inner Keep (PODetail)
          LOAD
              baseqty as porelbaseqty,
              baseuom as porelbaseqty,
              company & '-' & ponum & '-' & poline as porellink,
              date(duedate) as PODue,
              porelnum as poporelnum,
              receivedqty as POreceivedqty,
              relqty,
              smircvdqty,
              xrelqty;
          SQL SELECT
              baseqty,
              baseuom,
              company,
              duedate,
              openrelease,
              poline,
              ponum,
              porelnum,
              receivedqty,
              relqty,
              smircvdqty,
              xrelqty
          FROM epicor904.dbo.porel Where openrelease=1;