Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem in executing batch file in QMC

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

1 Solution

Accepted Solutions
Ricardo_Gerhard
Employee
Employee

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.

Ricardo Gerhard
OEM Solution Architect
LATAM

View solution in original post

15 Replies
Ricardo_Gerhard
Employee
Employee

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

Ricardo Gerhard
OEM Solution Architect
LATAM
Anonymous
Not applicable
Author

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

Ricardo_Gerhard
Employee
Employee

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.

Ricardo Gerhard
OEM Solution Architect
LATAM
Anonymous
Not applicable
Author

- 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

Ricardo_Gerhard
Employee
Employee

Please, paste the content of your batch file.

What´s the version of Qlikview?

Ricardo Gerhard
OEM Solution Architect
LATAM
Anonymous
Not applicable
Author

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

Ricardo_Gerhard
Employee
Employee

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,

Ricardo Gerhard
OEM Solution Architect
LATAM
Anonymous
Not applicable
Author

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

Ricardo_Gerhard
Employee
Employee

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.

Ricardo Gerhard
OEM Solution Architect
LATAM