topic Re: Publisher and bat file problem in QlikView

Publisher and bat file problem

Mon, 26 Jan 2026 18:19:17 GMT

I have an application that recharges a document and then run a macro that generates a power point document, save and closes it.

If I run it from a bat, load document data, generates the power point and closes the QlikView document. From the bat all ok.

If I create a task from the Publisher to run this bat, the job never ends. I have already checked that there is no possibility that a popup window requesting user intervention appears.

We have many such tasks that work ok, the problem is apparently with generate a PowerPoint and Publisher.

The bat file content is:

START "" /MAX /WAIT "C:\Program Files\QlikView\QV.EXE" /l /vS_CDG_CLIENTE=99 /vS_CLIENTE=prueba /vS_TDD=CLIENTE "D:\VENTAS\APPS\VENTAS\QVW\generar_ppt.QVW"

EXIT 0

Someone's happened something similar?

Thank you very much

Re: Publisher and bat file problem

Thu, 09 Apr 2015 21:13:39 GMT

debbuging the macro I see that the problem exists when tried to save the pptx document, with the next command line

objPresentation.SaveAs

Re: Publisher and bat file problem

Bill_Britt — Fri, 10 Apr 2015 13:28:52 GMT

I would look at using the Batch reload option of publisher. You should find information on this in the server reference manual. This would also save you a license.

Bill

Re: Publisher and bat file problem

Wed, 15 Apr 2015 14:20:53 GMT

Hello Bill, tankh you for your response.

I really use a batch to reload a document using the command indicated bellow. When i run the bat, te ppt document is generated correctly.

The problem exists when executing the batch from publisher external task. the ppt document not saved and the task not finished.

Best Regards

Guillermo

Re: Publisher and bat file problem

p_verkooijen — Wed, 15 Apr 2015 14:29:45 GMT

Could it be that the D:\ is a share ? Then you should use a UNC path \\servername\sharename since there is no 😧 mapping on systemlevel (only when logged on).

Also if you run a reload using a Batch (or the Windows Task Scheduler) you have to remain logged on to the machine. As far as I know you need a desktop environment for the reload because of the reload progress window using qv,exe ..... /r.

Re: Publisher and bat file problem

Wed, 15 Apr 2015 14:44:30 GMT

Paul, the D is one physical unit in the Publisher server. I debug the macro using a log txt and the last passed logged is previously to ppt save command.

Re: Publisher and bat file problem

Bill_Britt — Wed, 15 Apr 2015 15:12:50 GMT

The Batch reload that you are using is difference than the one I was speaking about and is outline in the manual.

Bill

Re: Publisher and bat file problem

rubenmarin — Wed, 15 Apr 2015 15:19:48 GMT

Hi Guillermo, can it be a permissions issue in the folder where the ppt should be created?, the user executing the bat has write access to that folder but the user executing the task in publisher doesn't have.

Re: Publisher and bat file problem

Wed, 15 Apr 2015 17:07:58 GMT

Hi Ruben. Thanks for your response.

The user has permissions in the ppt directory.

The user that executes ok the bat is the same of run the publisher.

I don´t know what happenings.

Re: Publisher and bat file problem

Bill_Britt — Mon, 20 Apr 2015 12:43:29 GMT

Hi,

The problem with running an application like power point with publisher is that publisher can't tell when that task has finished. Yes, it can start a program like notepad, but it has no idea when notepad finishes and closes. The external program task is best used for DOS commands.

Bill