topic Re: Send Email to adminstrator on reload failure in QlikView

Send Email to adminstrator on reload failure

krishnacbe — Mon, 26 Jan 2026 18:19:17 GMT

Can any one help me to send mail from QVS(QEMC) when reloading a document fails.

Thanks in advance.

Regards

Krishna.S

Re: Send Email to adminstrator on reload failure

dde — Tue, 04 Sep 2012 14:40:18 GMT

Depends if you have Publisher or not.

Regardless you need to set up a connection to an SMTP mail server on the Mail Server screen in the System tab of the QlikView Management Console. Then you need to populate the list of users who will receive e-mail alerts; the screen where that's specified varies depending on if you have Publisher or not.

Re: Send Email to adminstrator on reload failure

krishnacbe — Wed, 05 Sep 2012 03:55:58 GMT

Hi Dave

Thanks for your reply.

I don't have publisher. Can you please guide me the settings that should be done to receive email alerts.

Thanks.

Regards

Krishna S

Re: Send Email to adminstrator on reload failure

dde — Wed, 05 Sep 2012 17:22:23 GMT

As I mentioned you will need to set up a connection to your SMTP mail server in the QlikView Management Console (or Enterprise Console if you are earlier than QV11). System/Setup tab, select "Mail Server" on the left pane and populate your SMTP details.

Following this again the the left pane expand "QlikView Servers" and select your QVS. In the right pane there should be a tab named something like "Alerts" or "Alert Emails" (I don't have a server in front of me so can't remember exact wording). In that tab you will need to list all email addesses who need to receive email job alerts.

Thanks

Dave

Re: Send Email to adminstrator on reload failure

krishnacbe — Thu, 06 Sep 2012 04:32:28 GMT

Hi Dave

Thanks.

I have added the email address in server -> Alerts tab. For testing I have made an reload error. But mails are not triggered. Test mail is working fine from mail server. But alerts are not working.

Regards

Krishna S

Re: Send Email to adminstrator on reload failure

dde — Thu, 06 Sep 2012 07:07:23 GMT

That's weird. I can only suggest uploading screenshots of the two screens (with sensitive information obscured).

Re: Send Email to adminstrator on reload failure

krishnacbe — Thu, 06 Sep 2012 11:18:58 GMT

Hi Dave

Email Alerts are working fine as you suggested.

Thanks a lot.

Regards

Krishna S

Re: Send Email to adminstrator on reload failure

swuehl — Tue, 18 Sep 2012 07:19:59 GMT

Hi Krishna, Hi Dave,

I seem to have a similar problem.

Email alert is not sent for some of my documents.

Test email is working ok, and if I create a qvw with just a syntax error in the script and schedule a reload, it fires an alert.

But for another document, I don't get any emails. This is the part of its logfile:

KPI:

2012-09-18 00:10:24: 0189 LOAD VERTRAGSNUMMER,

2012-09-18 00:10:24: 0190

2012-09-18 00:10:24: 0191 MOD_TIME as MOD_TIME_KPI,

2012-09-18 00:10:24: 0192 KPI_ID,

2012-09-18 00:10:24: 0193 KPI_NAME,

2012-09-18 00:10:24: 0194 ANZAHL_30D,

2012-09-18 00:10:24: 0195 ANZAHL_90D,

2012-09-18 00:10:24: 0196 UMSATZ_30D,

2012-09-18 00:10:24: 0197 UMSATZ_90D,

2012-09-18 00:10:24: 0198 VOLUMEN_30D,

2012-09-18 00:10:24: 0199 VOLUMEN_90D,

2012-09-18 00:10:24: 0200 DAUER_30D,

2012-09-18 00:10:24: 0201 DAUER_90D,

2012-09-18 00:10:24: 0202 LAST_EVENT,

2012-09-18 00:10:24: 0203 day(LAST_EVENT) as Event_Tag,

2012-09-18 00:10:24: 0204 month(LAST_EVENT) as Event_Monat,

2012-09-18 00:10:24: 0205 year(LAST_EVENT) as Event_Jahr,

2012-09-18 00:10:24: 0206 EXP_TIME as EXP_TIME_KPI

2012-09-18 00:10:24: 0207 FROM

2012-09-18 00:10:24: 0208 C:\QlikView_Storage\input\KPI_Delta\*Bestand.csv

2012-09-18 00:10:24: 0209 (txt, codepage is 1252, embedded labels, delimiter is ';', msq)

2012-09-18 00:10:24: 0210 where exists(VERTRAGSNUMMER)

2012-09-18 00:10:24: Error: Field not found - <VERTRAGSNUMMER>

2012-09-18 00:10:24: General Script Error

