topic Error handling or exception method in qv in QlikView

Error handling or exception method in qv

Tue, 05 Jul 2011 06:48:45 GMT

Dear all,

Can any one please tell me how can we get a particular message that has occurred during reloading of application.

Ex: if any error comes while reloading in server it gives msg like Reload fail,

But i need to see whether is there any way so that we can get exact msg what is the problem so that the application didnt reloaded.

Please Suggest a answer.

Regards,

Pranav

Error handling or exception method in qv

prieper — Tue, 05 Jul 2011 09:26:36 GMT

There are different ways (as usual):

Create an alert on reading Errorvariable (e.g. SCRIPTERRORCOUNT())
SET ERRORMODE = 1;
will prevent the application to stop on errors.
at the end of the script you may add an action (create a file, do not save - exit script), if there was an error)
if you create a file, you then may create another application reading this.
Read - with another application - the logfiles and inspect them for possible errors.
Via the TRACE-command you may create out of the script further lines, as possible warnings (like unusual little amount of data found.

I prefer method 1 and 3.

1 would also inform the users that the data are probably not trustworthy.

HTH
Peter

Error handling or exception method in qv

Tue, 05 Jul 2011 11:51:19 GMT

Thanks Peter for Reply,

will the application will reload the other tables if in 1st table error occurs

Regards,

Pranav

Error handling or exception method in qv

prieper — Tue, 05 Jul 2011 13:10:14 GMT

If within the same application, you may always terminate the execution with

IF condition THEN EXIT SCRIPT; ELSE ...; END IF

Otherwise you may create a file with comment on the successful loading (or not), which then is picked up by another application - and then the above check may take place.

HTH
Peter