Skip to Content
avatar image
Former Member

Data Integration error

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

Capture.JPG (25.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 12, 2016 at 10:37 PM

    Hi Sean,

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

    Subash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2016 at 04:58 AM

    Was the uploaded file in proper .csv format?

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2016 at 11:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Subash Nanjangud

      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.