Solving a File Access Mode Error

As a Java guy, I'm conditioned to allow the JVM or an app server to handle freeing up resources. With Pervasive Data Integrator, you may have to take care of this yourself. I recently generated a "File access mode" error in a process on a RIFL FileRename() function. I verified all of the file arguments, but the error persisted.



FileCopy() worked fine, so I figured that the problem was with a DJImport object I was using which was the source of the FileRename() object. The DJImport was in a subprocess and appartently wasn't being freed when the subprocess finished. I set the DJImport object to "Nothing" in the end step and the problem went away.

In RIFL, the correct way to handle a DJImport object used throughout a subprocess is



' in Process Variables
' imp As DJImport

' in the start step
Set imp = New DJImport "Excel XP"

' in the end step
Set imp = Nothing


This post is replicated from http://my.opera.com/walkerca/blog/2010/12/18/solving-a-file-access-mode-error.