Forum Discussion

Fischerd's avatar
Fischerd
New Contributor
7 years ago

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 succe...
sqlserver
gordon_ash's avatar
gordon_ash
New Contributor
3 years ago

Hi [bojanvelevski],thanks, you are right, I disabled the snaps after the error pipeline (PE3) and the SQL Execute runs no problem; so there must be something wrong with the snaps further down the stream, I can investigate those.
Thanks very much.

smudassir's avatar
smudassir
Employee
3 years ago

Thanks, I was not able to replicate the issue just with the SQL Server snaps in the pipeline. Can you share your pipeline here to atleast show the downstream snaps after the Sql Server snap?