locked
Copy Activity from Azure SQL to Azure Document DB failing RRS feed

  • Question

  • I am getting the following error for my copy activity from an Azure Sql Instance to a Document DB collection:

    Copy activity encountered an unknown server error: Code: 0 ; Message: 'Type=Microsoft.Azure.Documents.DocumentClientException,Message=The input authorization token can't serve the request. Please check that the expected payload is built as per the protocol, and check the key being used. Server used the following payload to sign:

    I have double checked the key is correct and is a read/write key in the linked service.  It also reads out of that same linked service earlier in the pipeline without any issue.  I'm not really sure what else to check besides the key.

    Thanks for any assistance.

    Dan

    Wednesday, November 25, 2015 4:34 PM

All replies

  • Did you get resolution to this?  I had a pipeline that was working last week, I went to redeploy the same pipeline in a different factory and getting this error now.  

    Marcus Crast BI and Database Specialist EMAIL: m3crast@gmail.com LINKEDIN: http://www.linkedin.com/in/marcuscrast

    Tuesday, January 12, 2016 4:55 AM
  • Hi Dan,

    Could you provide me the runId of this fail copy activity?

    Thanks,

    Eva

    Wednesday, January 13, 2016 2:10 PM
  • The theory is that Datafactory isn't playing nice with DocDb's located in regions other than that of the Datafactory instance.  Maybe signing requests with a bad timestamp.  I haven't tested this lately.  So, I'm not sure if it has been resolved.
    Tuesday, January 26, 2016 2:37 PM
  • Previously this problem only seems to be for writing to docdb from datafactory. Now, reads appear to be giving the same problem.

    Here is a sample runId from just today:
    6863bd49-bb37-48bd-9b3b-97afb5336606_635895990000000000_635895999000000000_AzureSQLGrants-15

    Here is the error message:

    Copy activity encountered an unknown server error: Code: 0 ; Message: 'Type=Microsoft.Azure.Documents.DocumentClientException,Message=The input authorization token can't serve the request. Please check that the expected payload is built as per the protocol, and check the key being used. Server used the following payload to sign: 'get thu, 28 jan 2016 17:45:13 gmt ' ActivityId: 78079707-1171-4352-bfa3-2fb2bed793f2,Source=Microsoft.Azure.Documents.Client,'.

    Thanks for your help,

    Dan

    Thursday, January 28, 2016 5:51 PM
  • Hi Marcus,

    You mention you redeploy the same pipeline to another factory, may I ask how did you do this? Are you copying the json file from ADF editor and deploy it directly to the other factory?

    When you are viewing a DOCDB link service, for security concern, ADF will neither show or associate the accountkey to this linkedservice, if you don't modify the account key manually, the account key you're giving to ADF will be “**********” which result in unauthorized error.

    {
        "name": "DocumentDbLinkedService",
        "properties": {
            "type": "DocumentDb",
            "typeProperties": {
                "connectionString": "accountendpoint=https://mydocumentdb.documents.azure.com:443/;accountkey=**********;database=mydocumentdb"
            }
        }
    }

    Thanks,

    Eva

    Thursday, March 10, 2016 3:26 AM
  • Hi Dan,

    Sorry for reply late, are you still suffering from this issue? If yes, please provide me with a recent RunId and associate time range, I'll do the investigation for you.

    Thanks,

    Eva

    Thursday, March 10, 2016 3:28 AM