4 Replies Latest reply: Jan 14, 2016 1:49 AM by Tim Hogan RSS

    QVB.exe vs QV.exe Reloads on Publisher

    Istvan Szucs



      I wonder if someone can help with the following problem.


      We have a document loading QVDs from a SQL Server database server. Historically, it has been loading fine, moving 1-2 gigs of data in about 10-20 minutes. For the past week or so, we have noticed that it started to take in excess of 20 hours for no obvious reason. No changes have been made to the document and all other documents transferring data between the same servers (SQL Server to QlikView Publisher) continue to run in similar times as before. Even more interestingly, when we reload the document using the QlikView app (QV.exe) logged into the server, it runs within 20 minutes, just like before. The long running time is only observed when the publisher is used (QVB.exe) and this only happens for this single document.


      On the database server, we can monitor the process running and it consistently has very high waits for PREEMPTIVE_OS_WAITFORSINGLEOBJECT when the Publisher is used to reload the document.


      Any ideas why this may be happening or how we could troubleshoot?


      Thank you for your help in advance!


      PS: Data is returned via several stored procedures from SQL and all SPs show similar increases in running time.