Defect #2287: Idm sometimes fails at startup when using MSSQL - IdStory Identity Manager

Actions

Copy link

Defect #2287

closed

Idm sometimes fails at startup when using MSSQL

Added by Ondrej Husník almost 4 years ago. Updated almost 4 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Radek Tomiška

Category:

Database

Target version:

10.3.2

Start date:

06/01/2020

Due date:

% Done:

100%

Estimated time:

Affected versions:

Owner:

Description

There is a wrong size set in V10_03_001__long-running-task-audit.sql flyway script for result_model property in idm_long_running_task_a table.

@affected version 10.3.0

2020-05-31 16:53:43.552 ERROR 49095 --- [main] o.h.e.jdbc.spi.SqlExceptionHelper.logExceptions : String or binary data would be truncated in table 'bcv_idm_10.dbo.idm_long_running_task_a', column 'result_model'. Truncated value: ''.
2020-05-31 16:53:43.565 ERROR 49108 --- [main] org.hibernate.AssertionFailure.<init> : HHH000099: an assertion failure occurred (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session): javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
    at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1460)
    at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1440)
    at org.hibernate.envers.internal.synchronization.AuditProcess.doBeforeTransactionCompletion(AuditProcess.java:177)
    at org.hibernate.envers.internal.synchronization.AuditProcessManager$1.doBeforeTransactionCompletion(AuditProcessManager.java:47)
    at org.hibernate.engine.spi.ActionQueue$BeforeTransactionCompletionProcessQueue.beforeTransactionCompletion(ActionQueue.java:954)
    at org.hibernate.engine.spi.ActionQueue.beforeTransactionCompletion(ActionQueue.java:525)
    at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2487)
    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178)
    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39)
    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271)
    at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:104)
    at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:532)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:534)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:305)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    at eu.bcvsolutions.idm.core.scheduler.service.impl.DefaultLongRunningTaskManager$$EnhancerBySpringCGLIB$$8dd5574c.init(<generated>)
    at eu.bcvsolutions.idm.InitApplicationData.init(InitApplicationData.java:238)
    at eu.bcvsolutions.idm.InitApplicationData.onApplicationEvent(InitApplicationData.java:105)
    at eu.bcvsolutions.idm.InitApplicationData.onApplicationEvent(InitApplicationData.java:1)
    at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:172)
    at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:165)

Related issues

Actions

Copy link

Updated by Radek Tomiška almost 4 years ago

Description updated (diff)
Target version set to 10.3.2

Actions

Copy link

Updated by Radek Tomiška almost 4 years ago

Status changed from New to Needs feedback
Assignee changed from Radek Tomiška to Ondrej Husník
% Done changed from 0 to 90

I accidentally added this audit support for test and to fix the issue with embedded OperationResult in audit tables. I've removed audit support for 'result' model property, will be added in future.

Commit:
https://github.com/bcvsolutions/CzechIdMng/commit/d0fe6176a7ea64c85b16aaa89ed13a3aa08e25f5

Could you provide me a feedback, please?

Actions

Copy link