topic Re: Run cmd file in Windows task scheduler in Qlikview server in QlikView

Run cmd file in Windows task scheduler in Qlikview server

linoyel — Tue, 13 May 2014 12:36:33 GMT

Hi,

I have a c# code that opens a qvw document and sends mail based on the document data.

I need it to be sent once a day, so I wrote a cmd file that works perfectly if I press on it.

The problem starts when I'm putting it in Windows task scheduler - it's not doing anything, and it seems to me it's getting stuck while trying opening Qlikview.

What am I doing wrong?

Is there another way of scheduling the execution of a batch file in BI server?

Thanks.

Re: Run cmd file in Windows task scheduler in BI server

ashfaq_haseeb — Tue, 13 May 2014 12:38:32 GMT

Hi try with Python

Regards

ASHFAQ

Re: Run cmd file in Windows task scheduler in BI server

Peter_Cammaert — Tue, 13 May 2014 12:46:22 GMT

QlikView documents can only be opened if QlikView Desktop runs under an account with a QlikView license. Change the Scheduler task to include a login as a user with a Named CAL.

Best,

Peter

Re: Run cmd file in Windows task scheduler in BI server

linoyel — Tue, 13 May 2014 13:06:15 GMT

Hi Peter, I do run the task with my own user that has the developer CAL.

I's not the license issue...

I'm suspecting that it's not possible to open a qwd document in BI server, but from QMC only.

