Patch completed with an error (PK_AAI_AMHM_PROPS_UK) violated (Doc ID 2984322.1)

Last updated on NOVEMBER 06, 2023

Applies to:

Symptoms

On : 8.1.1.1 version, Installation_OFSAA
ERROR
-----------------------
Below error can be seen while upgrading to 8.1.1.1.0

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OFSAACONFIG.AAI_AMHM_PROPS_UK) violated

  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:928) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1747) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.OracleStatement.executeLargeUpdate(OracleStatement.java:1712) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1699) ~[ojdbc8.jar:19.3.0.0.0]
  at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:285) ~[ojdbc8.jar:19.3.0.0.0]
  at DBUtil.executeQuery(DBUtil.java:328) [OFSAAIUpdate.jar:?]
  at DBUtil.executeFile(DBUtil.java:203) [OFSAAIUpdate.jar:?]
  at ConfigUpdate.updateConfig(ConfigUpdate.java:53) [OFSAAIUpdate.jar:?]

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade the application to 8.1.1.1.0

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, installation will contain error messages

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.