topic Re: Run Batch Whether User is Logged on or Not in QlikView

Run Batch Whether User is Logged on or Not

rustyfishbones — Wed, 25 Feb 2015 11:20:35 GMT

Hi All,

I have a number of Extract and Transform files that I need to reload using Windows Task Scheduler.

I need to run these whether the user is logged on or not, however this does not work because the Script Execution window needs to open to perform the reload.

I know I can schedule the reloads from the Server, however I don't want the Extract and Transform QVW to be seen on AccessPoint.

How can I get around this, the batch files work fine when I have selected "Run only when user is logged on".

I am sure this is an issue that's been solved by someone possibly gwassenaar or maybe stephen.redmond or stevedark

Under pressure to get this sorted

Regards

Alan

Re: Run Batch Whether User is Logged on or Not

stevedark — Wed, 25 Feb 2015 11:26:41 GMT

Hi Alan,

You can use QMC, as long as your folders are organised sensibly. This article talks about folder structure:

http://www.quickintelligence.co.uk/qlikview-folder-structures/

You can then simply un-tick the Browsable check box next to your QVD generators and all should be well.

Using the QMC is the best route for reloads, as you get error trapping, alerting and logging.

Windows Scheduler can be used, and the progress window shouldn't cause a problem. Macros and system access will do however. Do you have the close on completion ticked on your progress window?

Any failures from Windows Scheduler will cause QV.exe to stay open on the box and clog memory. It's well worth avoiding this approach if you can.

Hope that helps,

Steve

Re: Run Batch Whether User is Logged on or Not

Anonymous — Wed, 25 Feb 2015 11:27:45 GMT

Only folders that are mounted as Document Folders in the QlikView Server QMC config will have their qvw's available via AccessPoint.

If you place your Extract and Transform QVW's in folders that are not mounted as Document Folders for the QlikView Server then they will not be visible.

[Note: This is for an environment running Publisher, not sure if it is the same if one does not have Publisher]

Re: Run Batch Whether User is Logged on or Not

rustyfishbones — Wed, 25 Feb 2015 11:28:51 GMT

Excellent thanks Steve,

I will attempt this now and see how I get on

Regards

Alan

Re: Run Batch Whether User is Logged on or Not

rustyfishbones — Wed, 25 Feb 2015 11:31:15 GMT

Thanks Bill

Re: Run Batch Whether User is Logged on or Not

stevedark — Wed, 25 Feb 2015 11:38:10 GMT

Bill, in QlikView Server without Publisher there is only one set of Folder Mounts, there are not separate ones for reloads and access point - as there is in Publisher.

The way you control things is quite different depending on whether you have Publisher or not.

Alan - there you have both ways of dealing with this. Pick the correct solution for your set-up!

Steve

Re: Run Batch Whether User is Logged on or Not

rustyfishbones — Wed, 25 Feb 2015 11:51:06 GMT

Thanks Guys, I will let you know how I get on

Thanks again

Re: Run Batch Whether User is Logged on or Not

rustyfishbones — Wed, 25 Feb 2015 12:28:29 GMT

Another quick ?

Is there a limit to number of Continuous reloads you can have running.

I have 4 files, 2 Extract and 2 Transform, not huge amounts of Data but important to have the most up to date Data.

the 4 files don't take long to run, can I have them all run continuously?

Regards

Alan

Re: Run Batch Whether User is Logged on or Not

rustyfishbones — Wed, 25 Feb 2015 13:10:34 GMT

Hi,

I have another issue where when I click "Reload Now" my files reload no problem.

But when I try schedule the task nothing happens, all services are running.

Any idea what the issue could be?

Re: Run Batch Whether User is Logged on or Not

rustyfishbones — Thu, 26 Feb 2015 10:18:39 GMT

Hi All,

I managed to sort my original issue, I needed to change an option by editing the triggers for the Scheduled Task.

Now I can use Windows to run the reloads, which I need to do now because the server will not reload the Applications.

Very frustrating

Re: Run Batch Whether User is Logged on or Not

stevedark — Thu, 26 Feb 2015 10:25:42 GMT

Hi Alan,

Do you have Section Access in the application? If so is the user that the QlikView Distribution service is running as set up in the Section Access to have ADMIN rights?

Running Now from QMC or from Windows Scheduler would run in a different user context - so that could explain why it runs one way and not the other.

Steve

Re: Run Batch Whether User is Logged on or Not

luciancotea — Thu, 26 Feb 2015 10:27:21 GMT

You can use the free "JIT Scheduler". It can run as a service and run your reloads without the user being logged in.

Re: Run Batch Whether User is Logged on or Not

rustyfishbones — Thu, 26 Feb 2015 11:03:25 GMT

Hi Steve,

I have no Section Access set up in the file, yesterday the Reload Now was working but not the scheduled task on QMC.

Now neither of them work, I have had our guy here re-look at permissions and users and groups etc...

but still unable to resolve the issue, I can use the Windows Scheduler for now as it working for what I need, but I want QMC to do it, not Windows.

Regards

Alan