2 Replies Latest reply: Aug 20, 2010 8:42 AM by fbliss RSS

    Execution Hangs when using External Programs v9 SR5 Publisher

    fbliss

      Up to this point I have been using a 3rd party scheduler to execute the upload. I am now trying to move all these uploads to the v9 SR5 Publisher.

      The command line statement in the External Programs TAB of the Publisher is:

      C:\WINDOWS\system32\CMD.exe /c C:\Qlik\Execution_Batch_Files\Weekly_Sales_Flash_Sent_eMAIL.cmd

      This commands works fine if executed on the server by opening it or running it in the command window on the server.

      The content of the cmd file is

      "c:\Program Files\QlikView\9\qv.exe" /r /veMail=NO "R:\Program Files\QlikWeb8_2\Orders and Sales\Master-Weekly Sales Flash.qvw"

      "c:\Program Files\QlikView\9\qv.exe" /l /veMail=YES "R:\Program Files\QlikWeb8_2\Orders and Sales\Master-Weekly Sales Flash.qvw"

      exit

      It will hang if the System32/cmd.exe parmameter of /c of /k is used.

      If the parmameter is removed the following occurs:

      It executes the cmd on the Publisher within 3-4 seconds without uploading the document.

      (2010-08-19 11:04:21) Information: Executing ClusterID=1, QDSID=073df182-a771-892f-e522-b01a0f2cbdf4 QDSMain.ExternalProgramTask

      (2010-08-19 11:04:21) Information: Starting task "Weekly Sales Flash CMD (Weekly Sales Flash CMD)" (Attempt 1 of 1)

      (2010-08-19 11:04:21) Information: Max run time: 1.00:00:00

      (2010-08-19 11:04:21) Information: Executing C:\WINDOWS\system32\CMD.exe /k C:\Qlik\Execution_Batch_Files\Weekly_Sales_Flash_Sent_eMAIL.cmd

      (2010-08-19 11:04:21) Information: Executing commandline: "C:\WINDOWS\system32\CMD.exe /c C:\Qlik\Execution_Batch_Files\Weekly_Sales_Flash_Sent_eMAIL.cmd" in folder "C:\WINDOWS\system32".

      (2010-08-19 11:04:22) Information: Process exited with exit code: 0 at 8/19/2010 11:04:22 AM

      (2010-08-19 11:04:22) Information: Process exited with exit code: 0 at 8/19/2010 11:04:22 AM

      (2010-08-19 11:04:22) Information: The task "Weekly Sales Flash CMD (Weekly Sales Flash CMD)" finished successfully