topic Re: Reload task Failure due to web service call in QlikView

Reload task Failure due to web service call

avinashelite — Thu, 05 Feb 2015 07:08:05 GMT

Hi Experts,

I an facing a issue with the reload task, hope will get help from the community.

I have 4 to 5 reload tasks, where I have to read data from XML files which are stored in a web server.

The problem is some times it read the data successfully but sometime it fails, when I analyzed the issue, i found the file are available in the server but the web service call is down because of which the reload are getting failed sometime.

My question is how to handle this sort of situation, it not generating any logs also for this . The reload start properly but get struck at the XML reload !!!!! after the session timeout the reload task get fails.

Re: Reload task Failure due to web service call

avinashelite — Thu, 05 Feb 2015 07:24:54 GMT

Any inputs on this???

Re: Reload task Failure due to web service call

simospa — Thu, 05 Feb 2015 07:54:23 GMT

Try to enable document log (Settings --> Document Properties --> General tab --> Generate log file

and try to see if you can see an error.

Otherwise, you can use the System Monitor (QlikView Application: System Monitor v5.1.23) to analyse the behaviour of your server.

Re: Reload task Failure due to web service call

avinashelite — Thu, 05 Feb 2015 08:02:11 GMT

Hi Simone,

Thanks for your reply, I have enabled the Generate log file the log is getting generated but its getting struck at the XML reload part.

Re: Reload task Failure due to web service call

simospa — Thu, 05 Feb 2015 08:07:52 GMT

Can you attach part of the log before the execution failed message?

Re: Reload task Failure due to web service call

avinashelite — Thu, 05 Feb 2015 09:43:35 GMT

please see the attached file, their is no issue with the script but it getting struck at the XML part

Re: Reload task Failure due to web service call

avinashelite — Fri, 06 Feb 2015 08:19:46 GMT

Hi tresesco sir

Any inputs from you on this issue????

Re: Reload task Failure due to web service call

avinashelite — Wed, 11 Feb 2015 11:18:26 GMT

hi gwassenaar sir

any input on this??

Re: Reload task Failure due to web service call

Gysbert_Wassenaar — Wed, 11 Feb 2015 11:23:59 GMT

What do you want to happen? Qlikview won't restart your webservice for you if it goes down. If you want the reload to fail gracefully set an ErrorMode and check the errors that occur and deal with them by taking some action or ignoring the error. Perhaps this document helps: Error Handling in Qlikview

Re: Reload task Failure due to web service call

avinashelite — Wed, 11 Feb 2015 11:31:10 GMT

thanks for the reply.

yes i can set the error log, but what about the data ??? because i have a report completely built on this XML data.

I think the best way is to store the XML data into QVD and as you told need to handle the error in script by setting the ErrorMode and if any error occur then reload from old data from qvd. That's all we can do rite