I have a QMC task that runs every day and normally takes around 15 seconds to complete. Recently however it seems to hang every few days and doesn't complete until we cancel it.
It's a query running against a MYSQL database and we can see the query from the database, but there don't appear to be any rows being returned.
I had the same issue running the task directly on the Qlikview server so it doesn't appear to be an issue with QMC. When I copied the live qvw and tested in our development area it worked ok, so I removed the initial qvw and replaced with the development version which resolved the problem, but a week later it started the same behaviour. Has anyone else experienced this issue?
Thanks for the reply. It doesn't sound like it's related to the second issue as everything works as expected in QMC other than the task hangs. I am also experiencing the same issue when running the qvw directly.
With regards to the first link, it sounds similar in some ways, but we are shortly having our server replaced so this may resolve if it is related.
Thanks for the reply. Its simply a sql query which then stores into a QVD so it doesn't fit two of those three suggestions. The server hasn't been upgraded so that should not be an issue.
Thanks Jan, unfortunately we don't store a history of the logs and its overwritten every day. Today the job ran ok but we'd already looked at the log and it looks exactly the same as when the job runs successfully. It is hanging when running a MySQL query and the log is simply waiting for a response.
I'm pretty confident that this is not a QlikView-issue, but either:
I've had our DBA have a look at the query while its executing against the database and not returning any rows and there appears to be nothing unusual about it other than not returning any rows. If I copy the SQL and submit directly against the database it responds immediately.
The drivers seem fine as the jobs run with no issues most days, just occasionally they experience this issue, even when running directly on the qlikview server. Another resolution I've found is to 'reduce data' from the qvw and resubmit and this seems to resolve the issue.
There seems to be nothing I can pinpoint as a problem, but this is happening almost every day now on a different job.
What is the QMSChunkSize set on your QVManagementService.exe.config file? This file is located under C:\Program Files\QlikView\Management Service. If it set to 100, change it to 50 and vice versa