Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Integration / Customization
IPA/ProcessFlow
IPA Data Iterator node cannot find input file.
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
NonnieBear1776
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5162
People Online:
Visitors:
213
Members:
0
Total:
213
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
IPA/ProcessFlow
IPA Data Iterator node cannot find input file.
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Scooter
Veteran Member
Posts: 83
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 name
I1 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
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.
JimY
Veteran Member
Posts: 510
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
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
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.
Scooter
Veteran Member
Posts: 83
8/13/2019 8:19 PM
Great, thanks David.
You are not authorized to post a reply.