Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Dataiterator locking file

1 Replies

0 Subscribed to this topic

53 Subscribed to this forum

Sort:

Author

Messages

mjcindc

Basic Member

Posts: 8

8/13/2009 3:15 PM

I've written a process flow that uses a data iterator object to access a file specified by a variable. The process flow loops through several files and uploads the data into GLTRANSREL. The importdb portion, which comes after the dataiterator, of the flow uploads data from each file, but the data iterator, which uses the same variable to identify the file, pulls data from the same file on each loop. It is the first file that it encounters. Furthermore, the file seems to be locked by the process flow. After the flow is finished running, I am unable to delete the first file because 'it is in use by another application.'

Thoughts?

mjcindc

Basic Member

Posts: 8

8/13/2009 5:51 PM

I was able to keep the file from locking by setting 'Maximum Read Iterations' to 10000 rather than 2, even though I only wanted it to read two lines. It still shows data from the first file on subsequent passes of the pflow which is strange because the importdb section reads the correct file and they are using the same variable.