Data Stream In - Temp table SQL Server

[Kieran]

I'm trying to upload records into a temp table on a SQL Server. The connection for the temp table has been used previously in the workflow but I don't seem be able to "re-use" the same connection. If I create a new connection for the Data Stream In, it works fine. But when using the same connection that was used previously in the same workflow, I get this error:

[SeanAdams]

Great stuff Kieran - can you pop the alteryx flow onto this thread, along with a simple table-def and I can then replicate this on my home SQL to see if we can isolate the issue that you're facing?

[Kieran · Accepted solution]

I think I might have figured out whats going on here when doing up a mock dataset/workflow for you. When I started testing it, surprisingly it worked. I ran a few more tests to figure out why it worked, and realised that the error is happened because the workflow isnt getting enough time to pull down all the records from the first connection, before trying to upload them to the second connection.

When I re-run the workflow and limit the sample to just a few records, it runs just fine! Dissappointing behaviour. But at least I know to account for it now.

Thanks for your help Sean...

[SeanAdams]

:) I'm very glad that you've been able to work through this and find the cause - that's fantastic.

Are you still stuck (in terms of this blocking you) - if so, happy to iterate with you to see if there's a different way to tackle, or would it make sense to mark this thread as closed / solved, and then we log a defect in the "Ideas" section with a script to replicate this.

Nice work in getting to the bottom of this Kieran!

Have a good week
Sean

[Kieran]

I'm happy to discuss in person with our rep from Alteryx - Shaan. He does a workshop with us every few weeks so I can bring it up there... thanks Sean