[keycloak-user] user data > 255 characters is causing Exception

[Stan Silvert]

Hi David,

Can you please file a JIRA for this?

Stan

On 2/6/2019 4:27 PM, David Erie (US) wrote:
> Hi,
> We are storing some user preference data as attributes in Keycloak, and I am seeing this Exception in the Keycloak log file:
>
> 2019-02-06 13:43:55,413 WARN  [org.keycloak.services.resources.admin.UserResource] (default task-2720) Could not update user!: org.keycloak.models.ModelException: org.hibernate.exception.DataException: could not execute statement
>        at org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:61)
>        at org.keycloak.connections.jpa.JpaExceptionConverter.convert(JpaExceptionConverter.java:31)
>        at org.keycloak.transaction.JtaTransactionWrapper.handleException(JtaTransactionWrapper.java:65)
>        at org.keycloak.transaction.JtaTransactionWrapper.commit(JtaTransactionWrapper.java:94)
>        at org.keycloak.services.DefaultKeycloakTransactionManager.commit(DefaultKeycloakTransactionManager.java:136)
>        at org.keycloak.services.resources.admin.UserResource.updateUser(UserResource.java:172)
> <snip>
> Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
>
> Will it be possible to change that DB column definition to have no limit, or a much higher limit? Are there other ways to store long JSON strings with the User besides their attributes?
>
> Thanks,
> Dave
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user