My Oracle Support Banner

Error "Unique Constraint AGILE_REV_PK Violated" While Performing Save As On Changes (Doc ID 3063514.1)

Last updated on FEBRUARY 19, 2025

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Oracle Agile Product Collaboration - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

Users are getting Primary key violated error when ever they are performing Save As on Changes.

Steps to reproduce:

============

Open a change object.

From Action menu select Save As

Fill in the required fields and click Save.

Error "ORA-00001: unique constraint (AGILE.REV_PK) violated"

 

Application Server log shows errors: (<Agile_Home>/AgileDomain/Servers/AgileXXX/Logs)

=======================

ORA-00001: unique constraint (AGILE.REV_PK) violated

java.sql.BatchUpdateException: ORA-00001: unique constraint (AGILE.REV_PK) violated

at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9775)
at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1448)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9540)

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


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