• Search Forums
    Advanced Search Topics Posts
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
New Poster
New Poster
Congrats on posting!
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
New Poster
New Poster
Congrats on posting!
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
New Poster
New Poster
Congrats on posting!
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
New Poster
New Poster
Congrats on posting!
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
New Poster
New Poster
Congrats on posting!
8/13/2019 8:19 PM
Great, thanks David.