SQL Server Stored Procedure Snap hangs when returning data

[Fischerd]

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

[dmiller]

I believe our Support team received this issue and are investigating.

[gordon_ash]

Hi,
Did you ever get a solution for this, I am running into a similar issue where a SQL Execute snap that is using a SQL select top 300 * from tbl statement rather than a stored procedure;it just hangs at 1024 documents. In the SQL Server activity (sp_who2) there is a cursor event (FETCH API_CURSOR0000000000000FD7) that appears to just hang. The pipeline will not go any further - even if I use a different select statement it still hangs at that snap.
Any information or insight here would be very helpful,

Thank you
Gordon

[smudassir]

is the same query working outside snaplogic in any db client tool?

[gordon_ash]

Hi Smudassir, thank you for responding,
Yes, the query is fine, it only pulls a few hundred records from a simple table. Even when I select top 1 * it still has the same issue.

The code in the SQL server - Execute 3 snap is :