My Oracle Support Banner

Oracle V Unique Constraint Error (Doc ID 2242666.1)

Last updated on AUGUST 17, 2018

Applies to:

Oracle Documaker - Version 12.4 and later
Information in this document applies to any platform.


Oracle v 12.5 unique constraint error
DocumakerAdministrator Entities is unable to see the groups from Weblogic Security Realm.

 ORA-00001: unique constraint (RUQY_ODADMIN_UAT.DMKR_ENTITIES_REPONAME_INDEX) violated

When JPSQuery is executed, we get key constraint violation:
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (RUQY_ODADMIN_UAT.DMKR_ENTITIES_REPONAME_INDEX) violated

  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4C8Oall.processError(
  at oracle.jdbc.driver.T4CTTIfun.receive(
  at oracle.jdbc.driver.T4CTTIfun.doRPC(
  at oracle.jdbc.driver.T4C8Oall.doOALL(
  at oracle.jdbc.driver.T4CStatement.doOall8(
  at oracle.jdbc.driver.T4CStatement.executeForRows(
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
  at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(
  at oracle.jdbc.driver.OracleStatement.executeUpdate(
  at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(
  at weblogic.jdbc.wrapper.Statement.executeUpdate(
  at oracle.documaker.wlsjpsquery.JPSQuery.updateEntity(
  at oracle.documaker.wlsjpsquery.JPSQuery.updateEntityFromUser(
  at jsp_servlet.__index._jspService(
  at weblogic.servlet.jsp.JspBase.service(
  at weblogic.servlet.internal.StubSecurityHelper$
  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(
  at weblogic.servlet.interna

The issue can be reproduced at will with the following steps:
Run the script provided by ORACLE.

The issue has the following business impact:
Due to this issue, users cannot continue UAT testing.




To view full details, 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 a vibrant support community of peers and Oracle experts.