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 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,

1 Solution

Accepted Solutions
Not applicable

Problem loading data from Stored Procedure after adding column

Hi,

I have figured this one out so posting it in case anyone else hits the same issue. I'd managed to not name the new calculated field in SQL Stored Procedure and Qlikview couldnt handle that, after finding it I have re-loaded the script and its worked fine.

1 Reply
Not applicable

Problem loading data from Stored Procedure after adding column

Hi,

I have figured this one out so posting it in case anyone else hits the same issue. I'd managed to not name the new calculated field in SQL Stored Procedure and Qlikview couldnt handle that, after finding it I have re-loaded the script and its worked fine.

Community Browser