SAP Knowledge Base Article - Preview

3704316 - Error: "Cannot insert the value NULL into column" occurs in task when extracting from IBP source and loading to MSSQL target - SAP Cloud Integration for data services

Symptom

  • Task fails with error
  • Error message: "[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'xxx', table 'xxx'; column does not allow nulls. INSERT fails. [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated."


Read more...

Environment

  • SAP Cloud Integration for data services
  • IBP
  • Microsoft SQL Server

Product

SAP Cloud Integration for data services 1.0

Keywords

null value error, sql server, cannot insert null, task failure, material data, dataflow filter, The statement has been terminated, INSERT , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , 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.