And it's not good for me cause I don't have to reload this document but just to open it and send a mail (C# code does it all).

**In QMC I can only reload documents, right? I can't run a batch file from it?

Re: Run cmd file in Windows task scheduler in BI server

jonathandienst — Tue, 13 May 2014 13:14:53 GMT

Are you using mapped drives, such as a Y: drive for a network share? These mapped drives are created when you login interactively, and do not exist in the context of a task running in the scheduler. Expand these drives to the full network address instead.

HTH

Jonathan

Re: Run cmd file in Windows task scheduler in BI server

mseeck75 — Tue, 13 May 2014 13:18:59 GMT

Hi Linoy,

a reload will also work from a batch. Here is an example from my test script:

cd "C:\Program Files\QlikView\Distribution Service"

QVDistributionService.exe -r="C:\QvStorage\Private Data\Test\Apps\TechnicalModell@Test.qvw" -out="C:\QvStorage\Private Data\test\Apps\Logs"

echo Error Code: %errorlevel%

But because a reload is not the main problem for you, it will not really help you.

Do you have an installed Qv client on your BI server?

Matthias

Re: Run cmd file in Windows task scheduler in BI server

linoyel — Tue, 13 May 2014 13:21:20 GMT

Hey Jonathan,

In Task Scheduler --> Actions I have an action "Start a program",

Details: "E:\QLIKVIEW\Documents\Marketing Report by mail\SendEmail.cmd"

and the cmd itself looks like this:

"\\bi-srv\E$\QLIKVIEW\Documents\Marketing Report by mail\ConsoleApplication1\bin\Debug\ConsoleApplication1.exe"

**bi-srv is the Qlikview server

What do I have to fix here?

Re: Run cmd file in Windows task scheduler in BI server

linoyel — Tue, 13 May 2014 13:25:19 GMT

Hi Mattias,

Sorry for misleading - BI server is actually a Qlikview server.

Re: Run cmd file in Windows task scheduler in Qlikview server

jerrysvensson — Tue, 13 May 2014 13:53:50 GMT

It could be a problem with priviligies on your account.

We have seen exactly the same behaviour on our development machine. But when we run the same script on another machine with a service account that has higher priviligies than our account it works.

I would check with your IT department to see if they can help you.

Re: Run cmd file in Windows task scheduler in Qlikview server

linoyel — Tue, 13 May 2014 13:56:35 GMT

OK, I've changed something in the Task properties in Windows scheduler:

In the General Window in security options I've changed from the option

"Run whether user is logged on or not"

to the option

"Run only when user is logged on"/

AND IT WORKED!!!

The only thing is that I'm not always logged on, why the option "Run whether user is logged on or not" doesn't work??

Is there a way to make it work?

Re: Run cmd file in Windows task scheduler in Qlikview server

linoyel — Tue, 13 May 2014 14:09:44 GMT

Hi Jerry,

My account has Administrator privileges on QV server. Isn't that the highest one?

As I wrote above, the task runs when the option "Run only when user is logged on" is ticked,

but id doesn't work when "Run whether user is logged on or not" is ticked... and that's the option I need, obviously...

Re: Run cmd file in Windows task scheduler in Qlikview server

Peter_Cammaert — Tue, 13 May 2014 14:38:28 GMT

Linoy,

it is possible to open a QVW document from a Windows Scheduler Task. The problem is a tricky one, and various discussions on the community point in this direction: QlikView Desktop needs an UI and that is incompatible with batch execution (e.g. execution in the background without UI)

Your experiment with selecting option "Run only when user is logged on" clearly points in the same direction. Being logged on means that a "terminal" is available, even though QlikView doesn't need it in order to just execute some macros or access a bit of data.

Note that reloading a document will probably work OK without User Interface. I suspect this is because QlikView disables interactive mode when reloading / executing the load script via the command line.

Re: Run cmd file in Windows task scheduler in Qlikview server

linoyel — Tue, 13 May 2014 14:51:22 GMT

Yeah, I saw a few discussions on the same topic here in the community but the only answer I see here is the same you're telling - that QlikView Desktop needs an UI.

In which QV settings it says that QV desktop can work in interactive mode only? Maybe it's possible to switch it off somehow?

I wonder, what if I use QV Access Point, and not QV desktop?

Does AP obligate interactive mode as well?

Re: Run cmd file in Windows task scheduler in Qlikview server

Peter_Cammaert — Tue, 13 May 2014 19:58:58 GMT

You mean to use the services of a QlikView Server to send email? That's possible as well, but I think you won't be able to use your current custom application for that. Some reasons:

The AccessPoint is nothing but UI and macro features are severely limited. It could work if you write a macro to send email, and then open the document in the IE plugin (won't work in AJAX mode). But this is a manual-only process. And you want to do away with the UI...Doh
The Distribution service is the only one performing a QVW task without UI. It's a pity it will only run the reload script and nothing else
You can schedule a Supporting task (if you have a Publisher) to run your C#-code but then you're stuck with the same problem as before: running a headless QlikView Desktop

IMHO If you want the QlikView Server to send emails based on QlikView data, you'll probably have to change your approach in a major way. The community contains a few tips and tricks to make this work.

(BTW a Publisher supports sending emails after each succesful reload where the message contains a link to the published document with the new data. Something to contemplate?)

Re: Run cmd file in Windows task scheduler in Qlikview server

jerrysvensson — Wed, 14 May 2014 06:40:37 GMT

Yes and no. 🙂

Does your user has the Log on as a batch and Log on as a service privileges for instance?

As I wrote earlier, we have this working on one machine, but not on another.

Re: Run cmd file in Windows task scheduler in Qlikview server

linoyel — Wed, 14 May 2014 07:02:55 GMT

So, if the AccessPoint is nothing but UI, it won't help me...

And I don't have a Publisher 😕

At first (before C# code) I tried to write a macro in the QV module but the problem was that it didn't work with an OnPostReload trigger. It worked with an OnOpen trigger or if I attached macro to a button but it didn't serve my needs cause both of them are manual and I need the e-mail to be sent once a day at the same hour automatically.

I guess I'll:

1. Check in the Community how QlikView Server can send emails based on QlikView data. Not sure though how, cause the only thing I have on the server is QMC that only reloads docs on schedule...

2. Check thoroughly my user privileges (if it has the Log on as a batch and Log on as a service privileges), as Jerry suggested.

3. Check an option to have a certain user to be always logged on.

Re: Run cmd file in Windows task scheduler in Qlikview server

linoyel — Wed, 14 May 2014 08:09:43 GMT

Jerry, can you please tell me exactly which privileges I have to grant to my user so the task will run in a "whether user is logged in or not" mode?

Re: Run cmd file in Windows task scheduler in Qlikview server

jerrysvensson — Wed, 14 May 2014 08:43:02 GMT

Unfortunately I can't tell you. Our IT fixed this. Could have been the two Local policies above, but I am not sure.

Add them, make sure you logoff and on after the change has been made.

Re: Run cmd file in Windows task scheduler in Qlikview server

luciancotea — Wed, 14 May 2014 08:56:02 GMT

Hi Linoy,

I struggled with the problem, seems that task scheduler has it's own problems.

My solution was to use another scheduler (JIT from GibinSoft). You also need to run it under an account with proper privileges.

Lucian

Re: Re: Run cmd file in Windows task scheduler in Qlikview server

vikasmahajan — Wed, 14 May 2014 09:26:16 GMT

PFA Documents .

Vikas