topic Re: Problem in executing batch file in QMC in QlikView

Problem in executing batch file in QMC

Anonymous — Fri, 07 Dec 2012 12:35:11 GMT

Hi,

I have created a batch file and tried to execute it in the QMC -> Supporting Tasks. The tasks ran successfully then when I check the qvw file's reloaded time its not showing the correct time. But when I run the batch by double clicking it, its working fine.

Can anyone help me in this.??

Thanks,

Leni Balakrishnan

Re: Problem in executing batch file in QMC

Ricardo_Gerhard — Fri, 07 Dec 2012 18:58:14 GMT

Please, describe your task and the sequence of dependencies. Open you Supporting task and how you config your task of reload.

Re: Problem in executing batch file in QMC

Anonymous — Mon, 10 Dec 2012 09:21:05 GMT

I have created a test task. I that I have configured a test batch file. There is no dependency and all.

The batch file has a reload comment.

Please find the attached print screen

Thanks,

Leni

Re: Problem in executing batch file in QMC

Ricardo_Gerhard — Mon, 10 Dec 2012 10:51:33 GMT

Try this:

- Change da Supporting task to run locally, not in the network;

- Try to run manually the sequence with the account that run the service Qlikview Distribution Services;

If this application is reloaded, the date of qvw file needs to be changed also.

Re: Problem in executing batch file in QMC

Anonymous — Mon, 10 Dec 2012 11:08:16 GMT

- Change da Supporting task to run locally, not in the network

Means to give normal path instead of \\servername\file path in the command line.?? If so, I have tried using that path also but not working

- Try to run manually the sequence with the account that run the service Qlikview Distribution Services;

I have manually run the task and checked. It ran without error or warning but the file modified date didnt get updated as it shows like that the application is not refreshed.

Thanks,

Leni Balakrishnan

Re: Problem in executing batch file in QMC

Ricardo_Gerhard — Mon, 10 Dec 2012 11:10:49 GMT

Please, paste the content of your batch file.

What´s the version of Qlikview?

Re: Problem in executing batch file in QMC

Anonymous — Mon, 10 Dec 2012 11:13:37 GMT

The content in batch file "C:\Program Files\QlikView\qv.exe" /r "F:\BatchFileTest\String Functions.qvw" and the Qlikview version is Qlikview 11 SR1.

Thanks for your help

Re: Problem in executing batch file in QMC

Ricardo_Gerhard — Mon, 10 Dec 2012 11:27:55 GMT

So, it´s your problem.

Supporting Task is used for special situations like a copy of file that you need after or before your reload and In your case you are trying to reload a application with a Supporting Task that is not correct.

In your case, what you need is a task of reload only. This option is configured in:

QMC>Source Documents> Select your document String Functions.qvw > In the upper and right side you´ll see a "+". Press it and config only "Manually"

In "Triggers" > Current Triggers > Press "+" and youll make your schedule.

After it, you´ll see in the Status bar yor task,

Re: Problem in executing batch file in QMC

Anonymous — Mon, 10 Dec 2012 11:33:29 GMT

Ok. Can you give me a sample of bat file that is used in Supporting tasks.??

I thought reload bat can also be used in Supporting tasks thats why tried with this command.

Thanks for your explanation Ricardo

Re: Problem in executing batch file in QMC

Ricardo_Gerhard — Mon, 10 Dec 2012 11:41:46 GMT

Ok. Can you give me a sample of bat file that is used in Supporting tasks.??

1º Task - Supporting Task - cleanfiles.bat

move d:\oldfiles d:\backupfiles\date

copy \\network\xlsfiles d:\filesdoread

2º Task - Reload Taks of Publisher dependencies

This task will reload a QVW file after moves of files, reading a correct files.

Re: Problem in executing batch file in QMC

Anonymous — Mon, 10 Dec 2012 12:05:42 GMT

Thanks Ricardo

The move/copy command worked

I would like to know whether there is any other operations can be done using supporting tasks like Move/Copy.

Thanks,

Leni

Re: Problem in executing batch file in QMC

Ricardo_Gerhard — Mon, 10 Dec 2012 12:14:20 GMT

Ok, great.

All of you want and you cannot create in your QVW file and it is necessary to you reload, you can create a Supporting Task.

Examples:

- A database script to change the value of one field to tag as "OK"

- Kill application and open it again;

- Send a message to your partner;

- Restar Services berfore reload a big application.

It´s samples.

Re: Problem in executing batch file in QMC

Anonymous — Mon, 10 Dec 2012 12:22:15 GMT

Thanks a lot Ricardo

It helped me to understand the use of Supporting tasks

Thanks

Re: Problem in executing batch file in QMC

Anonymous — Tue, 11 Dec 2012 08:46:38 GMT

Hi Ricardo,

I tried to open an application using batch from supporting task but it is not working.

This is the command I gave in batch file

"C:\Program Files\Qlikview\Qv.exe" "F:\Test\Test.qvw"

Once I run the task I have checked from Task Manager, I can see an instance for the application like Qv.exe but the file is not opened.

Please tell me where I am going wrong.

Thanks,

Leni

Re: Problem in executing batch file in QMC

dmohanty — Thu, 09 Jul 2015 20:47:22 GMT

Hi Leni,

Did you get any help at this step?

We have a same requirement. i am able to get the QV.exe process started, but the QVW is not getting opened.

Please suggest.

Re: Problem in executing batch file in QMC

t_witzgall — Wed, 03 Feb 2016 15:36:27 GMT

Hi DMohanty,

maybe you're missing the licence for the user?

You need to do the licence lease first time manually - otherwise QV will start in personal edition and cannot open documents which are created by another user.

Regards,

Tamara