Question Re: Error while uploading Location Master Data? in Supply Chain Management Q&A

Error while uploading Location Master Data?

Former Member — Fri, 06 Oct 2017 12:06:11 GMT

Hi,

In IBP 1708, I have added an attribute "Plant" in the Master data table Location.

When I am uploading the data through this table I am getting the following error:

List of columns provided for batch 1155 in L02LOCATION_TEMPLATE (2).csv is invalid/IBP/INTEGRATIONList of columns provided for batch 1155 in L02LOCATION_TEMPLATE (2).csv is invalid/IBP/INTEGRATIONNot sure why the columns are invalid. Please help.

Re: Error while uploading Location Master Data?

melinda_abel — Tue, 10 Oct 2017 13:41:37 GMT

Hi,
could you try that you download the master data template and check the difference? Can you upload this sample csv with 'dummy' data?
Best regards,
Melinda

Re: Error while uploading Location Master Data?

AyanBishnu — Tue, 10 Oct 2017 21:30:14 GMT

Please provide details of the attribute that you have created (e.g if it is varchar / int, length) and what is the value that you are maintaining, while you are loading the data. If possible share screenshot of the attributes and also the csv file.

Re: Error while uploading Location Master Data?

Former Member — Fri, 12 Jan 2018 02:27:28 GMT

There can be three reasons:

1) NULL value is provided in the LOCATIONID field for at least one of the rows of the template OR

2) Some columns have been missed out in the output template, if this is the case Download template again and upload without removing any column for non-root attributes OR

3) Check the datatype for each of the column uploaded, it should be the same as the datatype mentioned in the attribute of the model configuration