Forum Discussion
Copy Data Activity Queue - No data transfer
Please see attached screenshot.
I have run into an error where a series of pipelines which worked last week, all get stuck in this 'queued' state. I cna do preview and it brings data back and I can see that the query hits the sql server but I cannot find a way to troubleshoot the error any further.
The issue was caused by an application called Airlock, which monitors and blocks sucpicous applications. When using the preview function the application (Airlock) did not trigger a warning but once you try adn processing xk records it would.
Soultion was to put an exception of the gateway program folder.
3 Replies
Hi Beckett401 ,
In order to understand your specific data copy scenario, could you please share some more details about your copy data activity. Could you clarify if you are trying to connect on-prem SQL server or cloud hosted SQL server?
If you are using on-prem gateway ensure that it still active.
Try installing the latest version: Download On-premises data gateway from Official Microsoft Download Center
Check out these previous posts, if they match your issue you can resolve your pipeline
Solved: The copy from sql server on premise has been relea... - Microsoft Fabric Community
Fabric Data Pipeline - Copy activity stays in queu... - Microsoft Fabric Community
Did I answer your question? Mark my post as a solution, this will help others!If my response(s) assisted you in any way, don't forget to give "Kudos"
Thanks and RegardsThank you for the support. I had already tried the above and it turned out to to be network/server security issue
The issue was caused by an application called Airlock, which monitors and blocks sucpicous applications. When using the preview function the application (Airlock) did not trigger a warning but once you try adn processing xk records it would.
Soultion was to put an exception of the gateway program folder.
