Issue | An Adaptive Authentication (On Premise) customer noticed the following error in their aa.scheduler.log file:
2016-10-19 03:01:26,996 ERROR [scheduler_Worker-9] JDBCExceptionReporter - ORA-00001: unique constraint (RSAUSER.PK_EFNLOCALDATA) violated 2016-10-19 03:01:26,996 WARN [scheduler_Worker-9] JDBCExceptionReporter - SQL Error: 1, SQLState: 23000 2016-10-19 03:01:26,996 ERROR [scheduler_Worker-9] JDBCExceptionReporter - ORA-00001: unique constraint (RSAUSER.PK_EFNLOCALDATA) violated 2016-10-19 03:01:26,996 ERROR [scheduler_Worker-9] EfnClient - updateMetaDataInternal failed for entity :ip com.rsa.csd.api.PassMarkException: Unable to persist efn CAUSE: could not insert: [com.rsa.csd.dao.hibernate.domain.EFN] at com.rsa.csd.dao.hibernate.EFNHibernate.putAllEfnElements(EFNHibernate.java:69) at com.passmarksecurity.efn.EfnClient.updateMetaDataInternal(EfnClient.java:140) at com.passmarksecurity.efn.EfnClient.updateLocalRepository(EfnClient.java:108) at com.passmarksecurity.efn.BasicEfn2Client.updateLocalRiskData(BasicEfn2Client.java:183) at com.passmarksecurity.efn.scheduler.EfnScheduler.process(EfnScheduler.java:30) at com.rsa.csd.scheduler.BatchJobWrapper.process(BatchJobWrapper.java:94) at com.rsa.csd.scheduler.BatchJobWrapper.executeInternal(BatchJobWrapper.java:78) at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525) Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [com.rsa.csd.dao.hibernate.domain.EFN] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2438) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2858) at org.hibernate.impl.StatelessSessionImpl.insert(StatelessSessionImpl.java:115) at org.hibernate.impl.StatelessSessionImpl.insert(StatelessSessionImpl.java:97) at com.rsa.csd.dao.hibernate.EFNHibernate.putAllEfnElements(EFNHibernate.java:62) ... 9 more Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (RSAUSER.PK_EFNLOCALDATA) violated |