ADF Linked Service issue to a MySQL DB

Question

Hi,

I am having an issue with a ADF linked service. I have established a connection to the MySQL DB using MySQL Workbench with the same SSL details, but the connection to the linked service keeps on failing. The error is:

Failed to connect to the mysql source, errorMsg: "The collection already contains item with same key 'net.transport''". "The collection already contains item with same key 'net.transport''" This issue is still persisting after trying all the difference configurations. I have tried all the difference sslModes and also restarted the integration runtime.

Thanks.

Below is the JSON:

{
    "name": "Swordfish_DB",
    "properties": {
        "annotations": [],
        "type": "MySql",
        "typeProperties": {
            "server": "****************",
            "port": ********,
            "database": "**********************",
            "username": "***********************",
            "sslMode": 4,
            "useSystemTrustStore": 0,
            "password": {
                "type": "AzureKeyVaultSecret",
                "store": {
                    "referenceName": "Swordfish",
                    "type": "LinkedServiceReference"
                },
                "secretName": "BOC-Password"
            },
            "driverVersion": "v2",
            "SSLCert": {
                "type": "AzureKeyVaultSecret",
                "store": {
                    "referenceName": "Swordfish",
                    "type": "LinkedServiceReference"
                },
                "secretName": "swordfish-client-certificate"
            },
            "SSLKey": {
                "type": "AzureKeyVaultSecret",
                "store": {
                    "referenceName": "Swordfish",
                    "type": "LinkedServiceReference"
                },
                "secretName": "swordfish-client-key"
            },
            "caCertificate": {
                "type": "AzureKeyVaultSecret",
                "store": {
                    "referenceName": "Swordfish",
                    "type": "LinkedServiceReference"
                },
                "secretName": "swordfish-ca"
            }
        },
        "connectVia": {
            "referenceName": "BOC-Carl",
            "type": "IntegrationRuntimeReference"
        }
    },
    "type": "Microsoft.DataFactory/factories/linkedservices"
}

Answer 1

@Carl Carey - Thanks for the question and using MS Q&A platform.

Based on the error message you provided, it seems like there is a duplicate key in the configuration. Specifically, the error message states that the collection already contains an item with the same key 'net.transport'. 

To resolve this issue, you can try the following steps: 

• Check if there are any duplicate keys in the configuration. You can do this by reviewing the JSON code you provided and ensuring that there are no duplicate keys. 
• Try changing the SSL mode to a different value. You can try using SSL mode 1 or 2 instead of 4. 
• Ensure that the integration runtime is running and connected to the correct network. 
• Check if the SSL certificate, client certificate, and client key are valid and have been uploaded correctly to the Azure Key Vault. 

Note: Make to double check the configuration details as mentioned in the official documentation: If you use the recommended driver version the following properties are supported for MySQL linked service.

For more details, refer to Copy data from MySQL using Azure Data Factory or Synapse Analytics 

If none of these step's work, please do share the detailed stack trace of error message along with screenshot for further assistance. 

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.