ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Multiple files not getting written to IFS

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Multiple files not getting written to IFS

    Hi All,


    Our project has a requirement where in ELT tool ODI would be loading the data from oracle DB to AS400.

    ODI tried to load CSV files to a new directory created by us in IFS and is working fine for one file and when trying to load multiple files ODI job is failing.

    But when ODI tried to load multiple CSV files to root folder, the Job is working perfectly.

    Can anyone throw some light on this issue.

  • #2
    Re: Multiple files not getting written to IFS

    ...and when trying to load multiple files ODI job is failing.
    Failing?

    Failing how? Wrong result? No result? Job abends? Throws error messages? If messages, what are they? (Especially, what are any message identifiers?)

    Does it always "fail" the same way? Does it matter which file is loaded first? What is meant by a "load"? Since this is apparently done at least in part across a network, what protocols are involved? What platform is on the other end? What OS release is on your server?

    It is difficult to guess how to help without knowing what is happening.
    Tom

    There are only two hard things in Computer Science: cache invalidation, naming things and off-by-one errors.

    Why is it that all of the instruments seeking intelligent life in the universe are pointed away from Earth?

    Comment


    • #3
      Re: Multiple files not getting written to IFS

      Hi Tom,

      This is the error message they are getting;

      The package execution failed with the session id - 180775008 .

      ODI-1241: Oracle Data Integrator tool execution fails.

      Caused By: org.apache.commons.vfs.FileSystemException: Could not copy

      at org.apache.commons.vfs.provider.AbstractFileObject .copyFrom(AbstractFileObject.java:902)

      at com.sunopsis.dwg.tools.filecopy.RemoteFileCopy.cop y(RemoteFileCopy

      Comment


      • #4
        Re: Multiple files not getting written to IFS

        Unless some other member has good ODI experience, I'd suggest you start with asking in one of the Oracle Technology Network (OTN) Community forums. Perhaps ask in the General forum where questions about ODI are best submitted.

        It's possible that configuration or script changes on the ODI side can clear up the problem. If all seems well in ODI, then it might be possible to dig into your server side.
        Tom

        There are only two hard things in Computer Science: cache invalidation, naming things and off-by-one errors.

        Why is it that all of the instruments seeking intelligent life in the universe are pointed away from Earth?

        Comment

        Working...
        X