Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Not applicable

Execution Hangs when using External Programs v9 SR5 Publisher

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

2 Replies
Not applicable

Execution Hangs when using External Programs v9 SR5 Publisher

Check if the user you're using for the QlikView Distributino service have a valide QV license, hope help.

Not applicable

Execution Hangs when using External Programs v9 SR5 Publisher

Yes it does have a valid license. All routine uplads and distribution work fine. I believe that the issue is the variable that is being passed. The QlikView document is not seeing the variable. There are functions being preformed by the QV depending on the content of the variable. The "YES" will call a macro on the open which will do some functions and then the QV will quit.

Community Browser