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
is the same query working outside snaplogic in any db client tool?
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 :
Can you share your account settings pls? Which driver jar are you using?
Ok, here is the account
and here is the jar file
