Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Dataiterator locking file

 1 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
mjcindc
Basic Member
Posts: 8
Basic Member
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
    Basic Member
    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.