Skip to main content
Solved

What is the maximum password length for Password in SM200530

  • 14 July 2021
  • 1 reply
  • 115 views

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

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.

 

 

Reply


Terms & ConditionsCookie settings