topic Re: Daily batch job to create excel sheet after reload data in QlikView

Daily batch job to create excel sheet after reload data

Wed, 20 Jun 2012 16:10:12 GMT

Hi guys,

I apologize for my english....

I've created this batch

"c:\Program Files\QlikView\QV.exe" /l C:\Qlikview\InfoBlu\Passenger.qvw

After reload, macro export data and create an excel file

If I launch bat file while I was logged in server it works...
If I'm not logged in and the scheduler will launch the bat, it doesn't works.

When I try to log in again, I see a popup that says "view the message", I click on and have this error ....
"your installation of qlikview has exceeded the maximum number of document recoveries allowed for a personal edition license"

I'm not able to assign license, this screenshoot is read only........please help me.....

Re: Daily batch job to create excel sheet after reload data

Anonymous — Thu, 21 Jun 2012 01:47:50 GMT

My guess is that your QV doesn't have desktop license. When you login as yourself, you apparently use "leased license" - you lease it from QV server when opening any server-based application, at least onece a month. Qlikview services apparently are run by a differnt username, not yourself, and this user doesn't have leased license.
The most relaible way is to by QV desktop license. Otherwise, find out the QV services user, loging as this user, open IE, open access point, open any QV file. After this this user has leased license for 30 days, and reload will work.
Or maybe it is enough to run batch under your name - give it a try...

Regards,
Michael

Re: Daily batch job to create excel sheet after reload data

Thu, 21 Jun 2012 08:12:30 GMT

Thank you so much Michael!

The batch now run under by name, so we used only 1 license

Kindly regards

Max