Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Publisher and bat file problem

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

9 Replies
Not applicable

Re: Publisher and bat file problem

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

objPresentation.SaveAs

Employee
Employee

Re: Publisher and bat file problem

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

Not applicable

Re: Publisher and bat file problem

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
Valued Contributor

Re: Publisher and bat file problem

Could it be that the D:\ is a share ? Then you should use a UNC path \\servername\sharename since there is no D: 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.

Not applicable

Re: Publisher and bat file problem

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.

Employee
Employee

Re: Publisher and bat file problem

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

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.

Not applicable

Re: Publisher and bat file problem

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.

Employee
Employee

Re: Publisher and bat file problem

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

Community Browser