topic Re: Exit Script Any errors occurs during reloading in QlikView

Exit Script Any errors occurs during reloading

suresh_qv50 — Fri, 06 May 2016 15:16:44 GMT

Hello All,

I am trying to perform incremental load (Insert only) on large volume of data, some times due to OLEDB errors only partial data loaded and missing some of the data. So i tried that if any errors occurs in script we have to exit the entire script without storing the data into Qvd.

My Logic was not working. Am sharing the script what we used Please suggest me Regarding this issue.

Script:

Payments:

LOAD locid,

locstatementdetailid,

ltapportioncodeid,

keydate

FROM

$(vQvdPath)Payments.Qvd (qvd);

Temp:

LOAD keydate Resident Payments order by keydate;

let vMaxKeyDate = Peek('keydate',-1,'Temp');

drop Tables Payments,Temp;

NoConcatenate

Payments:

LOAD locid,

locstatementdetailid,

ltapportioncodeid,

keydate;

SQL

SELECT * FROM $(vSourcePath)Payments Where keydate > '$(vMaxKeyDate)';

Concatenate(Payments)

LOAD locid,

locstatementdetailid,

ltapportioncodeid,

keydate

FROM

$(vQvdPath)Payments.Qvd (qvd);

If ScriptError >= 1 then

Exit script;

End if

STORE Payments into $(vQvdPath)Payments.Qvd(qvd);

drop table Payments;

Payments:

LOAD locid,

locstatementdetailid,

ltapportioncodeid,

keydate

FROM

$(vQvdPath)Payments.Qvd (qvd);

Re: Exit Script Any errors occurs during reloading

sunny_talwar — Fri, 06 May 2016 16:28:34 GMT

Have you set the error mode to 0?

SET ErrorMode = 0;

Re: Exit Script Any errors occurs during reloading

Kushal_Chawda — Fri, 06 May 2016 16:38:44 GMT

Try to chnage your script error variable

SET ErrorMode=0;

Payments:

LOAD locid,

locstatementdetailid,

ltapportioncodeid,

keydate

FROM

$(vQvdPath)Payments.Qvd (qvd);

Temp:

LOAD keydate Resident Payments order by keydate;

let vMaxKeyDate = Peek('keydate',-1,'Temp');

drop Tables Payments,Temp;

NoConcatenate

Payments:

LOAD locid,

locstatementdetailid,

ltapportioncodeid,

keydate;

SQL

SELECT * FROM $(vSourcePath)Payments Where keydate > '$(vMaxKeyDate)';

Concatenate(Payments)

LOAD locid,

locstatementdetailid,

ltapportioncodeid,

keydate

FROM

$(vQvdPath)Payments.Qvd (qvd);

If ScriptErrorCount > 0 then

Exit script;

End if

STORE Payments into $(vQvdPath)Payments.Qvd(qvd);

drop table Payments;

Payments:

LOAD locid,

locstatementdetailid,

ltapportioncodeid,

keydate

FROM

$(vQvdPath)Payments.Qvd (qvd);