Prev
Next
Forums Integration / Customization IPA/ProcessFlow

IPA Data Iterator node cannot find input file.

 5 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Scooter
Veteran Member
Posts: 83
Veteran Member
8/12/2019 8:06 PM
    IPA Data Iterator node cannot find input file. Need your assistance to identify issue with Data Iterator node.
    Error message is "File "https://lawtestv10.dart.org/lawson02/univ2/dartipa/appload.CSV" does not exist."
    We've confirmed file (appload.CSV) exists on this directory (/lawson02/univ2/dartipa/ and server (lawtestv10.dart.org).

    Below error message was copied from workunit log file:

    Activity nameI1 id:1 started @ 08/12/2019 03:41:24.578 PM
    Executing Data Iterator Activity DI1 ...
    iteration 1 nextPosition=0
    File "https://lawtestv10.dart.org/lawson02/univ2/dartipa/appload.CSV" does not exist.
    Terminating the process ...
    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
    8/13/2019 12:35 AM
      The Data Iterator can only read a file on the Landmark server. You need to load the file into memory (with a File Access) and iterate the Data or FTP the file over to Landmark.
      David Williams
      JimY
      Veteran Member
      Posts: 510
      Veteran Member
      8/13/2019 9:44 AM
        David is correct that you will need a File Access node to read it into memory. Instead of using FTP you could make the folder that the file is in a share and access it that way from your File Access node. For Windows if you have a file in a folder with a shared name of "in2" then you would specify it this way: \\\\\\in2\\
        Scooter
        Veteran Member
        Posts: 83
        Veteran Member
        8/13/2019 2:15 PM
          For input file (FileAccess), can either forward slashes / or back slashes \ work the same?
          e.g. if input file is ////lmrktest.dart.org//lmrk//appload.csv which converts to //lmrktest.dart.org/lmrk/appload.csv
          Also, is it correct to code // equal / (like above example)?
          David Williams
          Veteran Member
          Posts: 1127
          Veteran Member
          8/13/2019 2:24 PM
            If you're assigning to a variable then you have to use \\ to represent a \ but if you're keying the address directly on the File Access then \ works fine. The mapped server reference in a variable would be \\\\ while direct keyed would be \\

            It's confusing.
            David Williams
            Scooter
            Veteran Member
            Posts: 83
            Veteran Member
            8/13/2019 8:19 PM
              Great, thanks David.