Forum Discussion

NizarELMOKHTARI's avatar
NizarELMOKHTARI
Frequent Visitor
5 months ago

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...
Mirrored Azure SQL Database
  • Lodha_Jaydeep's avatar
    Lodha_Jaydeep
    Icon for Solution Sage rankSolution Sage
    4 months ago

    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?

     

    • NizarELMOKHTARI's avatar
      NizarELMOKHTARI
      Frequent Visitor
      4 months ago

      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 :

       

      • Lodha_Jaydeep's avatar
        Lodha_Jaydeep
        Icon for Solution Sage rankSolution Sage
        4 months ago

        On the 1st option have you used the below option please conform?

        In the second step it's asking for the server and db name and it will create connection automatically.

         

        For me it's working as expected and I can see my on-prem table also from the My SQL server.