2012-09-18 00:10:24: Execution Failed

2012-09-18 00:10:24: Execution finished.

I think the error itself is understood, sometimes it happens that a zero length input file is written.

This document is located on a mounted folder. Is there any other condition that needs to be fulfilled that an alert is sent except for the failed reload?

Krishna, it seems that your problems has been resolved. Have you've done anything special or changed anything in Server settings compared to your OP?

Regards,

Stefan

Re: Send Email to adminstrator on reload failure

dde — Tue, 18 Sep 2012 08:51:28 GMT

Stefan

Are you using Publisher or not? QV10 or QV11? Publisher allows you to set it up so that only a specific group of Document Administrators (against a specific Mounted Folder) get alerts.

I can't think of anything else that would cause the alerting to be selective.

Thanks

Dave

Re: Send Email to adminstrator on reload failure

martinpohl — Tue, 18 Sep 2012 08:55:01 GMT

I'm having a similar problem:

Testmails ok, 4 different users.

Alert mail is only sent to one, the last user listed in the recieptians.

In the email header I can found:

To: "<user1@comany.com> <user2@company.com>" <user3@company.com>

Look at the " "

Using NO publisher.

Regards

Re: Send Email to adminstrator on reload failure

swuehl — Tue, 18 Sep 2012 09:02:07 GMT

Dave,

thanks for the quick reply.

yes, my previous post lacks some essentials: QV11 SR1 64 bit on Win 2008 R2 with IIS. No publisher license.

Is there any place where I can trace the email alert into log files?

Martin,

this looks interesting! I haven't got any email (3 recipients set) at all, but I just reloaded the qvw on our backup server and emails got sent out. So I am checking also on differences between these servers.

Regards,

Stefan

Re: Send Email to adminstrator on reload failure

martinpohl — Tue, 18 Sep 2012 09:10:23 GMT

I've tried

user1@company.com;user2@company.com;user3@company.com

user1@company.com,user2@company.com,user3@company.com

user1@company.com user2@company.com user3@company.com

<user1@company.com>;<user2@company.com>;<user3@company.com>

Re: Send Email to adminstrator on reload failure

swuehl — Tue, 18 Sep 2012 09:15:45 GMT

Martin,

you are using one address line for all email adresses? I've used a line per address (using the add button in alert tab).

Re: Send Email to adminstrator on reload failure

dde — Tue, 18 Sep 2012 09:19:15 GMT

For Publisher users I would expect....

user1@company.com;user2@company.com;user3@company.com

....to be the correct approach.

For non-Publisher users I would add one line per address as swuehl suggests.

Re: Send Email to adminstrator on reload failure

flipside — Tue, 18 Sep 2012 09:21:19 GMT

Hi Stefan,

Have you tried restarting the Qlikview Distribution Service? Might be worth a try.

Also worth checking the settings for the task. The log files for the tasks are stored in ProgramData/QlikTech/DistributionService. The Configuration.xml file should show the AlertEmailRecipientList entries as entered in QMC. If you look in the TaskExecutionHistory folder and sort by date descending you can identify the task GUID for the task, then look in Tasks folder and the XML for that GUID to see the setting for SendAlertMail. I'm not sure where this setting is made - if anyone has any ideas?

flipside

Re: Send Email to adminstrator on reload failure

martinpohl — Tue, 18 Sep 2012 09:23:00 GMT

How can I add a line?

There is no possibility

Regards

Re: Send Email to adminstrator on reload failure

swuehl — Tue, 18 Sep 2012 09:31:04 GMT

flipside,

thanks for the information.

The "weird" thing is, that alert emails have been sent out for one qvw, but not for another (reproducible).

Only differences I know between these two apps:

The one that did not send emails is located in a mounted folder and the task is dependent on successful execution of another (which executed successfully).

On our cold-standby server, things seem to run now, I am still checking on differences between the servers.

Regards,

Stefan

Re: Send Email to adminstrator on reload failure

swuehl — Tue, 18 Sep 2012 09:32:19 GMT

Martin,

there should be a green + sign button at the upper right of the alert tab (same line as "Address").

Re: Send Email to adminstrator on reload failure

martinpohl — Tue, 18 Sep 2012 09:34:35 GMT

swuehl,

shoulb be but there isn't.

the only + sign is at the document administrators below.

Regards

Re: Send Email to adminstrator on reload failure

flipside — Tue, 18 Sep 2012 09:34:40 GMT

Another place to check would be ProgramData/QlikTech/DistributionService/1/Log/{date}/{time - documentname}/TaskLog.txt - there should be an entry towards the bottom of the file showing Sending Alert mail if there's been a failure.