1814077 - Error: Violation of PRIMARY KEY constraint 'PK__MTINFO__<number>'. Cannot insert duplicate key in object 'dbo.MTINFO'. - Data Services

Symptom

Running job with Data Quality reports
First workflow completes but second fails
Cannot insert duplicate key in object 'dbo.UDCINFOCODESUMMARY'
Match ERROR: Violation of PRIMARY KEY constraint 'PK__MTINFO__<number>'. Cannot insert duplicate key in object 'dbo.MTINFO'.>.>.
URAC/GAC ERROR: Violation of PRIMARY KEY constraint 'PK__ADDRTYPE__39379A672DB1C7EE'. Cannot insert duplicate key in object 'dbo.ADDRTYPESUMMARY'.>.>.
Geocoder ERROR: Violation of PRIMARY KEY constraint 'PK__GEO_ASSI__D421EB47351DDF8C'. Cannot insert duplicate key in object 'dbo.GEO_ASSIGN_LEVEL'.>.

Environment

SAP Data Services

Product

SAP Data Services all versions

Keywords

DQ, DSXI, DS XI, BODS, EDGE, DQM, Global address cleanse, United States Regulatory , KBA , EIM-DS , Data Services , EIM-DS-DQ , Data Services Data Quality , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.

1814077 - Error: Violation of PRIMARY KEY constraint 'PKMTINFO<number>'. Cannot insert duplicate key in object 'dbo.MTINFO'. - Data Services