Exit Script Any errors occurs during reloading

[suresh_qv50]

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); 

[sunny_talwar]

Have you set the error mode to 0?

SET ErrorMode = 0;

[Kushal_Chawda · Accepted solution]

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);