Executing Stored Proc in Datamapper gives "An error occurred while executing the custom SQL query"

OL Connect Professional Designer
1

I am trying to create a data mapper using a stored procedure in SQL Server. I get the error “An error occurred while executing the custom SQL query”.

My stored procedure first updates the records in a table depending on the parameters passed, and then returns the updated result set with a Select query in the end.

It works when I comment out the part that updates the table.

Could someone help.

Thanks,

Sanjeev

2

Might be a setting on SQL server: your update may not have been completely committed to disk when your Query ran. I’m not an expert on SQL server so I can’t say exactly what setting to look for, but I would advise you to try the exact same procedure using the Workflow Database Query task and see how that turns out.