Unable to start WebConsole. Error: Cannot insert duplicate key in object

  • KM01498109
  • 07-Apr-2015
  • 07-Apr-2015

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

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).

Error

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.