SAP Knowledge Base Article - Preview

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

Read more...

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 (Use Subcomponent) , 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 ONE Support launchpad (Login required).

Search for additional results

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