SAP Knowledge Base Article - Preview

3409881 - Error: "Cannot insert duplicate key in object" occurs when using Table_Comparison to MSSQL table - SAP Data Services


  • Job is successful without any errors when doing Table_Comparison to Oracle table
  • The same job fails with below error when doing Table_Comparison to MSSQL table(compared target tables of Oracle and MSSQL are completely same just with different database types)
  • Error: "<[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Violation of PRIMARY KEY constraint 'xxx'. Cannot insert duplicate key in object 'xxx'. The duplicate key value is (xxx, xxx,...)"
  • All of the duplicate key values in error messages have Chinese/Japanese characters
  • By enabling Trace: SQL Loaders=Yes when executing the job, Data Services produces INSERT SQL statements to MSSQL compared table but produces UPDATE SQL statements to Oracle compared table



  • SAP Data Services
  • Microsoft SQL Server


SAP Data Services 4.2 ; SAP Data Services 4.3


MSSQL, collation order, Japanese_XJIS_140_CS_AS_KS_WS_VSS_UTF8, default, codepage, SQL_Latin1_General_CP1_CI_AS, utf-8, shift_jis, Table_Comparison, duplicated, primary key, Chinese characters, insert, update, SQL , KBA , EIM-DS-EXE , Job Execution , 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.