<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Issue on Qlikview document reload from SQL Job in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Issue-on-Qlikview-document-reload-from-SQL-Job/m-p/811656#M1296909</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; Hi All&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;We are facing issue on Qlikview document reload&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;We are trying to automate the reload procedure of QV through command file using SSIS Job.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;The steps involved are:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoListParagraph" style="margin: 0in 0in 10pt 0.5in; text-indent: -0.25in; mso-list: l0 level1 lfo1;"&gt;&lt;SPAN style="mso-bidi-font-family: Calibri; mso-list: Ignore; color: #1f497d; mso-fareast-font-family: Calibri;"&gt;&lt;SPAN style="font-family: Calibri; font-size: 12pt;"&gt;1.&lt;/SPAN&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Create a QV file (.qvw&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="mso-bidi-font-family: Calibri; mso-list: Ignore; color: #1f497d; mso-fareast-font-family: Calibri;"&gt;&lt;SPAN style="font-family: Calibri; font-size: 12pt;"&gt;2.&lt;/SPAN&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Create a batch file (.bat) which has the following command in it: "c:\program files\qlikview\qv.exe" /R "D:\Reporting\QlickView\Dashboard.qvw"&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoListParagraph" style="margin: 0in 0in 10pt 0.5in; text-indent: -0.25in; mso-list: l0 level1 lfo1;"&gt;&lt;SPAN style="mso-bidi-font-family: Calibri; mso-list: Ignore; color: #1f497d; mso-fareast-font-family: Calibri;"&gt;&lt;SPAN style="font-family: Calibri; font-size: 12pt;"&gt;3.&lt;/SPAN&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Create an SQL Agent job which will call this batch file.&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;While trying to run the job, the same is getting hanged. &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;The bat file has been executed successfully when we ran from command prompt &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;We are using SQL Agent jobs since we have dependency on SSIS packages; only after the SSIS packages executes, the QV file should reload.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Is there any problem in the steps which we are performing? &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Also, we would like to know if there is any other way of performing the reload scheduling.&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Note : Proxy User QLIKSQLBT has been created in SQL(with Admin privilege) and used for job execution&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Please find the attached SQL JOB Steps and Error&amp;nbsp; screenshots &lt;SPAN style="mso-spacerun: yes;"&gt; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 26 Jan 2026 18:19:17 GMT</pubDate>
    <dc:creator />
    <dc:date>2026-01-26T18:19:17Z</dc:date>
    <item>
      <title>Issue on Qlikview document reload from SQL Job</title>
      <link>https://community.qlik.com/t5/QlikView/Issue-on-Qlikview-document-reload-from-SQL-Job/m-p/811656#M1296909</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; Hi All&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;We are facing issue on Qlikview document reload&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;We are trying to automate the reload procedure of QV through command file using SSIS Job.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;The steps involved are:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoListParagraph" style="margin: 0in 0in 10pt 0.5in; text-indent: -0.25in; mso-list: l0 level1 lfo1;"&gt;&lt;SPAN style="mso-bidi-font-family: Calibri; mso-list: Ignore; color: #1f497d; mso-fareast-font-family: Calibri;"&gt;&lt;SPAN style="font-family: Calibri; font-size: 12pt;"&gt;1.&lt;/SPAN&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Create a QV file (.qvw&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="mso-bidi-font-family: Calibri; mso-list: Ignore; color: #1f497d; mso-fareast-font-family: Calibri;"&gt;&lt;SPAN style="font-family: Calibri; font-size: 12pt;"&gt;2.&lt;/SPAN&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Create a batch file (.bat) which has the following command in it: "c:\program files\qlikview\qv.exe" /R "D:\Reporting\QlickView\Dashboard.qvw"&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoListParagraph" style="margin: 0in 0in 10pt 0.5in; text-indent: -0.25in; mso-list: l0 level1 lfo1;"&gt;&lt;SPAN style="mso-bidi-font-family: Calibri; mso-list: Ignore; color: #1f497d; mso-fareast-font-family: Calibri;"&gt;&lt;SPAN style="font-family: Calibri; font-size: 12pt;"&gt;3.&lt;/SPAN&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Create an SQL Agent job which will call this batch file.&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;While trying to run the job, the same is getting hanged. &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;The bat file has been executed successfully when we ran from command prompt &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;We are using SQL Agent jobs since we have dependency on SSIS packages; only after the SSIS packages executes, the QV file should reload.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Is there any problem in the steps which we are performing? &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Also, we would like to know if there is any other way of performing the reload scheduling.&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Note : Proxy User QLIKSQLBT has been created in SQL(with Admin privilege) and used for job execution&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt;Please find the attached SQL JOB Steps and Error&amp;nbsp; screenshots &lt;SPAN style="mso-spacerun: yes;"&gt; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P class="MsoNormal" style="margin: 0in 0in 10pt;"&gt;&lt;SPAN style="color: #1f497d; font-size: 12pt; font-family: Calibri;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Jan 2026 18:19:17 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Issue-on-Qlikview-document-reload-from-SQL-Job/m-p/811656#M1296909</guid>
      <dc:creator />
      <dc:date>2026-01-26T18:19:17Z</dc:date>
    </item>
    <item>
      <title>Re: Issue on Qlikview document reload from SQL Job</title>
      <link>https://community.qlik.com/t5/QlikView/Issue-on-Qlikview-document-reload-from-SQL-Job/m-p/811657#M1296911</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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 &lt;A href="https://community.qlik.com/docs/DOC-5111"&gt;QMSEDX Enhanced&lt;/A&gt; to let the SQL Agent trigger this task remotely on the QlikView server. No QlikView license necessary.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 16 Feb 2015 10:47:06 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Issue-on-Qlikview-document-reload-from-SQL-Job/m-p/811657#M1296911</guid>
      <dc:creator>Peter_Cammaert</dc:creator>
      <dc:date>2015-02-16T10:47:06Z</dc:date>
    </item>
  </channel>
</rss>

