This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm experiencing an almost immediate query timeout on one of my Connect In-DB queries to a Microsoft SQL server using OLE DB driver. I have three of these objects all using the same connection. Two of them run in a second or two just fine. The third runs for maybe 10 seconds, then times out. It is a large query, but the timeout on the server end is set to several hours (I can run a nearly 6 hour query in SQL Server Management Studio just fine). Does anyone have any suggestions as to why this might be happening? Thanks.
Thanks for the suggestion, but I've already tried isolating each query. The first two run perfectly fine still, but the third query times out even if completely isolated. That is, I created a workflow with just that query and a Browse In-DB and get the same timeout in about 10 seconds still.
Weirdly, if I run the exact same query as a normal Input Data, it takes a couple minutes, but completes just fine. I'm trying to work In-DB as much as possible since it is quite a large query, especially when I scale up to the full target data set rather than just this (relatively) small sample.
Not sure if this will help, but I had the exact same issue. The cause was that I had a Data Stream Out tool with input from one of the other inDB tools, but the Data Stream Out was NOT output-connected to anything else. I deleted the errant Data Stream out tool and it resolved the immediate query timeout.