Publisher and bat file problem

[#1]

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

[#2]

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

objPresentation.SaveAs

[Bill_Britt]

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

[#4]

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

[p_verkooijen]

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.

[#6]

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.

[Bill_Britt]

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

Bill

[rubenmarin]

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.

[#9]

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.

[Bill_Britt]

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