topic Re: Email alert using Error mode in QlikView

Email alert using Error mode

Anonymous — Fri, 11 Mar 2016 17:32:07 GMT

Hi Guys,

I have implemented email-alert on failure of my dashboard and also on successfull completion of my dashboard.

I am using Error mode=0 to create two alerts(one for successful and one for failure). It is working fine and I am getting error description also in my mail body. But big challenge is when error occurs, due to error mode set zero, dashboard with incorrect data model getting distributed to accesspoint. I want t o stop distribution of dashboard incase error occurs.

Any idea will be very helpful here.

Re: Email alert using Error mode

martinpohl — Fri, 11 Mar 2016 17:40:53 GMT

So why you are using errormode = 0 when you don't want to reload and distribute the applikation?

My suggest:

1.Do reload your data model in a seperate app.

While using erromode = 0 use scripterrorcount at the end of script.

load the value into a table.

2. Create a second app, use binary load the data model from app 1. Don't use errormode = 0 here and crash application if scripterrorcount >0

3. Create a task with multiple succesfull load tasks. Here use task 1 and 2.

So task 3 will only start if there is no script error.

Regards

Re: Email alert using Error mode

Anonymous — Fri, 11 Mar 2016 19:29:52 GMT

Hi Martin,

Thanx for your response. But I am not clear with this concept. Could you please explain more elaborately?

How to crash application by Scripterrorcount>0?

Re: Email alert using Error mode

martinpohl — Fri, 11 Mar 2016 19:36:34 GMT

write a script that must create an error.

For example:

//Write scripterrocount into variable

let Errors = peek('ErrorCount',0,'Errors');

if $(Errors) > 0 then

abc //script that doesn't work

else

Trace No errors found;

endif

Re: Email alert using Error mode

Anonymous — Sat, 12 Mar 2016 09:32:12 GMT

Ok i got it I need to create two qvw one is for only reloading the script and saving to some qvd and other to binary load first one and check for error, if error occurs it will fail or else it will run and distribute.so incase successful, it will run twice.

But wont that be performance challenge, my application size is big, loading same application twice will be challenging?Is there any other way for it?

Re: Email alert using Error mode

Kushal_Chawda — Sat, 12 Mar 2016 10:06:09 GMT

Let the QlikView application run with error.

Create a alert email from QlikView server or from QlikView desktop Alert feature on failure

Once you get the alert email. You can check the log file of the QVW application for error.

Re: Email alert using Error mode

martinpohl — Sat, 12 Mar 2016 10:15:20 GMT

Hello,

if your application is big, you can store the scripterrorcount into a qvd and do a load from this qvd instead of binary load.

So this app only will habe one table with one field and one value.

Regards

Re: Email alert using Error mode

Anonymous — Sat, 12 Mar 2016 18:31:02 GMT

Hi Kush,

Could you pleas tel me how should i implement alert in Qlikview desktop on dashboard failure?Because I am not able to find a logic to set alert with script error? Could you please tel me the logic

Re: Email alert using Error mode

Anonymous — Sat, 12 Mar 2016 18:32:15 GMT

Thanks Martin, your responses are very helpful. But I am not supposed to use alert in different qvw, I want within same dashboard.

Re: Email alert using Error mode

Kushal_Chawda — Sun, 13 Mar 2016 05:36:50 GMT

Open your application, go to Setting -> User Preference -> Mail.

Configure your SMTP server email account. You will get the Alert email from this account on reload.

Now in the same application go to Tool -> Alert -> Click on Add and do the setting as below

Now when application fails to reload mail will be triggered.

Re: Email alert using Error mode

Anonymous — Mon, 14 Mar 2016 06:21:51 GMT

Hi Kush,

But this function does not trigger any email from qmc. Is it working for you?

Re: Email alert using Error mode

Anonymous — Fri, 25 Mar 2016 12:07:40 GMT

Hi Martin,

As I was unable to implement in same dashboard I have used your concept and implemented.

Thanks for the help. I am facing one issue in some dashboard though Error mode is set to zero , it fails in middle when there is any error. Why Errormode acts differently in different dashboards. Also noticed one more bug ScriptErrordetails will have blank values some times, also in some cases scripterrordetails variable ll not appear. Could you please explain why it behaves like this

Re: Email alert using Error mode

martinpohl — Fri, 25 Mar 2016 12:18:31 GMT

hello,

blank values n scripterrordetails I never had before.

Errormode 0 for me works to run the script although there are errors in.

But what never works (even with errormode 0) is to use a store command when the table can't be stored (missing folder, missing folder right, file is blocked by another user etc). This wil cause an error and stop the script all times.

For more analyse attach your script log.

Regards