
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Silent Batch Reload of qvw with logs
Hi,
I am searching for elegant technique to reload a qvw application, with a .BAT, that produce a log file and that not open pop-up windows if errors during the reload...
Thanks in advance,
Eric.
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
To clarify
Setting ErrorMode to zero is NOT bad practice, although I could possibly accept that it might not be described as Best Practice.
In my situation, setting the error mode to zero was absolutely essential in order to have the overnight refresh function properly and effectively.
When I answer questions such as these, I don't want to be writing essays on the why's and wherefore's of when to use something, when not to use it and how to protect yourself from the potential dangers. I am assuming when somebody asks how to switch errors off, that they accept and know of the potential areas for problems and will take steps to protect themselves from it (i.e. to produce log files and read those log files to ensure things are working).
In my case, I had over 50 QVW files being refreshed automatically through an SSIS package, I switched error mode off because I didn't want a single failure stopping the whole load process. The SSIS package then read log files to ensure a succesfull refresh had taken place on all files and it sent an email if it found a problem. Works sweet as a nut, did exactly what I wanted it to do, no need to reverse my decision on setting error mode. If I had continued with error mode set to its default value I could potentially have a failure on the first file which stops the whole process because a GUI is then waiting for a response, this means that due to one small failure on one small file, the entire organisation now has no new data and my production issues are a very much higher and more visible problem. In my case, I had one small failure, I know about that failure because I have an email that tells me about it, I can inform the small group using that application that they have no new data but the remainder of the organisation is working as required.
I would also accept that there are other way to achieve the same result, perhaps using Publisher to deal with it, perhaps using 50 different batch files on 50 different schedules, but this was discussed and thrown out as an option in our case.
So, in summary, nobody has (to my knowledge) in this thread suggested that you ignore errors.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Have you tried to place the second load after the first ?
"C:\Program Files\QlikView\qv.exe" /r "CEO-LTS Download 2010-10-14 (01).qvw"
"C:\Program Files\QlikView\qv.exe" /r "CEO-LTS 2010-10-24 (02).qvw"
The second line will run only when the first has finished
Regards Etay Elazar

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
One can use ex Windows Scheduler to start the BAT file(s). There is an option called "Stop task if it runs longer than .. ". Supposing normal execution takes 1 hour , you can kill it after 4 hours. This handles the case of a popup with error message and allows for normal performance fluctuations.
Other job schedulers probably have similar features.
-Alex

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Nigel,
your setup sounds exactly what I'm looking for, we are reloading more then 20 qvd files and 19 of them should not be affected when 1 has a small problem. We are not using publisher but run a batch file instead calling all the qvd in a particular order.
May I ask how you set it up so that you get an email notification with the error, if there si an error, and that you bring QV to continue loading?
Looking forward to hearing from you.
Tom

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Tom, check out this thread: http://community.qlik.com/message/204260

- « Previous Replies
-
- 1
- 2
- Next Replies »