Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have two servers,
SQLSvr - database server (Admin Account - Domain\user1)
QlikSvr - Qlikview server (Account - Domain\user2)
Domain\user2 has been added to the list of logins on the database server, also I have created proxy for this account on sql server agent, so that I can run the package with this account from database server to reload my qlikview document which is on the Qlikview server.
Then, I have created a package, included Execute Process Task, I configured it as follows
1) Executable: \\QlikSvr\E$\Program Files\QV.exe
2) Arguments: \\QlikSvr\E$\ReloadMasterQVDs.qvw
Now, I have created a sql agent job and changed runas to Domain\user2 to execute the package.
When I execute the sql job it's running continuously without any effect.
Can someone tell me what the problem could be?
Thanks,
Jyotsna
Hi,
Create a batch file and put the commands in that file, and execute this batch file in SSIS. Please check below link for Commands
Please find attached file for link.
Regards,
Jagan.
Hi,
Thanks for the reply.
However, I don't feel the problem is with the command, but with the way sql server agent impersonating the "run as" account.
I can say this as I have already tried using a batch file and got the same issue.
Thanks,
Jyotsna
Did disable the "Keep Progress Open after Reload" option? If no, then the progress window will keep opening and the SQL task will assume it is still running.
It's already disabled.
Below screenshot
Hi,
When I try to run from the command prompt of my sql machine, it generates the log file and I could see that the load is starting and is loading all the qvds but finally it comes up with the error as in the below screenshot.
Thanks,
Jyotsna
HI,
Reload manually using Qlikview Desktop and check whether it is reloading successfully.
Regards,
Jagan.
Yes, it reloads successfully from the qlikview desktop and also by running the same batch file from the Qlikview server.
The problem is when I try to reload it from the database server.
Thanks,
Jyotsna
You need more arguments QlikView Desktop client command line
I think /R should work into your case.