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
bojanvelevski's avatar
bojanvelevski
Valued Contributor
3 years ago

The problem might be, and probably is, in the downstream snaps.

Try and isolate the snap to properly test and confirm if the problem is really in the SQL Server Execute.

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?