topic Dynamic Alert When Reload failed in QlikView

Dynamic Alert When Reload failed

abhaysingh — Thu, 07 Aug 2014 08:59:31 GMT

Can i set Dynamic alert When my application reload failed?????????/

Re: Dynamic Alert When Reload failed

ashfaq_haseeb — Thu, 07 Aug 2014 09:04:56 GMT

Yes you can schedule the same in Qlikview Server.

Provided if you have QlikView EE and publisher with you.

Regards

ASHFAQ

Re: Dynamic Alert When Reload failed

abhaysingh — Thu, 07 Aug 2014 09:08:37 GMT

No i dont have Publisher or QVE

Re: Dynamic Alert When Reload failed

ashfaq_haseeb — Thu, 07 Aug 2014 09:09:47 GMT

Then you cannot configure the same via server.

May be some macros can help you out here.

Regards

ASHFAQ

Re: Dynamic Alert When Reload failed

deepakqlikview_123 — Thu, 07 Aug 2014 09:10:07 GMT

Hi Abhay

then you can set respective mail ID in QMC.

If reload gets failed you will get error notification.,

thanks,

Deepak

Re: Dynamic Alert When Reload failed

sujeetsingh — Thu, 07 Aug 2014 09:10:39 GMT

Study these threads

How to interrupt reload and throw error if field is empty?

Re: Dynamic Alert When Reload failed

abhaysingh — Thu, 07 Aug 2014 09:50:50 GMT

may i know the steps pls?

Re: Dynamic Alert When Reload failed

deepakqlikview_123 — Thu, 07 Aug 2014 10:09:50 GMT

it's in System > Setup > Distribution Service > Alert Email.

and don't forget to check your junk box, and only fail task will trigger the mail.

Re: Dynamic Alert When Reload failed

ashfaq_haseeb — Thu, 07 Aug 2014 10:18:37 GMT

You need to have publisher License for that.

Regards

ASHFAQ

Re: Dynamic Alert When Reload failed

sudeepkm — Thu, 07 Aug 2014 11:03:02 GMT

One way to achieve it is using QlikView built in alerts which can send emails to recipients.

You can use errormode so that even if there is a failure your document execution still continues.

Then in one table you can load the error message and use it in the alert's subject.

Re: Dynamic Alert When Reload failed

abhaysingh — Thu, 07 Aug 2014 12:18:05 GMT

could u pls elaborate more.........

Re: Re: Dynamic Alert When Reload failed

sudeepkm — Thu, 07 Aug 2014 12:32:33 GMT

Please try to reload the qvw file attached.

Go to Tools > Alert to check the details.

I've enabled Errormode as 0 so that even if there is an error the load will continue.

whenever error occurs QlikView counts and keeps it in ScriptErrorCount variable.

The alert will have the condition that the ScriptErrorCount>0

the message will contain the ScriptErrorDetails .

you need to setup mail server in User Preferences to have the email distribution to be working.