Error: "Violation Of Primary Key Constraint 'pk_bre_registry'. Cannot insert duplicate key in object" When Configuring Team Member with SQL Server
(Doc ID 1965185.1)
Last updated on MARCH 06, 2019
Applies to:
Primavera P6 Team Member - Version 8.4.2.0 and laterInformation in this document applies to any platform.
Symptoms
On : 8.4.1.0 version, Primavera P6 Enterprise Project Portfolio Management
When attempting to configure Team Member, the following error occurs.
Actual Behavior
-----------------------
An attempt to update the server's credentials in the Database registry failed. IP: XXXXXXXX Configuration name: Team Member Configuration com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'pk_bre_registry'. Cannot insert duplicate key in object
Bellow errors can be seen in the p6tmweb.log file:
An attempt to update the server's credentials in the Database registry failed. IP: xxxxxxxx Configuration name: Team Member Configuration
com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'pk_bre_registry'. Cannot insert duplicate key in object 'dbo.BRE_REGISTRY'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:320)
at com.primavera.infr.srvcs.RegistryServiceImpl.begin(RegistryServiceImpl.java:158)
at com.primavera.infr.srvcs.RegistryServiceImpl.init(RegistryServiceImpl.java:115)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606
Changes
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 |
Changes |
Cause |
Solution |
References |