Issues Upgrading linked service for PostgreSQL - Data Factory

RRM 20 Reputation points
2024-10-09T15:20:42.9533333+00:00

I´m using the legacy LS for Postres SQL (SHIR) and the connection is working fine, with no issues until today. I need to update the linked service (MS recomend to do it until 31/10/2024) but I´m receiving an error while testing the connection for the new one.

Everythin is passing via an Self-Hosted Integration Runtime installed on a local virtual machine.

Here´s the LS legacy json running ok:

{
    "name": "telemetria",
    "type": "Microsoft.DataFactory/factories/linkedservices",
    "properties": {
        "type": "PostgreSql",
        "typeProperties": {
            "server": "abcdefgh.rds.amazonaws.com",
            "database": "mydb",
            "username": "myuser",
            "encryptedCredential": "------------------"
        },
        "connectVia": {
            "referenceName": "shir",
            "type": "IntegrationRuntimeReference"
        },
        "annotations": []
    }
}

I'm trying to create with the new connector, but the connection test it´s failing.

Code:


{
    "name": "telemetria_new",
    "type": "Microsoft.DataFactory/factories/linkedservices",
    "properties": {
        "annotations": [],
        "type": "PostgreSqlV2",
        "typeProperties": {
            "server": "abcdefgh.rds.amazonaws.com",
            "port": 5432,
            "database": "mydb",
            "username": "myuser",
            "sslMode": 0,
            "authenticationType": "Basic",
            "encryptedCredential": "------------------"
        },
        "connectVia": {
            "referenceName": "shir",
            "type": "IntegrationRuntimeReference"
        }
    }
}

Info:

  • Error code: 11402
  • Details: The value of the property 'passwordmypassword;ssl mode' is invalid: 'Couldn't set passwordmypassword;ssl mode Parameter name: passwordmypassword;ssl mode'. Couldn't set passwordmypassword;ssl mode Parameter name: passwordmypassword;ssl mode The given key was not present in the dictionary.
  • Additional info: the text 'mypassword' is the current password

I´m not the dba.

Connection from SelfHosted Integration Runtime is ok for that serve, database, user and password.

Can someone help me please?

Thanks in advance!

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  2. RRM 20 Reputation points
    2024-10-11T14:29:37.24+00:00

    Thank you very much for the answer Amira!

    Unfortunately the option to alter the 'sslmode' to receive a string returns error as it is configured to receive integer. This is something I had already tried.

    What did give me an important clue to go deeper was the password issue, and that there was nothing corrupt in the encryption. So I asked the company's dba for a new user and password for the database, and everything worked correctly. I am now connected and it works fine.

    Thank you very much again for the help and the quick response!

    Translated with DeepL.com (free version)

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.