How do I use the Pervasive Software Monitor Utility / Zen Monitor Utility to unlock a file on a server that uses a Windows operating system?
Description
Cause
Resolution

Unlock files on the workstation:

  • Reboot your workstation. If the error persists, follow the steps below.

Close microkernel sessions on the server:

WARNING: Do not use the Pervasive Software Monitor Utility / Zen Monitor Utility to delete users or active sessions while users are using a Sage 300 CRE or Sage Estimating application. This can cause corruption to the data. Be sure to also close, stop, or disable any other software applications you use that interface with Sage 300 CRE or Estimating, such as TimberScan, Paperless, Office Connector, Tech Tool, etc.

  1. If you are on version 17.1 or newer and using SQL Replicator or Mobile Projects, you must stop Replicating before performing these steps. Refer to How to stop Mobile Projects Replicator (SQL Replicator).
  2. Verify all users have exited all Sage 300 CRE and Sage Estimating applications.
  3. Launch the monitor utility:
    • Versions 24.1 and earlier: Go to Windows Start button, Actian PSQL 12, PSQL Monitor
    • Versions 24.2 and later: Go to Windows Start button, Actian Zen 15, Zen Monitor
  4. Click OK on the Select Server window.
  5. Click on the MicroKernel Sessions tab to view the opened sessions from each user. The Session column will display the Windows profile/user that has the session opened.
  6. Re-verify that the user has completely closed the software.
  7. Close open sessions as follows:
    • To close sessions for individual users: Right click on the row and select Delete MDKE session.
    • To close all open sessions: Click the Delete all sessions () button that is located in the top right-hand corner of screen. (Tip: If you hover over each icon, it will tell you it's function.) Then click OK on the message "This operation will also delete SQL Connection Manager users. Are you sure you want to delete all sessions?"
  8. Exit the PSQL Monitor.
  9. If using SQL Replicator or Mobile Projects, start Replicating again.

Need more help?

Chat now







Steps to duplicate
Related Solutions

How do I use the Pervasive Software Monitor utility (PMU/PSMU) to unlock or close a file on a remote file server from a workstation?
How to tell which Terminal Services user is accessing Pervasive/Actian files
Applications won't launch (files locked on server)