Fischerd
7 years agoNew Contributor
SQL Server Stored Procedure Snap hangs when returning data
Hello,
I’m working with a Stored Procedure that has no input variables and returns about 4800 rows of data. When I build out my pipeline and validate, the procedure returns the first 50 rows successfully (as expected). However, when I go for an actual execution the pipeline hangs on that particular snap.
Given that my pipeline works when validating, I don’t think there is a connectivity issue. I don’t know if there is some action I need to take in order to handle larger data sets?
Any information or insight here would be very helpful
Thank you
Dan
Edit: Here is a screen shot of the pipeline execution in the dashboard. It will hang at exactly 1024 docs each time