ORA-00001: unique constraint Errors Seen in Oracle Access Manager 11.1.2.2.0 (Doc ID 1914415.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Access Manager - Version 11.1.2.2.0 and later
Information in this document applies to any platform.

Goal

I am seeing following error in oam_server1-diagnostic.log.

[2014-07-24T11:19:15.211-04:00] [dev_oam_server1] [ERROR] [] [oracle.oam.engine.session] [tid: pool-19-thread-1] [userId: ] [ecid: 0000KTcu8ad4ykWpPwL6id1JoI3O000002,1:20074] [APP: oam_server#11.1.2.0.0] Session object for sessionid background save was not saved.[[
oracle.security.am.engines.sme.exceptions.SmeRuntimeException: Session object for sessionid background save was not saved.
  at oracle.security.am.engines.sme.mapimpl.db.DbOraSmeStore.throwRuntimeException(DbOraSmeStore.java:665)
  at oracle.security.am.engines.sme.mapimpl.db.DbOraSmeStore$BatchStoreTask.handleRuntimeException(DbOraSmeStore.java:2238)
  at oracle.security.am.engines.sme.mapimpl.db.BatchTask.run(BatchTask.java:59)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:482)
  at java.util.concurrent.FutureTask.run(FutureTask.java:273)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1156)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:626)
  at java.lang.Thread.run(Thread.java:804)
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (XXH_OAM.OAM_SESSION_UK1) violated

  at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)
  at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:248)
  at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210)
  at oracle.security.am.engines.sme.mapimpl.db.DbOraSmeStore.performExecuteBatch(DbOraSmeStore.java:1114)
  at oracle.security.am.engines.sme.mapimpl.db.DbOraSmeStore.access$500(DbOraSmeStore.java:103)
  at oracle.security.am.engines.sme.mapimpl.db.DbOraSmeStore$BatchSessionTask.doWork(DbOraSmeStore.java:2092)
  at oracle.security.am.engines.sme.mapimpl.db.BatchTask.run(BatchTask.java:56)
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms