Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
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.

5 Replies
swarup_malli
Specialist
Specialist

Ahnet,

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

SM


QSense
Creator II
Creator II
Author

yes exactly I mean that. Swarrup

Anonymous
Not applicable

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

qvCommunity.png

QSense
Creator II
Creator II
Author

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
Partner - Creator III
Partner - Creator III

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