0 Replies Latest reply: Apr 17, 2015 7:17 PM by Greg Kung RSS

    Problem running stored procedure in Qlikview load script

      I ran the following script to execute a stored procedure from MS SQL Server

       

      [Inspection]:

      LOAD *;

      sql execute [bims].[xinspectionreport].[usp_Report_GetSummaryReport] @MonthFrom = '01/2015', @MonthTo = '12/2020';

       

      After the script was run, the table was not created, and there were no error messages.  Below is the log file messages:

       

      4/16/2015 9:21:10 PM: 0588  OLEDB CONNECT*Provider*

      4/16/2015 9:21:11 PM: 0590  [LenderInsp]:

      4/16/2015 9:21:11 PM: 0591  LOAD *

      4/16/2015 9:21:11 PM: 0592  sql execute [bims].[xinspectionreport].[usp_Report_GetSummaryReport] @MonthFrom = '01/2015', @MonthTo = '12/2020'

      4/16/2015 9:21:15 PM: 0718  OLEDB CONNECT*Provider*

       

      Any help in troubleshooting this is greatly appreciated?