topic Re: sending alert mail when getting error while reloading in QlikView

sending alert mail when getting error while reloading

QSense — Wed, 18 Jun 2014 18:21:19 GMT

hello everyone,

I want to send email while my document gets error when reloading.

my script is:

SET ErrorMode=0;

LOAD AA,

FROM

(ooxml, no labels, table is Sheet1);

SET ErrorMode=1;

I added alert. for condition I wrote ScriptErrorCount<>0 but any email comes to mail adress.

Is there anyone who met this problem before

thanks.

swarup_malli — Wed, 18 Jun 2014 18:24:29 GMT

Ahnet,

Do you mean when the reload fails on the QV server an email should be sent to the concerned person ?

QSense — Wed, 18 Jun 2014 18:32:49 GMT

yes exactly I mean that. Swarrup

Anonymous — Wed, 18 Jun 2014 18:37:37 GMT

Type the email id in the spot that has been highligted with an black ellipse.

QSense — Wed, 18 Jun 2014 18:42:53 GMT

I know management console side.In there alerts system is available for all server dcuments.

I want only for a specified document.

It can be made by alert but ı couldnt succeeded

hectorgarcia — Fri, 10 Apr 2015 15:38:37 GMT

modify your script to:

table:

LOAD * INLINE [

dummyfield

];

SET ErrorMode=0;

Concatenate (table)

table:

LOAD AA,

FROM

(ooxml, no labels, table is Sheet1);

SET ErrorMode=1;

let vAlert=NoOfRows('table');

then in the ui you can set up the alert tools\alerts based on the value of the variable vAlert

I hope it helps

Hector