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
smudassir's avatar
smudassir
Employee
3 years ago

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

gordon_ash's avatar
gordon_ash
New Contributor
3 years ago

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 :

  • smudassir's avatar
    smudassir
    Employee
    3 years ago

    Can you share your account settings pls? Which driver jar are you using?

    • gordon_ash's avatar
      gordon_ash
      New Contributor
      3 years ago

      Ok, here is the account

      and here is the jar file

      • 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.