OLEDB read failed

Thu, 08 Sep 2011 15:19:13 GMT

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

Thu, 08 Sep 2011 15:53:43 GMT

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;

topic OLEDB read failed in QlikView

OLEDB read failed

Re: OLEDB read failed