Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please Explain anyone ...
Use of ERRORMODE
Thanks.....
ERRORMODE is used to provide logs for any qv reload failures.
Setting a property is ERRORMODE like: ERRORMODE=2 in your reload script, will help you to gather the reload failure logs due to any particular reason.
if you set the Errormode = 0 then QlikView will ignore errors in the script execution and keep running instead of popping up error messages and or failing in the reload process. With a bit of scripting you can capture the error messages and act accordingly by taking different paths in the script etc. in case of different events.
Unfortunately (despite the description in the manual), ErrorMode=0 does not always ignore errors. Please see this idea and vote to get this bug fixed...
http://community.qlik.com/ideas/3443
Thanks
Please refer to page 292 of the Qlikview reference manual (for me this is installed to C:\ProgramData\QlikTech\QlikView Documentation\Reference Manual\QlikView Reference Manual.pdf):
This variable determines what action is to be taken by QlikView when an error is encountered during script
(non-batch mode). By setting ErrorMode =0 QlikView will simply ignore the failure and continue script
execution at the next script statement. By setting ErrorMode =2 QlikView will trigger an "Execution of
script failed..." error message immediately on failure, without prompting the user for action beforehand.
Hello
Just a shot in the dark, as the issue is quite old, but you never know
using QV10 SR4, i also had issues with ErrorMode being ignored
the case was an Excel 2003 file being opened not with biff but ooxml format (dont ask why...)
the BadZip file error would come up regardless of me setting ErrorMode to 0
all this was happening inside a QVS script, referenced by an include
then i moved the set ErrorMode to within the document code before the include
And voila, all of the sudden it worked...
Hope this helps
Merci Arnaud. Very interesting observation. I was having seeing this behaviour happening on 11.2 SR2 even with the SET ErrorMode statement in the document.
Regards,
Graeme