Steps to reproduce:
Excepted:
The user successfully logs in
Actual:
The login fails and the following error is present in the logs:
2026-04-06 15:17:35,925 [qtp1039949752-32 - http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] WARN o.h.e.j.s.SqlExceptionHelper - SQL Error: 3401, SQLState: 22001 2026-04-06 15:17:35,926 [qtp1039949752-32 - http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] ERROR o.h.e.j.s.SqlExceptionHelper - data exception: string data, right truncation ; size limit: 768 table: XWIKISTRINGS column: XWS_VALUE 2026-04-06 15:17:35,934 [qtp1039949752-32 - http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] WARN nticationFailureLoggerListener - Authentication failure with login [RetiredAccName]
A possible workaround would be to skip that attribute from the mapping or map it to some xwiki user attribute that is of type "LargeString".
What would be a solution to this issue tho? Trim the fields before saving the user profile? Skip them entirely?