Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

Not applicable
Author

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.