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

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