topic Email Alerts in QlikView

Email Alerts

Anonymous — Thu, 15 Dec 2011 18:42:55 GMT

Do I need QV Publisher to get email alerts to work?

I have an alert that works fine in the development environment, but when I post it on the server it doesn't work.

Any suggestions?

Thanks, Cori

Email Alerts

vgutkovsky — Thu, 15 Dec 2011 23:42:55 GMT

If by alert you mean an actual conditional alert in QV, then I'm assuming your alert fires OnPostReload? If so, OnPostReload events are disabled (intentionally) on Server and Publisher reloads so there's no way to get that to work automatically.

If by "alert" you mean just notify users that a reload is finished, then that will work but yes, you need Publisher for that.

Regards,

Vlad

Email Alerts

Anonymous — Fri, 16 Dec 2011 01:08:19 GMT

Vlad, Thanks for the post. I am doing an conditional alert in QV and the alert fires OnPostReload. Can I enable OnPostReload events? If so, how?

Email Alerts

vgutkovsky — Fri, 16 Dec 2011 16:18:40 GMT

OnPortReload triggers just won't work on server-side reloads, sorry.

Email Alerts

rwunderlich — Fri, 16 Dec 2011 16:25:11 GMT

Vlad,

OnPostReload alerts work for me. See

http://qlikviewnotes.blogspot.com/2010/09/monitoring-reload-schedule.html

for an example.

-Rob

Email Alerts

Anonymous — Fri, 16 Dec 2011 16:43:31 GMT

Rob, the link you gave is exactly what I am trying to do.

Works in dev environment but not on the server.

Email Alerts

Fri, 16 Dec 2011 16:54:37 GMT

I use them all the time (QV9Sr4) with no problems and I dont use QVP.

Have you get the alert settings correct (batch/interactive)? Does a very simple alert fire?

Regards

Gordon

Email Alerts

Anonymous — Fri, 16 Dec 2011 17:09:21 GMT

I have both interactive and batch checked. The alert will work if I run it using a batch file. The alert will not work if I run the task inside of my management control panel.

Am I missing a simple setting somewhere?

Email Alerts

vgutkovsky — Fri, 16 Dec 2011 17:22:59 GMT

Rob,

I know that OnPostReload works, I just thought that it didn't work when QDS initiates the reload. I've had QT people confirm this on multiple occasions as a WAD. But you say it's working for you?

-Vlad

Email Alerts

Anonymous — Fri, 16 Dec 2011 17:26:45 GMT

Its working now. Not sure what I did different.

I was having trouble with spam setting this morning. We just got those settings configured correctly so I am guessing that was the problem.

Thanks everyone for the great responses.

Cori

Email Alerts

rwunderlich — Fri, 16 Dec 2011 18:02:12 GMT

Vlad,

There is some ongoing confusion on this. Since V9, OnPostReload has fired for server reloads -- but can't run macros. This is where much of the confusion comes from, because people generally want to run a macro in this trigger.

I note that both the latest V9 & V10 doc say not to use the trigger OnPostReload in server. So that's probably good advice. However, I don't think OnPostReload Alerts are included in this restriction. I know a lot of people sucessfully use the alert in the blog post.

-Rob

Email Alerts

vgutkovsky — Fri, 16 Dec 2011 18:15:30 GMT

Rob, that's good to know, thanks!

Email Alerts

Anonymous — Mon, 14 May 2012 18:00:05 GMT

One of my clients has used OnPostReload and OnPostReduce Alert triggers since V9. In V11, we are noticing that OnPostReload triggers still work, but OnPostReduce triggers do not work in a loop and reduce scenario. I can't find anything in the Server/Pub manual on this (specific to Alerts) so I'm not sure if it is a bug or WAD.
-Phil

Re: Email Alerts

Thu, 28 Jun 2012 14:09:52 GMT

Hello everyone,

I read your interesting posts on e-mail alerting. I have the same problem.

I am trying to run an e-mail alert from a Small Business Edition Server (without Publisher License) of a document when reloading the document. Still it doesn't work.

On the contrary the e-mail alert works fine if I run it in Desktop license. I also tested for sending of an e-mail from server as a test and it works fine.

Do I need the Publisher License to do this or is it due to other configuration that I might have to check?

Thank you in advance.

Ilaria

Re: Email Alerts

Tue, 11 Sep 2012 16:24:08 GMT

Ilaria - I also find that alerts do not fire OnPostReload in QVS SBE (Small Business Edition). However, I can successfully do this in the Enterprise version of QVS. So I would suggest that upgrading to Enterprise would allow your alerts to fire, and that Publisher is not required.

Tammy

Re: Email Alerts

Wed, 12 Sep 2012 11:49:33 GMT

Thank you Tammy.

This is quite a bad news for me bacause I have a SBE license.

Re: Email Alerts

Siva_Sankar — Mon, 24 Sep 2012 05:09:18 GMT

Check out this link, might be helpful. http://www.citagus.com/citagus/blog/creating-automated-alerts-and-emails-sending-based-on-data-loaded-in-qlikview/