5 Replies Latest reply: May 10, 2012 9:00 PM by Arnold Ayaoan RSS

    Supporting tasks



      As our qlikview documents are really big, we don't want that our customers have to wait a lot of time the first time a document is reached. So, and after noticing that the preloaded option in the QEMC doesn't work as we expected we developed a little VBS script to make a fake request to cause a load of the document by the server.

      The code is more or less as follows:


      ' Create Http object
      SET gHttp = CreateObject("Microsoft.XMLHTTP")

      url = "http://localhost/QvAJAXZfc/Authenticate.aspx?keep="
      gHttp.Open "GET", url, false, "user", "password"


      ' POST Document request
      url = "http://localhost/QvAJAXZfc/QvsViewClient.aspx?mark=&host=QVS@test-server&view=1/text-2years.qvw&platform=browser.gecko.NaN&dpi=96"
      gHttp.Open "POST", url, false
      gHttp.Send "<update mark="""" stamp="""" cookie=""true"" scope=""Document"" view=""1/text-2years.qvw"" ident=""null""><add name=""Document.ActiveSheet"" /><set name=""Document"" add=""mode;servercontrol;ie6false"" /></update>"


      SET gHttp = NOTHING


      It works really well, document is loaded into qv server memory and then the first user to access has not to wait any longer. This code works from  command line and as a window scheduled task, but not from supporting task in QEMC. We would like to know why, as we want to do that after the reloading process of the documents.

      Logs from publisher doesn't show anything but all ok.

      Our Command Line Statement is just: C:\WINDOWS\system32\wscript.exe E:\loader.vbs


      Any ideas or clues?


      As information: Qlikview Enterprise 10 SR3 x64 on a Windows Server 2008 R2 x64.