1 Reply Latest reply: Aug 10, 2011 12:33 PM by Steven Blundell RSS

    Problem loading data from Stored Procedure after adding column

      Hi,

       

      I have an SQL Stored Procedure and it was working fine until I recently added a new field into the dataset which is returned, now Qlikview fails to load the data and gives no specific error message, just

      OLEDB read failed

      SQL EXEC dbo.GetTMSessionAnalysisQV

       

      If I amend my SQL to exclude the new field it works fine again. The SQL Stored Procedure executes fine outside of Qlikview as I've tested it.

       

      Does Qlikview expect the stored procedure to return the same schema or something? Where might I be going wrong?

       

      Many thanks,