Error during Converter - ERROR [JDBCExceptionReporter] The DELETE statement conflicted with the REFERENCE constraint "XFKJawsCalendarJobCondition". The conflict occurred in database "<database name>", table "dbo.JobCondition", column 'calendarId'.

Products

• Automic Automation Intelligence

Issue/Introduction

Hibernate error during Converter - WARN [JDBCExceptionReporter] SQL Error: 547, SQLState: 23000

 

2021/11/02 09:01:36.958 WARN [GenericSessionImpl] Closing a write session where the final commit() was never called. Some changes may not have been committed
 at com.termalabs.common.connection.hibernate.GenericSessionImpl.close(GenericSessionImpl.java:285)
 at com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.commit(SchedulerUpdateImpl.java:315)
 at com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.commit(SchedulerUpdateImpl.java:298)
 at com.termalabs.server.system.ConverterService.runConverterForScheduler(ConverterService.java:381)
 at com.termalabs.server.system.ConverterService.convertScheduler(ConverterService.java:310)
 at com.termalabs.server.system.ConverterService.run(ConverterService.java:227)
 at com.termalabs.server.system.ConverterService$2.run(ConverterService.java:172)
 at java.util.TimerThread.mainLoop(Timer.java:555)
 at java.util.TimerThread.run(Timer.java:505)

 

 

2021/11/02 09:01:36.958 ERROR [JDBCExceptionReporter] The DELETE statement conflicted with the REFERENCE constraint "XFKJawsCalendarJobCondition". The conflict occurred in database "<database name>", table "dbo.JobCondition", column 'calendarId'.

 

2021/11/02 09:01:36.958 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
 at com.termalabs.common.connection.hibernate.GenericSessionImpl.timedCommit(GenericSessionImpl.java:377)
 at com.termalabs.common.connection.hibernate.GenericSessionImpl.commit(GenericSessionImpl.java:254)
 at com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.saveObjects(SchedulerUpdateImpl.java:561)
 at com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.commit(SchedulerUpdateImpl.java:314)
 at com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.commit(SchedulerUpdateImpl.java:298)
 at com.termalabs.server.system.ConverterService.runConverterForScheduler(ConverterService.java:381)
 at com.termalabs.server.system.ConverterService.convertScheduler(ConverterService.java:310)
 at com.termalabs.server.system.ConverterService.run(ConverterService.java:227)
 at com.termalabs.server.system.ConverterService$2.run(ConverterService.java:172)
 at java.util.TimerThread.mainLoop(Timer.java:555)
 at java.util.TimerThread.run(Timer.java:505)
Caused by: java.sql.BatchUpdateException: The DELETE statement conflicted with the REFERENCE constraint "XFKJawsCalendarJobCondition". The conflict occurred in database "<database name>", table "dbo.JobCondition", column 'calendarId'.
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:1106)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)
 at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
 ... 16 more

 

2021/11/02 09:01:37.356 WARN [ConverterService] Error occurred while converting scheduler "<scheduler name>" (no changes committed): com.termalabs.server.domain.api.SchedulerUpdate$UpdateFailedException: SchedulerUpdate failed in the PRE_UPDATE phase
 at com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.commit(SchedulerUpdateImpl.java:324)
 at com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.commit(SchedulerUpdateImpl.java:298)
 at com.termalabs.server.system.ConverterService.runConverterForScheduler(ConverterService.java:381)
 at com.termalabs.server.system.ConverterService.convertScheduler(ConverterService.java:310)
 at com.termalabs.server.system.ConverterService.run(ConverterService.java:227)
 at com.termalabs.server.system.ConverterService$2.run(ConverterService.java:172)
 at java.util.TimerThread.mainLoop(Timer.java:555)
 at java.util.TimerThread.run(Timer.java:505)
Caused by: com.termalabs.common.datastore.DataAccessException: Flush failed
 at com.termalabs.common.connection.hibernate.GenericSessionImpl.timedCommit(GenericSessionImpl.java:381)
 at com.termalabs.common.connection.hibernate.GenericSessionImpl.commit(GenericSessionImpl.java:254)
 at com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.saveObjects(SchedulerUpdateImpl.java:561)
 at com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.commit(SchedulerUpdateImpl.java:314)
 ... 7 more
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
 at com.termalabs.common.connection.hibernate.GenericSessionImpl.timedCommit(GenericSessionImpl.java:377)
 ... 10 more
Caused by: java.sql.BatchUpdateException: The DELETE statement conflicted with the REFERENCE constraint "XFKJawsCalendarJobCondition". The conflict occurred in database "<database name>", table "dbo.JobCondition", column 'calendarId'.
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:1106)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)
 at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
 ... 16 more

 

 

Environment

Release : 6.4.0

Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION FOR CA 7

Cause

DE519816

Resolution

Resolved in 6.4.1.