topic Re: QMC Supporting Task not executed properly in QlikView

QMC Supporting Task not executed properly

anuj_sharma — Sat, 16 Nov 2024 21:06:26 GMT

We've created a QMC Task in System->Supporting Tasks->QDS@**->External Program

and have given path of the .bat file, which contains following command

"C:\Program Files\QlikView\Qv.exe" /l "E:\path_to_my_qlikview_document.qvw"

exit

my_qlikview_document has a macro written inside, which is triggered post-reload in document settings

Running .bat file manually executes the commands written inside successfully.

Running the created Supporting Task doesn't do the same.

Can anybody help figuring out the reasons behind this behaviour?

PFB

Thanks

Re: QMC Supporting Task not executed properly

m_woolf — Fri, 05 Apr 2019 13:59:51 GMT

Try using /R instead of /I

Take a look at this post by Tim Benoit.

Re: QMC Supporting Task not executed properly

anuj_sharma — Fri, 05 Apr 2019 14:51:32 GMT

@m_woolf

I've tried using the /r switch in the batch file but this doesn't seem to have made any difference.

Also, I do need the application to not be auto-saved and closed by the /r switch after reload because I need to run a macro triggered post-reload, hence the /l switch.

Also, the macro doesn't work after using the/r switch in the batch file

Re: QMC Supporting Task not executed properly

m_woolf — Fri, 05 Apr 2019 15:05:03 GMT

Does your macro save and close the qvw after it completes?

Re: QMC Supporting Task not executed properly

anuj_sharma — Mon, 08 Apr 2019 04:22:04 GMT

Yes, macro contains below two lines

ActiveDocument.Save
ActiveDocument.GetApplication.Quit

Re: QMC Supporting Task not executed properly

qliksus — Mon, 08 Apr 2019 05:32:25 GMT

Can you run the batch file manually using the serviceID which run the QDS ? . Looks like the prompt which the QVW asks when you use a macro should be oked or suppressed .

Re: QMC Supporting Task not executed properly

anuj_sharma — Mon, 08 Apr 2019 05:47:26 GMT

Can you please provide steps to test this?

I had tested the batch file just by double-clicking.

Re: QMC Supporting Task not executed properly

qliksus — Mon, 08 Apr 2019 08:39:21 GMT

Try following the below steps

1) Right click on the batch file and select "Run As different user"
2) Enter the serviceID which runs the QDS and check if there is any pop-up from the macro .
3) If you get the pop-up select the correct option and click ok to run it .
4) After this is done run from QMC and see if it works

Re: QMC Supporting Task not executed properly

anuj_sharma — Mon, 08 Apr 2019 12:05:16 GMT

How do I find the serviceID which runs the QDS?

Re: QMC Supporting Task not executed properly

anuj_sharma — Wed, 10 Apr 2019 05:45:38 GMT

Any idea how 'serviceID which runs the QDS' can be known?

Re: QMC Supporting Task not executed properly

Brett_Bleess — Tue, 21 May 2019 12:43:46 GMT

So what they other poster was trying to convey is the QV.exe must be properly 'registered/licensed' to the QlikView 'Service Account', which you can verify the account by going to the Windows Services Applet and checking what account is running the QlikView services. That account will need to be properly registered/licensed to the Desktop/Qv.exe client, and you will also need to open the file in question logged in as that user or us the Run as Different User option as the other poster recommended to set the macro security. What is likely happening at the moment is dialog requesting macro security clearance is waiting to be answered, but given it is running in batch mode, you will never see the dialog in this case. Hopefully this helps.

Regards,
Brett