Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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.

Highlighted
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.