SAP Knowledge Base Article - Preview

2016762 - Getting UPSERT errors when loading into a Teradata target table - SAP Data Services


Getting the following errors after a DS job was upgraded from DS 3.2 to DS 4.1:

  • ODBC data source <Datastore_name> error message for operation <SQLPrepare>: <[Teradata][ODBC Teradata Driver][Teradata Database] The UPDATE specified in the UPSERT statement is a complex update. >. 
  • ODBC data source <Datastore_name> error message for operation <SQLPrepare>: <[Teradata][ODBC Teradata Driver][Teradata Database] UPSERT on a table with an Identity Column primary index is illegal.>.



  • SAP Data Services 4.1 and 4.2
  • Teradata 13


SAP Data Services 4.1 ; SAP Data Services 4.2


 DI, DSXI, DS XI, BODI, BODS, 01725147, 1725147 , 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.