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

  • Document ID:KM01498109
  • Creation Date:07-Apr-2015
  • Modified Date:07-Apr-2015
    • Micro Focus Products:
      structured data manager 7.21

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.