QMC Task Hanging Indefinitely

[Anonymous]

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?

[Chanty4u]

chk dis

Task issue in QMC

QlikView 11 SR2 Server Task Reload Hangs

[HirisH_V7]

Hi,

Check this way ,

• Is there any conditional loops in your script.
• Recent Server upgrades!
• synthetic keys/loosely coupled tables

Qlikview task in QMC seems running forever

QMC: Task hangs

HTH,

Hirish

[Anonymous]

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.

[Anonymous]

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.

[janterje]

Hi Mark,

If you have not already done so, I would start by looking in the log file of the qvw.

If you post the log, the community can take a look as well.

BR,

Jan Terje

[Anonymous]

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.

[janterje]

Hi Mark,

I'm pretty confident that this is not a QlikView-issue, but either:

1. A problem on the MySQL server.
   What does the logfiles on the MySQL server say when this problem occurs?
2. A problem with the database driver on the QlikView server.
   Is it the same driver version on the delveloper and prod server?

BR,

Jan Terje

[Anonymous]

Thanks Jan,

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.

[#10]

Hello Mark,

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

Thanks

Chaitanya Somineni