User Unable to Save Profile Due to Address Length Restriction in AIS

Issue:
When a client tries to increase the Address 1 field length while setting up a user in AIS, the UI does not allow more than 64 characters, as a maxlength of 64 is set at the code level.

Details:

• If the client is using LDAP authentication in Adeptia, note that the LDAP server provides only one Address field, unlike Adeptia, which supports Address 1 and Address 2.

• For non-LDAP (normal) users, you can combine Address 1 and Address 2 fields.

  • Example: If the total address is 100 characters, store the first 64 characters in Address 1 and the remaining 36 in Address 2.

Resolution Options:

1. If reducing the address length is feasible:

   • Update the address so it fits within 64 characters.

   • This allows you to modify the address directly from the UI in the future, which is the recommended and safer approach.

2. If modifying the address length is not feasible or out of scope:

   • Complete all other necessary user updates from the UI (except for the address).

   • Then execute a backend query to update the address directly in the database.

   Note:
   Once the address field is updated in the backend with a value longer than 64 characters, no further updates can be made from the UI, as it will trigger the error: "Address 1 length cannot be more than 64 characters."

Important:
Direct database updates are not recommended, as they can affect product functionality. Only perform such updates when no alternative exists and with proper precautions.

For reference, Attaching query below (based on the HSQL database):
 

UPDATE au_users
SET au_address1 = '1234, Park View Apartments, MG Road, Sector 45, Gurugram, Haryana - 122003, Near Huda City Metro Station' ;

SELECT au_address1 FROM au_users;