A QVD has been long running for 18 hours which usually takes around half an hour to complete its run. It is causing the server to hang. And it automatically completes its run on the next day. It fails on some days and successful runs on some days. This has been hapening since last 6 weeks.
Can anyone help me find the possible root cause and solution for this?
How big is that QVD? Are there any errors on the logs?
If your QVD is on the same server where QlikView is running, check RAM and CPU usage at the time of the reload. It could happen that since the load on the QlikView side is high, the reload, which also needs the QlikView server, does not find the required resources and it stalls or fails.
If it is on a separate server, check the network at the time of the reload. QlikView will need to copy that file locally and open it. If there's a lot of traffic on that network, or bandwidth is limited, the file will take a long time to be open by QlikView, written with fresh data, and then stored.
You need an engine for each reload. If there are no available engines, QlikView will try to get one for 45 minutes. If there are no available engines after that time. The reload will fail with this message.
You can set the number of simultaneously running jobs, by changing the "Max number of simultaneous engines".
However there are many factors to consider here. If you set to many engines the system will run out of recourses.
There are a lot of QVDs running succesfully but only one particullar QVD is failing repeatedly. But without any debugging, it is running succesfully the next day. If its the case of unavailability of engine, other qvds also should fail, right? but only one QVD is failing everytime.