Forum Discussion
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
- smudassir3 years agoEmployee
is the same query working outside snaplogic in any db client tool?
- gordon_ash3 years agoNew Contributor
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 :
- smudassir3 years agoEmployee
Can you share your account settings pls? Which driver jar are you using?