English

Error: The process cannot access the file because it is being used by another process

Error Message

When running the ArcSDE for PostgreSQL Post Installation wizard to create a second geodatabase in the PostgreSQL database cluster, the following error messages are returned:

“The process cannot access the file because it is being used by another process.
C:\program files\postgresql\8.3\\lib\st_geometry.dll”.

“The process cannot access the file because it is being used by another process.
C:\program files\postgresql\8.3\\bin\sg.dll”.

“The process cannot access the file because it is being used by another process.
C:\program files\postgresql\8.3\\bin\pe.dll”.

Cause

These errors occur when running the Post Installation wizard to create a second geodatabase in the PostgreSQL database cluster if, at the same time, an ArcSDE client application, such as ArcMap, ArcCatalog, or ArcIMS, is displaying data from another geodatabase on that same database cluster.

During setup, the Post Installation wizard copies three ArcSDE libraries (DLLs) from %SDEHOME% to the location where PostgreSQL resides. Those libraries are ArcSDE client libraries: st_geometry.dll, sg.dll, and pe.dll. If an active client connection is displaying data, those library files are in use. When the Post Installation wizard attempts to paste the library files into the PostgreSQL installation directory, it fails because it cannot overwrite files that are already in use.

Solution or Workaround

Close the client application that is displaying data from the first geodatabase and continue with the Post Installation wizard to create the second geodatabase.