Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Corrupted QVD-Error Handling

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

2 Replies
Not applicable
Author

My ErrorMode doesnt works in this case.

Regards,

Siva

marcus_sommer

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