Thanks for your reply. It IS a simple loop and reduce and first time fail. It loops and reduce based on a field values in the data set. No static given values.
I have test the server with smaller size application (few MBs) and worked fine but still cannot figure out the main reason for this failure.
Your help would be much appreciated
Split the task with loop and reduce one time and distribute in second.
But this you will come to know where is the exact issue.
I would suggest you to try by removing _ and spaces from your application / task name
Dashboard BasketAnalysis _ 10s and 20s.qvw
Let me know if that worked.
if small set of data is working fine and bigger set is not working, then it could be either of these reasons.
it is due to the duplication of field values used for loop and reduce.
It might be having more values that qlikview able to loop. I'm not sure what is the maximum number of values that Qlik view can reduce and distribute in loop and reduce functionality.
Your server set up might be running out of memory due to number of values in loop field is more.
Hope this helps.
Please check the write permissions on the User documents folder for the ID which you are running the schedule Task? and apply write permissions to the folder and try again.
if it is still not working, I would suggest to create a qvw file with the data only for 2 distinct values(I mean filter out the possible data in script for 5 values) and try to loop and distribute for those 2 values. If it is working then in it is not issue with the data.
Now you create a task only for reload, then create tasks for distribution as suggested below.
There is a other way(may not be exact solutions), you can create a 7 tasks one after one with Simple loop for your 7 different values.