none
Import ARM failing on SQL LInked service

    Question

  • Deleted Pipeline ARM i am importing back. But it's keep on failing on SQL linked Service and another linked service dynamic has no issue. Any idea what's wrong. 
    it's Auto IR.

    OPERATION ID54BB3279474A8EF8
    TRACKING ID0b49dfb9-284b-42fe-87c6-c06ac9aa103d
    STATUSBadRequest
    PROVISIONING STATEFailed
    TIMESTAMP12/09/2018, 16:10:44
    DURATION4 seconds
    TYPEMicrosoft.DataFactory/factories/linkedServices
    RESOURCE ID/subscriptions/21d331e5-8cec-46ed-b6a3-9a3e7197ac5f/resourceGroups/Business-Intelligence-PRD/providers/Microsoft.DataFactory/factories/bi-prd-df-01/linkedServices/AzureSqlPRD
    STATUSMESSAGE{
      "error": {
        "code": "BadRequest",
        "message": "Failed to encrypt sub-resource payload {\r\n  \"Id\": \"/subscriptions/21d331e5-8cec-46ed-b6a3-9a3e7197ac5f/resourceGroups/Business-Intelligence-PRD/providers/Microsoft.DataFactory/factories/bi-prd-df-01/linkedservices/AzureSqlPRD\",\r\n  \"Name\": \"AzureSqlPRD\",\r\n  \"Properties\": {\r\n    \"annotations\": [],\r\n    \"type\": \"AzureSqlDatabase\",\r\n    \"typeProperties\": {\r\n      \"connectionString\": \"********************\"\r\n    }\r\n  }\r\n} and error is: Format of the initialization string does not conform to specification starting at index 0..",
        "target": "/subscriptions/21d331e5-8cec-46ed-b6a3-9a3e7197ac5f/resourceGroups/Business-Intelligence-PRD/providers/Microsoft.DataFactory/factories/bi-prd-df-01/linkedservices/AzureSqlPRD",
        "details": null
      }
    }
    RESOURCEbi-prd-df-01/AzureSqlPRD
    
    OMS json log
    
    {
        "authorization": {
            "action": "Microsoft.DataFactory/factories/linkedServices/write",
            "scope": "/subscriptions/21d331e5-8cec-46ed-b6a3-9a3e7197ac5f/resourcegroups/Business-Intelligence-PRD/providers/Microsoft.DataFactory/factories/bi-prd-df-01/linkedServices/AzureSqlPRD"
        },
        "caller": "xxx@xx.com",
        "channels": "Operation",
        "claims": {
            "aud": "https://management.core.windows.net/",
            "iss": "https://sts.windows.net/33f59820-886b-4e45-856e-d3b836b424f0/",
            "iat": "1536762148",
            "nbf": "1536762148",
            "exp": "1536766048",
            "http://schemas.microsoft.com/claims/authnclassreference": "1",
            "aio": "AWQAm/8IAAAA4C1PPqUKuGAtJUvQ7kuGSkq11v91kjk2QBxaqGJVGw/M5ISqyBa4ky8JtGM55YMImkyiaQdjzyXrIps9HYHOyLoI+LwO7ow54rMXkWc0p6QXG4XY1HcOw6WXpgvAbeAX",
            "altsecid": "5::10037FFEAC008E8F",
            "http://schemas.microsoft.com/claims/authnmethodsreferences": "pwd",
            "appid": "c44b4083-3bb0-49c1-b47d-974e53cbdf3c",
            "appidacr": "2",
            "e_exp": "262800",
            "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/emailaddress": "xxxx@xx.com",
            "http://schemas.microsoft.com/identity/claims/identityprovider": "https://sts.windows.net/bf95dca9-12cb-4f7d-9b65-a7bcc7649fed/",
            "ipaddr": "0.0.0.1",
            "name": "xxx",
            "http://schemas.microsoft.com/identity/claims/objectidentifier": "4a32ac53-22cb-4351-89c7-172aac117e8e",
            "puid": "10030000AC300CBE",
            "http://schemas.microsoft.com/identity/claims/scope": "user_impersonation",
            "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/nameidentifier": "4uQILMzSL9DlRphBwJAtUYxwlw2AbFN05qTNr-r0z_8",
            "http://schemas.microsoft.com/identity/claims/tenantid": "33f59820-886b-4e45-856e-d3b836b424f0",
            "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/name": "xxxx@xxe.com",
            "uti": "Ev80cbjP3UeR_O2J4l6PAA",
            "ver": "1.0"
        },
        "correlationId": "6e2eed0f-fc85-45ae-8e95-03962f098793",
        "description": "",
        "eventDataId": "10c45e98-6096-4c9a-9a70-f69803b214bd",
        "eventName": {
            "value": "EndRequest",
            "localizedValue": "End request"
        },
        "category": {
            "value": "Administrative",
            "localizedValue": "Administrative"
        },
        "eventTimestamp": "2018-09-12T15:10:44.1384079Z",
        "id": "/subscriptions/21d331e5-8cec-46ed-b6a3-9a3e7197ac5f/resourcegroups/Business-Intelligence-PRD/providers/Microsoft.DataFactory/factories/bi-prd-df-01/linkedServices/AzureSqlPRD/events/10c45e98-6096-4c9a-9a70-f69803b214bd/ticks/636723618441384079",
        "level": "Error",
        "operationId": "0b49dfb9-284b-42fe-87c6-c06ac9aa103d",
        "operationName": {
            "value": "Microsoft.DataFactory/factories/linkedServices/write",
            "localizedValue": "Create or Update any Linked Service."
        },
        "resourceGroupName": "Business-Intelligence-PRD",
        "resourceProviderName": {
            "value": "Microsoft.DataFactory",
            "localizedValue": "Microsoft.DataFactory"
        },
        "resourceType": {
            "value": "Microsoft.DataFactory/factories/linkedServices",
            "localizedValue": "Microsoft.DataFactory/factories/linkedServices"
        },
        "resourceId": "/subscriptions/21d331e5-8cec-46ed-b6a3-9a3e7197ac5f/resourcegroups/Business-Intelligence-PRD/providers/Microsoft.DataFactory/factories/bi-prd-df-01/linkedServices/AzureSqlPRD",
        "status": {
            "value": "Failed",
            "localizedValue": "Failed"
        },
        "subStatus": {
            "value": "",
            "localizedValue": ""
        },
        "submissionTimestamp": "2018-09-12T15:11:08.0934969Z",
        "subscriptionId": "21d331e5-8cec-46ed-b6a3-9a3e7197ac5f",
        "properties": {
            "statusCode": "BadRequest",
            "statusMessage": "{\"error\":{\"code\":\"BadRequest\",\"message\":\"Failed to encrypt sub-resource payload {\\r\\n  \\\"Id\\\": \\\"/subscriptions/21d331e5-8cec-46ed-b6a3-9a3e7197ac5f/resourceGroups/Business-Intelligence-PRD/providers/Microsoft.DataFactory/factories/bi-prd-df-01/linkedservices/AzureSqlPRD\\\",\\r\\n  \\\"Name\\\": \\\"AzureSqlPRD\\\",\\r\\n  \\\"Properties\\\": {\\r\\n    \\\"annotations\\\": [],\\r\\n    \\\"type\\\": \\\"AzureSqlDatabase\\\",\\r\\n    \\\"typeProperties\\\": {\\r\\n      \\\"connectionString\\\": \\\"********************\\\"\\r\\n    }\\r\\n  }\\r\\n} and error is: Format of the initialization string does not conform to specification starting at index 0..\",\"target\":\"/subscriptions/21d331e5-8cec-46ed-b6a3-9a3e7197ac5f/resourceGroups/Business-Intelligence-PRD/providers/Microsoft.DataFactory/factories/bi-prd-df-01/linkedservices/AzureSqlPRD\",\"details\":null}}",
            "serviceRequestId": null
        },
        "relatedEvents": []
    }
    
    
    


    • Edited by everfor Wednesday, September 12, 2018 3:15 PM
    Wednesday, September 12, 2018 3:04 PM

All replies

  • Hello,

    Could you check if the SQL linked service was storing encrypted credentials?  That might be causing the failure.   

    Thursday, September 13, 2018 11:51 PM
    Moderator