QlikView Alert Email sends much later than triggered?

SHurleySteward — Tue, 07 Dec 2021 20:44:10 GMT

I've been playing around with Alert emails to inform me when certain things occur during the load. I'm on QVServer (with publisher) and Desktop May2021SR1. The email triggers and sends, but it comes out hours later than it should have been triggered, and with a datetime that is all wrong. Alert looks like this:

Basically, I want it to send an email if the vPlaybookLoadDate has a datetime that is within an hour if running the load. Or at least that's what I'm trying to accomplish with the vPlaybookLoadDate >= ( NOW() -.04 )

The Alert has this as the body:

='ED Enterprise Scorecard has refreshed the MOR/Playbook info at ' & DATE(vPlaybookLoadDate, 'M/D/YYYY h:mmtt') & ' for ' & vNPrintingPlaybookMonth & '.'

Which produces this:

ED Enterprise Scorecard has refreshed the MOR/Playbook info at 12/7/2021 12:35pm for November 2021.

And was sent at 12/7/2021 at 12:39pm.

All that looks great!... except that the dashboard was loaded at 5:30am and the vPlaybookLoadDate is set to 12/7/2021 5:36am.

So why is it sending 7 hours after it should have been triggered, and replacing the contents of my vPlaybookLoadDate with a completely different time than when it was loaded? Any ideas?

Re: QlikView Alert Email sends much later than triggered?

SHurleySteward — Thu, 09 Dec 2021 21:57:16 GMT

Well, I feel silly. Turns out the report is on our test server, which looks exactly the same, except that it loads at 12:30 in the afternoon. Guess which server was sending the email...

Now I need to figure out why our production server isn't obeying the email alert triggers. But at least it explains why the emails are sending 6 hours late with the wrong datestamp.

topic Re: QlikView Alert Email sends much later than triggered? in QlikView

QlikView Alert Email sends much later than triggered?

Re: QlikView Alert Email sends much later than triggered?