SAP Knowledge Base Article - Preview

2050271 - Validation Errors in Designer on mapping to identity column - Data Services

Symptom

  • After upgrading the code from 12.2 to 14.2 the warning becomes an error when validating the data flow. The job does run though.
  • The map operation transform on the job does not map to the identity column.
  • Validation error in Designer - only happens when validating the dataflow or job.
  • Error:  "[Target Table:<table name>(<datastore.owner)] Column <col name> in schema type <target> does not have a matching column in schema type <source> and is not nullable. Make this column nullable, or specify a mapping expression that can provide values for this column. (BODI-1111037)"

 


Read more...

Environment

  • SAP Data Services Designer 14.2.2.446 (does not happen on designer 14.2.1.255)
  • Microsoft SQL Server

Product

SAP Data Services 4.2

Keywords

BODS, DSXI , KBA , EIM-DS-DES , User Interface/Designer , EIM-DS , Data Services , Bug Filed

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.