000034301 - Adaptive Authentication (On Premise) customer is seeing "Unable to persist efn" error in their aa.scheduler.log

Document created by RSA Customer Support Employee on Nov 2, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000034301
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Product/Service Type: Adaptive Authentication (OnPrem)
RSA Version/Condition: 7.1
 
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
ResolutionA hot fix, HF50 for V7.1 P6, for this issue can be obtained from RSA. The fix for this issue was put into V7.3.
 

Attachments

    Outcomes