Skip to Content

Reason: SQL Error: cannot insert NULL or update to NULL: N in sap ibp

Hello Experts,

While uploading location product in SAP IBP thru data integration job, I am getting below error message

Unable to read file OLLOCATIONPRODUCT_TEMPLATE.csv for batch ID 3885. Reason: SQL Error: cannot insert NULL or update to NULL: N

please let me know
regards,
saravana

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 20 at 10:30 PM

    Hello Saravana,

    This error message usually indicates that your Master Data has some mandatory attribute(s) which can not been empty and were not fulfilled in the CSV. This causes the error during the upload process.

    Please double check if all mandatory attributes are provided in the csv file. You can also download a sample template from the Data Integration jobs app to be sure.

    Best,

    Ivan

    Add comment
    10|10000 characters needed characters exceeded