Discussion Board for collaboration on QlikView Scripting.
I am trying to reload a Qlikview document through another Qlikview Document using the below commands:
EXECUTE cmd.exe /C "D:\Program Files\QlikView\QV.exe" /r "$(v_File_Path)";
When I reload through the Qlikview document it works fine, but when I try to reload through QMC the task just stays there like waiting for something to happen.
I looks like its waiting for some user input or for someone to close the progress bar. Has anyone got an idea to what is happening?
Go to Solution.
Alright Qliktech support pointed me in the right direction. Instead of using QV.exe to reload I should use QVDistributionservice.exe.
EXECUTE cmd.exe /C ""D:\Program Files\QlikView\Distribution Service\QVDistributionService.exe" -r="$(v_TESTE)"";
(Don't forget the Initial and final double quotation)
For future reference:
Set the EnableBatchMode to "True" in the QVdistributionservice.exe.config file and restart the QDS service.
Server Reference Manual:
More functions parameters can be found in the QV Server Reference Manual.
Thank you Troy Raney from Qlikview
Why don't you set a reload task on the QMC with a dependency instead of triggering QV reloads via the script?
Can't you copy paste the script in a batch file and try running the batch file in QMC first??.
If succeed, then make an external event in the QMC trigger and call this batch file to run the job.
Hope it helps
Hi, pherhaps you can create a windows task that run the D:\Program Files\QlikView\QV.exe , using this you do not have to create an execute command in a new qlikview document.
Thanks for your reply, but I can't set a dependency because I don't know which app I need to reload, because they don't exist yet... I know it sounds a bit complicated. Let me try and explain:
1 - I get huge files from a data source, there is no pattern for the file name. The Files contain the same column structure.
2 - I would like to create one app per file so I don't load all the apps at one given time.
So I created and app that looks for new files and creates an app for each one of them, because I don't know their names I can't set them up in QMC.
I can't copy the script to the batch file because there is more to the script than just the reload statement.
The script looks for new files from a Data Source then creates new apps for those files and then try to reload the newly created apps.
I'll be honest and admit that I don't like that setup but I'm sure you have your valid reason for doing this.
Another question is why you would need to create one app per file?
Because the files are huge and I only want the user to see one file at a time, otherwise it will take up all of the servers memory.