Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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;