Self-Solve Knowledge Search

Minimize Maximize
Unable to start WebConsole. Error: Cannot insert duplicate key in object
This document has not been formally reviewed for accuracy and is provided as is
Title :
Unable to start WebConsole. Error: Cannot insert duplicate key in object
Document ID :
KM01498109
Product - Version:
structured data manager 7.21 ;
OS :
Windows,Linux
Updated :
Tue Apr 07 16:44:58 GMT 2015
Summary :
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__OBTWC_PE__496F3185BCDE1E55'. Cannot insert duplicate key in object 'dbo.OBTWC_PERSON_GROUP'. The duplicate key value is (10024, 23).
Problem

Erro from  stacktrace.log

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__OBTWC_PE__496F3185BCDE1E55'. Cannot insert duplicate key in object 'dbo.OBTWC_PERSON_GROUP'. The duplicate key value is (10024, 23).

Cause
Duplicate value (10024, 23), Primary Key, was insert into table OBTWC_PERSON_GROUP. Error was display in stacktrace.log from: <installed_directory>\HPSDM721\obt\webconsole\apache-tomcat\logs
Fix

Identify duplicate value running query:  SELECT *FROM OBTWC_PERSON_GROUP

Then ask user to deleted duplicate values.