Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Environment Information:
----
For the past 7 weeks we have experienced problems with the QlikView Distribution Service on our QlikView Server (QlikView 11 SR7 on server and clients)
The problems have been with two of our QVW reloads, where the Distribution Service would cause the two reloads to hang at least 4 times every day. To recover from this situations, we are forced to kill the hung QVB.exe processes, delete any TMP files and re-run the reloads.
We have been troubleshooting this issue for weeks, but have been unable to get to the root cause.
Observations:
1) The problems are only occurring with 2 out of 32 QVW reload tasks.
2) The 2 QVWs experiencing the problem has a reload scheduled every 20 minutes / 3 per hour / 72 per day. The hung process only happens approx. 4 times out of the 72 times the reload task is running.
3) When the QVB process hangs, it happens at specific times during the day (every 3 hours). Although the QVB process doesn't hang every 3 hours, it always happens at either 12am, 3am, 6am, 9am, 12pm, 3pm, 6pm
4) Manual reloads of data from the QlikView client are always successful. Reload time: 3 minutes
5) The 2 affected QVWs queries both SQL tables and QVDs.
6) If we remove the QVD queries and access only SQL tables, the reload tasks hang EVERY time.
7) When the hangs are happening, no error messages are occurring, which means that no errors are captured in the Distribution log, QlikView logs or Windows Logs.
😎 Since no errors are logged and no crashes are taking place, Windows Debugger isn't logging anything either.
Qlik Support has shown little interest in helping and I have spent hours providing log files without any feedback on possible root causes.
Any ideas of what we should do as next steps, other than a complete re-installation of QlikView 11 SR7?
We have fixed this issue, actually this issue comes when there are huge no of tasks in the QMC , so when we migrated two to three application to different cluster this issue not occur again.
RCA: do to the capacity of the server this issue comes. This will be resolved by moving the applications in to different cluster (consider the applications should have more no of tasks scheduled in the QMC)
Hello,
1) Is there any chance to share the log file which two files are not working, Please?
2) It's happen to the post of 3 Hours?
3) Did you created any script for that?
4) Can you please share me the error which you receive the ERROR?
- Anil Chowdary
Gopi,
What are the current memory heap size settings on your server? Increase the settings to 1024,20480,2048
we have hanged heap size to 1024,20480,2048
Hope it is a qlikview bug that is present 11.2 SR1 but in SR2 it got fixed as per the qlikview document but we have the same issue in qlikview 11.2 SR12
Bug 46252:
We have fixed this issue, actually this issue comes when there are huge no of tasks in the QMC , so when we migrated two to three application to different cluster this issue not occur again.
RCA: do to the capacity of the server this issue comes. This will be resolved by moving the applications in to different cluster (consider the applications should have more no of tasks scheduled in the QMC)