Skip to main content
Answer

What is the maximum password length for Password in SM200530

  • July 14, 2021
  • 1 reply
  • 164 views
D
Captain II
Forum|alt.badge.img+7

In SM200530 the password field is, in the database, 50 characters long.  However, if I enter a password like:

abcdefghijklmn1234

I get an error when saving:

Error: Updating  the 'Certificate' record failed because data in some field is too long.

2021 R1 Build 21.103.0054

Best answer by Naveen Boga

Hi @ddunn Below are my observations, and might help you to understand above query.

  • Acumatica is using DB3DesCryphString mechanism to encrypt the password and encrypted value will be saved into database.
  • In the screen level, even if you provided “ABCD” as a password (4 character) after encrypting the length of the password may increase to 30 characters  (jC2Eqooc/lfGOQ9qxGk/c8UVfYP8/VFn)
  • Due to this reason you are getting error on the screen level. -
  • But actually this is wrong - Acumatica may look into it future and correct it.

Workaround: Increase the length of the “password” field in the database.

Please find the sample example, which I have tried in my local machine.

 

 

    1 reply

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • Answer
    • July 15, 2021

    Hi @ddunn Below are my observations, and might help you to understand above query.

    • Acumatica is using DB3DesCryphString mechanism to encrypt the password and encrypted value will be saved into database.
    • In the screen level, even if you provided “ABCD” as a password (4 character) after encrypting the length of the password may increase to 30 characters  (jC2Eqooc/lfGOQ9qxGk/c8UVfYP8/VFn)
    • Due to this reason you are getting error on the screen level. -
    • But actually this is wrong - Acumatica may look into it future and correct it.

    Workaround: Increase the length of the “password” field in the database.

    Please find the sample example, which I have tried in my local machine.

     

     

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved