topic Reload in server if QVW fails in QlikView

Reload in server if QVW fails

Tue, 14 Apr 2015 08:06:30 GMT

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

Re: Reload in server if QVW fails

manojkulkarni — Tue, 14 Apr 2015 08:22:55 GMT

Place this statement before your load-statement:

SET errormode = 0;

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

Re: Reload in server if QVW fails

Tue, 14 Apr 2015 08:55:14 GMT

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.

Re: Reload in server if QVW fails

jagan — Tue, 14 Apr 2015 09:24:32 GMT

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.