1) The XPA ledger is locked, and when attempting to open it, an error message appears:
[User Name] has sole access to this ledger.
The file was logged out on [date the ledger was locked].
This can happen if the XPA file was in use when an event occurred, such as the PC crashing or a connection to the server being lost.
2) Error: Log File not found.
As there are multiple ways to unlock an XPA file, please start with option one and continue on to the next only if required.
Option One: Ask the user who locked the file to unlock it
APS main menu, open XPA, go to File, Open / Select.
Right-click on the file and select Log file In/ unlock
The user may no longer be an employee - In that case, log in as the user and open the XPA ledger. This will enable the ledger to be closed properly when closing out of the file.
Option Two: Remove lock from Log Maintenance
Use this option if the user sign-on is not available to unlock the file, or the lock cannot be removed in Option 1.
Ensure the user is logged out of all APS products before continuing
Open Client Console / Central Console
On the menu bar, click on Action, Extract Log Maintenance.
If this option is not available, please activate the JOE rights for the user: JOE Rights, Advanced Actions, and Extract Log Maintenance.
After activating the JOE access rights, identify the correct XPA user currently locking the file - note that the file names will not be displayed
Right-click and click on Remove log.
Option Three: Delete the log file manually
If the file is not in the Log or removing the Log did not unlock the file, locate the directory where the files are located and delete the .ldb file with the same name as the .XPA file. WARNING: Make sure not to delete the .XPA file
Option Four: Rename the file to create a new registry
In XPA, delete the XPA link.
In Windows, create a copy of the .XPA file (with a different name from the original file).
Merge the copy file into XPA.
This process will make the renamed ledger available in your XPA application to enable you to review it.
From XPA, save the copy file (Save as) with the original file name.
Close the ledger.
Check the ledger with the original name re-opens.
Delete the copy from XPA.
Link the new (original) ledger to the client console.
Option Five
On the file server, select Control Panel, Administrative Tool, Computer Management.
Select Shared Folders, Open Files. The RH side of the Computer Management screen will list all open files on the server.
Sort the files based on Name.
Locate the affected ledger and the .ldb file in the list of open files.
Right-click and select to Close the open file.
Go back into the ledger on the user's PC, and the tables will now be unlocked.
Option Six: If you can't locate the .ldb file in Windows Explorer
Copy and paste the XPA ledger so that it creates a COPY within the folder.
Merge in the COPY of the ledger.
Save the COPY over the top of the original.
Delete the COPY file (optional).