topic Re: Reload Qlikview document from SSIS in QlikView

Reload Qlikview document from SSIS

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Reload Qlikview document from SSIS

jagan — Fri, 09 May 2014 05:52:27 GMT

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.

Re: Reload Qlikview document from SSIS

Fri, 09 May 2014 06:00:17 GMT

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

Re: Reload Qlikview document from SSIS

Fri, 09 May 2014 06:09:22 GMT

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.

Re: Reload Qlikview document from SSIS

Fri, 09 May 2014 06:20:04 GMT

It's already disabled.

Below screenshot

Re: Reload Qlikview document from SSIS

Mon, 12 May 2014 00:08:15 GMT

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

Re: Reload Qlikview document from SSIS

jagan — Mon, 12 May 2014 01:07:31 GMT

HI,

Reload manually using Qlikview Desktop and check whether it is reloading successfully.

Regards,

Jagan.

Re: Reload Qlikview document from SSIS

Mon, 12 May 2014 01:09:32 GMT

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

Re: Reload Qlikview document from SSIS

Clever_Anjos — Mon, 12 May 2014 01:09:46 GMT

You need more arguments QlikView Desktop client command line

I think /R should work into your case.