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

Search for additional results

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