Troubleshooting
Problem
This technote identifies a possible resolution to the error, unique constraint violated, which might occur when modifying an attribute in the Properties of an IBM® Rational® RequisitePro® Project.
Cause
The full error message is as follows:
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00001: unique constraint (REQPRO.RQPROJECTHISTORY_PK violated)
-Unable to execute statement.
-Unable to add project history.
-Unable to update the project in the database.
This issue is generally the result of having duplicate attributes in the RequisitePro database.
Resolving The Problem
To resolve this issue perform the following procedure:
- From RequisitePro go to File > Project Administration > Properties and select the Attributes tab.
- Select the Requirement type of the Attribute you were modifying before the error message appeared.
- In the list of attributes that appears, look for duplicate attributes.
- If one is found, modify or delete the attribute so a duplicate no longer exists.
Was this topic helpful?
Document Information
More support for:
Rational RequisitePro
Software version:
2002.05.20, 2003.06.00, 2003.06.01, 2003.06.10, 2003.06.12, 2003.06.13, 2003.06.14, 2003.06.15, 2003.06.16, 7.0, 7.0.0.1
Operating system(s):
Windows
Document number:
89015
Modified date:
16 June 2018
UID
swg21254458