Skip to main content
Solved

database connections with password over 245 characters are not working

  • March 12, 2026
  • 2 replies
  • 81 views
b.hollebeek
Contributor
Forum|alt.badge.img+2

I need to use a Oauth2 token as password to connect to a PostgreSQL database. The problem is that when I try to paste a stringline over 245 characters the connection fails. When reopening the connection parameters the password is red and says ‘Value not allowed’. On another laptop (FME 2022.2) it all works fine. Any idea what causes this problem?

Best answer by jamatsafe

Hi ​@b.hollebeek, thank you for reaching out and reporting this. This issue was previously tracked under FMEFORM-32268 internally and a fix was released for 2024.2.1 onwards. The issue stems from a technical constraint in how unusually long strings were handled in the connection interface for that version, which has since been addressed in newer versions.

If upgrading is an option that would be the recommended path. Unfortunately, due to how the 2024.1 interface validates these strings, there isn't a direct workaround for that specific build other than using an alternative authentication method that uses shorter credentials. I hope this helps clarify things!

    2 replies

    b.hollebeek
    Contributor
    Forum|alt.badge.img+2
    • b.hollebeekContributor
    • Author
    • Contributor
    • March 13, 2026

    This problem is in 2024.1, not in 2022.2 or 2025.1

    jamatsafe
    Safer
    Forum|alt.badge.img+19
    • jamatsafeSafer
    • Safer
    • Best Answer
    • March 13, 2026

    Hi ​@b.hollebeek, thank you for reaching out and reporting this. This issue was previously tracked under FMEFORM-32268 internally and a fix was released for 2024.2.1 onwards. The issue stems from a technical constraint in how unusually long strings were handled in the connection interface for that version, which has since been addressed in newer versions.

    If upgrading is an option that would be the recommended path. Unfortunately, due to how the 2024.1 interface validates these strings, there isn't a direct workaround for that specific build other than using an alternative authentication method that uses shorter credentials. I hope this helps clarify things!

      Community Stats

      32,431
      Posts
      123,238
      Replies
      40,557
      Members
      Terms & ConditionsCookie settingsAccessibility statement
      A product of
      Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.