Forum Discussion
MySQL Connection Issue via Gateway in Fabric Copy Job
Hi everyone,
I'm facing a connection issue when running a Copy Job in Microsoft Fabric using a MySQL source via On-premises Data Gateway.
Error:
"The integration runtime is busy now. Please retry the operation later."
Activity ID: c433b05a-b0a2-434f-9c27-f7b2d858da50
Context:
- Source: MySQL (on-prem)
- Connection: Data Gateway
- Issue occurs during connection/test
Checked:
- Gateway is online
- Credentials are correct
- MySQL is reachable from the gateway machine
- I can successfully connect to the same MySQL source using the same gateway from Power BI
Has anyone experienced this issue or knows how to resolve it?
Thanks in advance!
18 Replies
Hi NizarELMOKHTARI,
Based on the error message "The integration runtime is busy now", it usually means the gateway runtime is currently occupied and not able to accept a new request from the Fabric Copy Job.
Since the connection is working from Power BI using the same gateway, this looks more related to runtime availability or load on the gateway when Fabric is trying to connect. Sometimes this can happen if the gateway is handling other operations or if there are temporary busy sessions.
You may try restarting the On-premises Data Gateway service once and then retry the copy job. If it still continues, please let us know whether this happens only for this MySQL source or for other connections as well.
Regards,
Community Support Team.Hi NizarELMOKHTARI,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Community Support Team.Hi v-hjannapu
Thank you for your response.
I haven’t had the chance yet to restart the On-premises Data Gateway, but I will try that and keep you updated.
In the meantime, I would like to share a few additional details that might help:
- This gateway has been recently created and this is one of its first uses
- The issue seems to occur only with this MySQL source
- I have another gateway connected to a SQL Server source, and it is working without any issue
- In terms of infrastructure:
- SQL Server is hosted on a virtual machine
- MySQL is hosted on a local (on-premises) server
Given that Power BI can connect successfully to the same MySQL source via this gateway, the issue seems specific to Fabric Copy Job execution.
Please let me know if these details help or if you need any additional information.
Thanks again for your support.
Best regards,
Uninstall the MySQL driver and install version 8.0.28
Hello, i have the same issue, i have installe 8.0.28, restarted my gateway and machine multiple times and it still doesn't work. For sql connections i don't have this kind of issue and i don't really understand what may be the problem. i did even selections with limit of one but still.
Error: The integration runtime is busy now. Please retry the operation later. Activity ID: f79e4057-676b-4db0-bd6d-4315a2cac7aaHi NizarELMOKHTARI ,
Could you please confirm if the issue is resolved? If you are still facing any errors, let us know so we can investigate further. Sharing your outcome helps provide clarity for the rest of the Fabric community.
Thanks!
Hello v-hjannapu and Lodha_Jaydeep , I'm still facing an intergration runtime error regarding the issue.
Regards,
Hi NizarELMOKHTARI,
Are you using My SQL Source as a source or destination? Also, could you confrom you are running Copy Job/Copy Data Acticity?Hi Lodha_Jaydeep
I'm using MySQL Source as a source of my data, via an on-premises gateway, and yes the copy job activity fails before loading the data :
