Duplicate key error in server logs

Post any questions regarding Installing or Upgrading Ebase, including problems starting up the Ebase Xi Server or Designer

Moderators: Dave, Jon, Steve, Ian

Segi
Ebase User
Posts: 591
Joined: Mon Dec 09, 2013 6:37 pm

Duplicate key error in server logs

#1

Postby Segi » Mon Mar 05, 2018 6:24 pm

I am seeing this error every minute in my server logs since upgrading to 5.3.2:

Code: Select all

Mon Mar 05 03:41:46: ERROR Scheduler error:  error checking for scheduled tasks to be run
com.ebasetech.ufs.utility.PersistenceException: Error inserting runtime scheduled task runtime record, The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'RUNTIME_SCHEDULED_TASKS_INX' defined on 'RUNTIME_SCHEDULED_TASKS'.
	at com.ebasetech.ufs.runtime.scheduler.ScheduledTaskRuntimeRepository.insertRuntimeTaskToRepository(ScheduledTaskRuntimeRepository.java:144)
	at com.ebasetech.ufs.runtime.scheduler.RuntimeScheduledTask.insertRuntimeTasks(RuntimeScheduledTask.java:386)
	at com.ebasetech.ufs.runtime.scheduler.RuntimeScheduledTask.applyScheduledTaskChangesToDatabase(RuntimeScheduledTask.java:240)
	at com.ebasetech.ufs.runtime.scheduler.Scheduler.detectScheduledTaskChanges(Scheduler.java:148)
	at com.ebasetech.ufs.runtime.scheduler.Scheduler.dispatcher(Scheduler.java:60)
	at com.ebasetech.ufs.runtime.scheduler.Scheduler.run(Scheduler.java:116)
0 x

Jon
Moderator
Moderator
Posts: 1295
Joined: Wed Sep 12, 2007 12:49 pm

Re: Duplicate key error in server logs

#2

Postby Jon » Tue Mar 06, 2018 9:12 am

0 x

Segi
Ebase User
Posts: 591
Joined: Mon Dec 09, 2013 6:37 pm

Re: Duplicate key error in server logs

#3

Postby Segi » Tue Mar 06, 2018 10:32 pm

I removed all of the scheduled tasks and re-added them 1 by one. I didn't find any duplicate IDs but the error has seem to gone away

Thanks for the help
0 x

Segi
Ebase User
Posts: 591
Joined: Mon Dec 09, 2013 6:37 pm

Re: Duplicate key error in server logs

#4

Postby Segi » Fri Apr 13, 2018 4:00 pm

I re-encountered this error today and found that I do in fact have 2 different scheduled tasks that have the same runtimeTaskIdentifier and I was able to figure out why this happened.

I recently duplicated one of my existing tasks in Verj Studio, gave it a new name and change the scheduled task properties but internally Verj did not assign it a new task identifier which is a bug in my opinion. Please fix this so that scheduled tasks generate a new runtimeTaskIdentifier
0 x

Jon
Moderator
Moderator
Posts: 1295
Joined: Wed Sep 12, 2007 12:49 pm

Re: Duplicate key error in server logs

#5

Postby Jon » Mon Apr 16, 2018 1:51 pm

Agreed, we'll fix it. Thanks for finding this.
0 x


Who is online

Users browsing this forum: No registered users and 2 guests