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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reload in server if QVW fails

Hi All,

I want my qvd script to execute completely in QMC, even if one of the qvd fails because of source data issue.

For e.g- I have A,B,C,D qvd generates from Qvd script.

Suppose while reloading the script file in server, A qvd refresh was unsuccessful, I want the application to reload completely rather stopping the script execution.

Any suggestions plz?

Thanks in advance

3 Replies
manojkulkarni
Partner - Specialist II
Partner - Specialist II

Place this statement before your load-statement:

SET errormode = 0;

This will force QV to continue even if there's an error.

Not applicable
Author

Thanks for the quick reply.That looks like the solution.

Can I get notified about the qvds which were not refreshed because of this except manually looking at the qvd timestamp?

Thanks again.


jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this

set ErrorMode=0;

load * from abc.qvw;

if ScriptError=11 then // Field not found = 11

TRACE Some fields are missing.

end if

Set ErrorMode = 1

Hope this helps you.

Regards,

Jagan.