Data Integration error

[Former Member]

Experts,

When attempting to upload product master data to our activated planning area in a 5.2 IBP system using the data integration tool, the load fails with the attached error, "Could not read file:  unable to read file.  Reason: Fatal error. More info in table /IBP/IMTCLOG". 

I did download the template first and populated the data into the template, so there should be no issues there. Also, I have ensured that the load file was indeed closed before the load, so there should be no issue with the system accessing the file. 

Has anyone seen this before or have any idea how to access the table/log that is referenced?

Thanks,

Sean Mawhorter

[Former Member]

Hi Sean,

This could be due to multiple reasons. I would check the following:

1. check file format (.csv not excel)

2. the separator used in the file is the same as the one specified in the file format (datastore settings)

3. number of columns and column names in the file are the same as the ones specified in the file format (datastore settings).

4. make sure the path where this file is located is declared in the agent config white listed entries.

You could also do the following test. Take this file, keep only one record (so you don't load too much data in IBP if successful) and load it as a csv upload from IBP UI. In this way you validate if the content and structure of the file is correct or not and narrow down your search. It may not be the integration tool.

Regards,

Cosmin

[former_member182607]

Guys,

i ran into the same error when loading S4PRODUCT yesterday. The funny thing is I was able to load the same file into a custom object ISPRODUCT with the same excact attfibutes successfully. I am still wondering why.

Thanks,

Subash

[Former Member]

Is S4PRODUCT used in other planning areas? If yes, are those planning areas active?

Also, try a file upload from IBP into S4PRODUCT and see if that works.

[Former Member]

Was the uploaded file in proper .csv format?

Were inadvertent blank columns added (perhaps when editing in MS Excel)?

[former_member182607]

Hi Sean,

Did you get a solution to the problem? I got the same problem when I tried loading S4PRODUCT.

Subash