Send Email to adminstrator on reload failure

[krishnacbe]

Hi

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

Thanks in advance.

Regards

Krishna.S

[dde]

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.

[krishnacbe]

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

[dde · Accepted solution]

Hi

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

[krishnacbe]

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

[dde]

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

[krishnacbe]

Hi Dave

Email Alerts are working fine as you suggested.

Thanks a lot.

Regards

Krishna S

[swuehl]

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

[dde]

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

[martinpohl]

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