Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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