search cancel

Tidal - Events stop updating - ERROR [JDBCExceptionReporter] Cannot insert duplicate key row in object 'dbo.JobStream_Job' with unique index 'XAK1JobStream_Job'

book

Article ID: 244221

calendar_today

Updated On:

Products

Automic Automation Intelligence

Issue/Introduction

All events stopped processing for all schedulers after an incremental converter run failed due to a duplicate key exception.

Events only started to process again after restarting the AAI service.

 

ERROR [JDBCExceptionReporter] Cannot insert duplicate key row in object 'dbo.JobStream_Job' with unique index 'XAK1JobStream_Job'. The duplicate key value is (AXrHXXMXP2Y=, AX3KZQjKHYg=).
 
WARN [JobStreamVendorImpl] Deleted JobStreamJobs (0) for UUID[AXrHXXMXP2Y=] 
 
 
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:167) 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.flush(GenericSessionImpl.java:362) at com.termalabs.server.cache.JobStreamVendorImpl.flush(JobStreamVendorImpl.java:2542) at com.termalabs.server.cache.JobStreamVendorImpl.updateJobStreamJobs(JobStreamVendorImpl.java:2366) at com.termalabs.server.cache.JobStreamVendorImpl.updateFilterJobsWithWriteLock(JobStreamVendorImpl.java:2297) at com.termalabs.server.cache.JobStreamVendorImpl.updateFilterJobs(JobStreamVendorImpl.java:2274) at com.termalabs.server.app.jobstream.JobStreamBuilder.rebuildJobstreamsJobs(JobStreamBuilder.java:547) at com.termalabs.server.app.jobstream.JobStreamBuilder.rebuildJobStreamsForJobs(JobStreamBuilder.java:491) at com.termalabs.server.app.scheduler.ConverterAfterCommitAction.perform(ConverterAfterCommitAction.java:77) at com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.postCommit(SchedulerUpdateImpl.java:463) at com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.commit(SchedulerUpdateImpl.java:331) at com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.commit(SchedulerUpdateImpl.java:298) at com.termalabs.server.app.scheduler.SchedulerHelper.convertScheduler(SchedulerHelper.java:259) at com.termalabs.server.app.scheduler.SchedulerHelper.downloadScheduler(SchedulerHelper.java:211) at com.termalabs.server.tidal.jammer.TidalJammer.runIncrementalConverter(TidalJammer.java:506) at com.termalabs.server.tidal.jammer.TidalJammer.processRuns(TidalJammer.java:329) at com.termalabs.server.system.RunCycle$JammerRunner.runJammer(RunCycle.java:982) at com.termalabs.server.system.RunCycle$JammerRunner.run(RunCycle.java:964) at com.termalabs.server.system.RunCycle.compute(RunCycle.java:286) at com.termalabs.server.system.CommonJammerSequence.runCycle(CommonJammerSequence.java:225) at com.termalabs.server.system.CommonJammerSequence.runJammerSequence(CommonJammerSequence.java:158) at com.termalabs.server.system.JammerSequence.run(JammerSequence.java:141) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.BatchUpdateException: Cannot insert duplicate key row in object 'dbo.JobStream_Job' with unique index 'XAK1JobStream_Job'. The duplicate key value is (AXrHXXMXP2Y=, AX3KZQjKHYg=). 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) ... 31 more

 

 

WARN [SchedulerHelper] Scheduler updates partially completed; server must be restarted to get new events.

Environment

Release : 6.4.1

Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION FOR TIDAL

Resolution

DE523859 to be fixed in release 6.4.2-4