Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue on Qlikview document reload from SQL Job

Hi All

We are facing issue on Qlikview document reload

We are trying to automate the reload procedure of QV through command file using SSIS Job.

The steps involved are:

1.       Create a QV file (.qvw

2.       Create a batch file (.bat) which has the following command in it: "c:\program files\qlikview\qv.exe" /R "D:\Reporting\QlickView\Dashboard.qvw"

3.       Create an SQL Agent job which will call this batch file.

While trying to run the job, the same is getting hanged.

The bat file has been executed successfully when we ran from command prompt

We are using SQL Agent jobs since we have dependency on SSIS packages; only after the SSIS packages executes, the QV file should reload.

Is there any problem in the steps which we are performing?

Also, we would like to know if there is any other way of performing the reload scheduling.

Note : Proxy User QLIKSQLBT has been created in SQL(with Admin privilege) and used for job execution

Please find the attached SQL JOB Steps and Error  screenshots

1 Reply
Peter_Cammaert
Partner - Champion III
Partner - Champion III

The SQL Agent account that is launching the CMD file probably has no QlikView license assigned. QV Desktop won't load/run the script because it will only run as a PE version.

Do you have a QlikView server? Then schedule the reload in QVS/QDS as a task to be triggered by an "external event". Use the EDX command line tool QMSEDX Enhanced to let the SQL Agent trigger this task remotely on the QlikView server. No QlikView license necessary.