Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

1 Solution

Accepted Solutions
Not applicable
Author

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;

View solution in original post

1 Reply
Not applicable
Author

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;