Copying data from premises MySQL to SQL data warehouse getting below error. RRS feed

  • Question

  • Below is the error which we are facing while transferring data from on premise MySQL database to Azure SQL DW using Azure Data Factory:

    "Copy activity encountered a user error at Source side: GatewayNodeName=********,ErrorCode=UserErrorFailedMashupOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message='Type=Microsoft.Data.Mashup.MashupValueException,Message=MySQL: Fatal error encountered during data read.,Source=Microsoft.MashupEngine,',Source=,'."

    Other tables from same database are not giving this error, and the user access problems are not there as we are able to access the table data at MySQL level with the same user and password. Please let me know what might be causing this issue or the work around.

    Thursday, August 17, 2017 10:18 AM