locked
ADF Pipeline Copy RRS feed

  • Question

  • Hi,

    I am trying to copy data from on premise HDFS file to Azure SQLDW. While running the pipeline getting the below error.

    "Copy activity encountered a user error: ErrorCode=UserErrorPropertyInPayloadIsInvalid,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The property 'Url' in the payload is invalid.,Source=Microsoft.DataTransfer.ClientLibrary,'."

    Please let me know if anything I am missing.

    Thanks,

    Peer Md.

    Wednesday, November 9, 2016 11:09 AM

All replies

  • Hi Peer,

    I guess you set a invalid Url property in HDFS linked service. Please don't forget the suffix 'webhdfs/v1/', and it should looks like:

        "url" : "http://<machine>:50070/webhdfs/v1/"

    For more information, you can refer to the following page to figure out how to configure a on-primes HDFS linked service.

        https://azure.microsoft.com/en-us/documentation/articles/data-factory-hdfs-connector/

    Please feel free to ping me if your issue still remains. Thanks!

    Anqing

    Wednesday, November 9, 2016 4:29 PM