SAP Knowledge Base Article - Preview

2892304 - Error: NULL value cannot be inserted into <column_name> column, <table_name> table. The column does not allow NULL values. Error during INSERT. - Data Services

Symptom

  • Job Error:  |Data flow <df_name>|Loader <target_nameODBC data source <dataSource_name> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 10.0][SQL Server]NULL value cannot be inserted into <column_name> column, <table_name> table. The column does not allow NULL values. Error during INSERT. [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement finished. [Microsoft][SQL Server Native Client 10.0][SQL Server]The NULL value can be in the <column_name> column, <table_name> table not inserted. The column does not allow NULL values. Error during INSERT.
  • FIM Job is being cancelled.
  • Errors during job execution on NULL values.


Read more...

Environment

SAP Data Services

Product

SAP Data Services 4.2

Keywords

GV, DS , 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.