<?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 Problem running stored procedure in Qlikview load script in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Problem-running-stored-procedure-in-Qlikview-load-script/m-p/860451#M658717</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I ran the following script to execute a stored procedure from MS SQL Server&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;[Inspection]:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;LOAD *;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;sql execute [bims].[xinspectionreport].[usp_Report_GetSummaryReport] @MonthFrom = '01/2015', @MonthTo = '12/2020';&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;After the script was run, the table was not created, and there were no error messages.&amp;nbsp; Below is the log file messages:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;4/16/2015 9:21:10 PM: 0588&amp;nbsp; OLEDB CONNECT*Provider*&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;4/16/2015 9:21:11 PM: 0590&amp;nbsp; [LenderInsp]:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;4/16/2015 9:21:11 PM: 0591&amp;nbsp; LOAD *&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;4/16/2015 9:21:11 PM: 0592&amp;nbsp; sql execute [bims].[xinspectionreport].[usp_Report_GetSummaryReport] @MonthFrom = '01/2015', @MonthTo = '12/2020'&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;4/16/2015 9:21:15 PM: 0718&amp;nbsp; OLEDB CONNECT*Provider*&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any help in troubleshooting this is greatly appreciated?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 17 Apr 2015 23:17:47 GMT</pubDate>
    <dc:creator />
    <dc:date>2015-04-17T23:17:47Z</dc:date>
    <item>
      <title>Problem running stored procedure in Qlikview load script</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-running-stored-procedure-in-Qlikview-load-script/m-p/860451#M658717</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I ran the following script to execute a stored procedure from MS SQL Server&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;[Inspection]:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;LOAD *;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;sql execute [bims].[xinspectionreport].[usp_Report_GetSummaryReport] @MonthFrom = '01/2015', @MonthTo = '12/2020';&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;After the script was run, the table was not created, and there were no error messages.&amp;nbsp; Below is the log file messages:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;4/16/2015 9:21:10 PM: 0588&amp;nbsp; OLEDB CONNECT*Provider*&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;4/16/2015 9:21:11 PM: 0590&amp;nbsp; [LenderInsp]:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;4/16/2015 9:21:11 PM: 0591&amp;nbsp; LOAD *&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;4/16/2015 9:21:11 PM: 0592&amp;nbsp; sql execute [bims].[xinspectionreport].[usp_Report_GetSummaryReport] @MonthFrom = '01/2015', @MonthTo = '12/2020'&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff;"&gt;4/16/2015 9:21:15 PM: 0718&amp;nbsp; OLEDB CONNECT*Provider*&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any help in troubleshooting this is greatly appreciated?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 17 Apr 2015 23:17:47 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-running-stored-procedure-in-Qlikview-load-script/m-p/860451#M658717</guid>
      <dc:creator />
      <dc:date>2015-04-17T23:17:47Z</dc:date>
    </item>
  </channel>
</rss>

