PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/13/2019 4:19 PM by  Scooter
IPA Data Iterator node cannot find input file.
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Scooter
Private
Private
Veteran Member
(129 points)
Veteran Member
Posts:59


Send Message:

--
08/12/2019 4: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
    Private
    Private
    Veteran Member
    (3208 points)
    Veteran Member
    Posts:1080


    Send Message:

    --
    08/12/2019 8:35 PM
    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
    Private
    Private
    Veteran Member
    (1393 points)
    Veteran Member
    Posts:495


    Send Message:

    --
    08/13/2019 5: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
    Private
    Private
    Veteran Member
    (129 points)
    Veteran Member
    Posts:59


    Send Message:

    --
    08/13/2019 10:15 AM
    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
    Private
    Private
    Veteran Member
    (3208 points)
    Veteran Member
    Posts:1080


    Send Message:

    --
    08/13/2019 10:24 AM
    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
    Private
    Private
    Veteran Member
    (129 points)
    Veteran Member
    Posts:59


    Send Message:

    --
    08/13/2019 4:19 PM
    Great, thanks David.
    You are not authorized to post a reply.