none
USQL Activity -Blob storage

    Question

  • Hi Team

    I am trying to run a U-SQL activity , where the U-SQL script is being stored in blob storage and the input and output for the U-SQL script will be in the data lake.

    When i try to run the script , I am getting the following error,"The decryptor is null, please check the compute type and make sure linked service run on right compute".

    Please let me know what needs to be done in this case.

    Pipeline Run ID: e08fcad4-9795-4eb0-9f88-482916449677

    Thanks

    Shankar


    shankar


    Tuesday, August 21, 2018 7:23 AM

All replies

  • Seems something in your pipeline/linked service payload is not right. Could you check this doc and to see is there anything wrong in your pipeline?  

    If this doc doesn't help, could you share your linked service/ pipeline payload? You could hide the credentials.


    Tuesday, August 21, 2018 12:20 PM
  • Thanks for your reply and suggestion Fang.

    I will let you know if any further help is needed.

    Thanks

    Shankar


    shankar

    Wednesday, August 22, 2018 5:01 AM
  • I am receiving the same error message with a U-SQL activity running against ADLS gen 1. I have taken a look at the document mentioned above, but really did not see anything missing. Any help available would be greatly appreciated. Below is the linked service payload I am using with any credentials hidden. I have compared the payload to the linked service payload that is working in another subscription and find no major differences other than the obvious credentials. I am sure it is going to be something I missed during my initial setup, but thus far I am unable to see it.

    {
        "name": "ADLA_QA",
        "type": "Microsoft.DataFactory/factories/linkedservices",
        "properties": {
            "type": "AzureDataLakeAnalytics",
            "typeProperties": {
                "accountName": "ncaadlasbox01",
                "servicePrincipalId": "<service principal>",
                "tenant": "<tenant>",
                "subscriptionId": "<subscription Id>",
                "resourceGroupName": "projectvision",
                "encryptedCredential": "<encryptedCredential>"
            }
        }
    }

    Wednesday, November 14, 2018 5:59 PM
  • Have you tried "test connection" in ADF v2 portal? Did it pass?
    Friday, November 16, 2018 5:24 AM