Actions
Task #2776
closed
Configuration item with value longer than 255 characters can't be saved
Start date:
04/22/2021
Due date:
% Done:
100%
Estimated time:
Owner:
Description
Tested on 10.8.2 and 9.7.16.
When trying to update a configuration item with value longer than 255 characters, we get following screen:
Apr 22 05:22:18 idmlocal czechidm[1134]: 2021-04-22 07:22:18.361 WARN 74612748 --- [http-nio-8080-exec-10] o.h.e.jdbc.spi.SqlExceptionHelper.logExceptions : SQL Error: 0, SQLState: 22001
Apr 22 05:22:18 idmlocal czechidm[1134]: 2021-04-22 07:22:18.362 ERROR 74612749 --- [http-nio-8080-exec-10] o.h.e.jdbc.spi.SqlExceptionHelper.logExceptions : ERROR: value too long for type character varying(255)
Apr 22 05:22:18 idmlocal czechidm[1134]: 2021-04-22 07:22:18.368 ERROR 74612755 --- [http-nio-8080-exec-10] e.b.i.c.a.e.AbstractEntityEventProcessor.log : [core:EVENT_EXECUTE_PROCESSOR_FAILED:5948bd20-af93-460e-b78a-9ca9c3f019db] Event [null] failed in processor [core-configuration-save-processor]. ({eventId=null, processor=core-configuration-save-processor})
Apr 22 05:22:18 idmlocal czechidm[1134]: org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:300)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:253)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:527)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:153)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:144)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$ExposeRepositoryInvocationInterceptor.invoke(CrudMethodMetadataPostProcessor.java:364)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at com.sun.proxy.$Proxy210.saveAndFlush(Unknown Source)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at eu.bcvsolutions.idm.core.api.service.AbstractReadWriteDtoService.saveInternal(AbstractReadWriteDtoService.java:98)
Apr 22 05:22:18 idmlocal czechidm[1134]: #011at eu.bcvsolutions.idm.core.model.service.impl.DefaultConfigurationService.saveInternal(DefaultConfigurationService.java:209)
Files
Actions