topic I Want to send alerts if there are data extract errors in QlikView

I Want to send alerts if there are data extract errors

Wed, 16 Apr 2014 05:29:27 GMT

Hi,

I am having the bellow excel sheet my requirement is to send email alert if reload of qvw fails, the content of that mail should be database name QVWname ScriptErrorDetails

for example if reload of BiAttribLoad.qvw fails it has to send a mail containing details

Database Name-stcorpref

QVWname - BiAttribLoad.qvw

ScriptErrorDetails-SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Insufficient information to connect to the data source.

Thank full for suggestions.

Rakesh

Re: I Want to send alerts if there are data extract errors

maxgro — Wed, 16 Apr 2014 08:46:47 GMT

see attachment for some idea (script and alert)

I used a script to trigger an alert (variable vAlert) and another variable to store the error

the error is displayed in a popup after the reload (only when there is an error)

you should adapt to your excel, replace popup with mail but the idea seems to work; hope it helps

SET ErrorMode=0; // 0 = when error ignore failure, continue script execution

LET vAlert = 0; // 0 no alert, 1 alert

// wrong connection; throw an error

// replace with your load from excel

OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=pippo;Data Source=dev11;Extended Properties=""] (XPassword is paperino);

// store error code and description

LET vError = ScriptError & ' - ' & ScriptErrorDetails;

// ? alert

if len(trim($(vError)))>0 then

// 1 to trigger alert on post reload

LET vAlert=1;

ENDIF;

// exit if alert

if $(vAlert) then

trace '$(vError)';

exit script;

end if;

// continue standard execution

set ErrorMode=1; // default

LOAD DEPTNO,

DNAME,

LOC;

SQL SELECT *

FROM TEST.DEPT;

Re: I Want to send alerts if there are data extract errors

Wed, 16 Apr 2014 10:39:36 GMT

Hi,

Thanks for your valuable information but this is not working out in my case, can you please generate a application based on the excel sheet I had provided.