1 Reply Latest reply: Feb 16, 2015 5:47 AM by Peter Cammaert RSS

    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

       

       

       

        • Re: Issue on Qlikview document reload from SQL Job
          Peter Cammaert

          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.