Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

0 Replies