EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB39021: "Violation of PRIMARY KEY constraint PK_ADDRESS. Cannot insert duplicate key in object dbo.DSSCSADDRESS. The duplicate key value is (<ID>)" error occurs when trying to duplicate a project across Project Sources in MicroStrategy Developer 9.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


KB39021: "Violation of PRIMARY KEY constraint PK_ADDRESS. Cannot insert duplicate key in object dbo.DSSCSADDRESS. The duplicate key value is (<ID>)" error occurs when trying to duplicate a project across Project Sources in MicroStrategy Developer 9.x

SYMPTOM:
 
When trying to duplicate a project across Project Sources in 2-tier using default Project Duplication Wizard settings , error is received after project duplication process starts, which leads to project duplication stopping:
 

ka02R000000kYHuQAM_0EM440000002DOC.png

 
Violation of PRIMARY KEY constraint 'PK_ADDRESS'. Cannot insert duplicate key in object 'dbo.DSSCSADDRESS'. The duplicate key value is (<ID>).
  
 
CAUSE:
 
This error is caused by a logical metadata inconsistency. The table referenced in the error message (DSSCSADDRESS) is a metadata table which stores contact information used by Distribution Services.
 In order to track down the cause of the inconsistency, customers encountering this issue should make note of Schema-related changes, Object Migrations, or error messages prior to experiencing the problem.  Change Journal, if it has been enabled, can help in preserving this information.  
 
ACTION:
 
Contact Strategy Technical Support for further assistance in resolving issue.
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 9, 2017

Last Updated:

June 9, 2017