topic Corrupted QVD-Error Handling in QlikView

Corrupted QVD-Error Handling

Thu, 12 Feb 2015 05:25:55 GMT

Hi all,

I have one small doubt in Qlikview Error handling.

I am transfering QVDs with the help of FTP from server to the local machine. Due to Connectivity issue , some qvds are partially transfered.

I have 10 QVDs in my load script . From these , two qvds are partially transfered.

I have set errormode =0; to skip the corrupted qvds and move to the next statement. Kindly sort my issue.

My Load Script:

Set ErrorMode=0;

SALES:

Load *

From SALES_*.qvd(qvd);

Regards,

Siva

Re: Corrupted QVD-Error Handling

Thu, 12 Feb 2015 05:26:55 GMT

My ErrorMode doesnt works in this case.

Regards,

Siva

Re: Corrupted QVD-Error Handling

marcus_sommer — Thu, 12 Feb 2015 13:54:54 GMT

Maybe you could detect the corrupted qvd inside your error-handling with a file-functions like filetime() or filesize() or qvdnoofrecords(). If not then you need a way to compare such things like the filesize from server and local - maybe if you creates an additionally check-table with these informations in txt-fileformat or similar.

- Marcus