topic Restart load from last position when load fails in QlikView

Restart load from last position when load fails

agni_gold — Mon, 06 Jun 2016 10:29:40 GMT

Hi ,

Is this possible to start load from same place where it fails .

Example : Suppose i have 1000 record in my database and when i started my load , in some case it failed at 250 records, so i want that when i make next reload it should start from 251 or called next from last value.

Re: Restart load from last position when load fails

agni_gold — Mon, 06 Jun 2016 10:31:16 GMT

one possibility is that we should run a loop till number of records and creating qvd everytime, but i am not sure what happen to bulk records like million , billion type.

Re: Restart load from last position when load fails

Kushal_Chawda — Mon, 06 Jun 2016 10:37:53 GMT

I don't think you can do so, but you can stop storing the data into the QVD if error found so that You will not loose previously loaded data from the QVD