Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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?