SAP Knowledge Base Article - Preview

2882461 - Error: "ORA-01400: cannot insert NULL"-SAP Data Services

Symptom

  • Job runs into an error "ORA-01400: cannot insert NULL" on mapped columns.
  • Error: "Execution of <Regular Load Operations> for target <> failed. Possible causes: (1) Error in the SQL syntax; (2) Databaseconnection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The user defined in the datastore has insufficient privileges to execute the SQL. If the error is for preload or postload operation, or if it is for regular load operation and load triggers are defined, check the SQL. Otherwise, for (3) and (4), contact your local DBA."


Read more...

Environment

  • SAP Data Services 4.2 
  • Windows Server 2016
  • Oracle

Product

SAP Data Services 4.2

Keywords

DS, BODS, BODI, jobs, issue, run error, ORA, DB, database, true, false, Win, SQL, bulk loader, load , 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.