Forum Discussion
Advocate IIData Factory Runtime Busy Error (9518) in Copy Data Activity, but Same Connection Works in Dataflow
Hi Team,
Thank you for your guidance.
We reviewed the Integration Runtime logs and found repeated errors:
"Not enough resources to start a new worker. Current workers count: 0."
After investigating the gateway server, we found that several applications were running and consuming server resources. We stopped the unnecessary applications and retried the connection test.
After freeing up server resources, the Copy Data Activity and connection test started working successfully.
This confirms that the issue was related to insufficient resources on the server hosting the On-Premises Data Gateway / Integration Runtime, preventing worker processes from being created.
Thank you for helping us identify the root cause. 😊😊😘😘
Solution SageHello @NuwanAthukorala !
To narrow down the root of cause, can you please share these details?
- Is the source on-premises or cloud?
- If its on-premises, are you using an on-premises data gateway, and is it single node or gateway cluster.
- Does this error happen for this Copy data activity, or for every new/simple copy data activity?
- What does the Fabric capacity metrics show at the exact failure time?
- Does the Copy activity work if you moved to another workspace/capacity?
- Has this worked before and suddenly started failing?
- If it worked before, check recent changes: gateway update, capacity changes, credential update, or something you can think of have changed.
My first isolation test would be: create a blank pipleline, use the same connection, read 1 row only and run it.
Also check if these solved posts are any of help:
https://community.fabric.microsoft.com/t5/Pipelines/The-Data-Factory-runtime-is-busy-now-Please-retr...
https://community.fabric.microsoft.com/t5/Data-Engineering/On-premises-gateway-issue/m-p/4717842
https://community.fabric.microsoft.com/t5/Data-Engineering/Error-Code-9518/m-p/4668199
Solutions Architect - Microsoft Fabric Specialist Parchitect
💡Did my response help you? Clicking Kudos is a small gesture that goes a long way, it encourages contributors and helps the community thrive!
✔️Did I answer your question? Please mark my post as a Solution, it helps others find the answer faster.