Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

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;

1 Reply
Not applicable

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;

Community Browser