Error Handling

[#1]

Is it a good practice to always include error handling in script?  Do most qlikview developers use error handling?   Will the error handling give you information on all errors?

[sudeepkm]

I would suggest that vary from requirement to requirement.

If you have a script that would do  a lot of conditional checks based on exception or error scenarios then it is required to use Error handling. If your script is a simple data load from a source file or database then 'file not found' or 'table not found' or 'db connection' issues would be your regular error messages during error condition which you can find from the QVW log file. You will also get a notification from Publisher that your task has failed.

[#3]

Hi Sudeep,

Thanks for the response   What if you don't have publisher is there any other way to get a notfication that a task has failed.  That's really why I'm asking about error handling.  We had a task that failed recently and did not have any notification so that's  really why I'm asking I'm wondering if implementiing error handling would help at all.

[sudeepkm · Accepted solution]

I think you can do the reload through QVS but one thing I can suggest is if you know the scenarios when your QVW fails then in the script you can handle the error and can run the document reload accordingly. Once the document is reloaded then you can use Document alert feature that can generate alert based on field condition. so if your reload didn't occur as expected and the no. of records are not present then you can trigger a document level alert which will send an email to the recipients mentioned in the "Mail Recipients" section in the Alert creation window.

[Anonymous]

Hi Carole,

Have a look:

Error Handling in Qlikview

Hope it helps!!

[petter]

QlikView Server logs reload progress into both log text-files and to the Windows Event Log. With Windows you can create alerts to be sent when errors arise from QlikView execution.