Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

sending alert mail when getting error while reloading

hello everyone,

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

my script is:

SET ErrorMode=0;

LOAD AA,

     B,

     C

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.

Tags (1)
5 Replies
Highlighted
Specialist
Specialist

Re: sending alert mail when getting error while reloading

Ahnet,

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

SM


Highlighted
Creator II
Creator II

Re: sending alert mail when getting error while reloading

yes exactly I mean that. Swarrup

Highlighted
Creator II
Creator II

Re: sending alert mail when getting error while reloading

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

qvCommunity.png

Highlighted
Creator II
Creator II

Re: sending alert mail when getting error while reloading

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

Highlighted
Partner
Partner

Re: sending alert mail when getting error while reloading

modify your script to:

table:

LOAD * INLINE [

dummyfield

];

SET ErrorMode=0;

Concatenate (table)

table:

LOAD AA,

     B,

     C

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