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

[catchsaravana]

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

[former_member194529 · Accepted solution]

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