"Building block is in use or locked by user xxx" in FRx

Entry Type: Informational

Product: FRx

Application: FRx Desktop

Version Reported: 5.5

Subject:
"Building block is in use or locked by user xxx" occurs in FRx.

Possible Resolution:

Resolution 1: Verify that the building block is not open on another computer. If it is, wait for the user to finish, or have the user close the building block.

Resolution 2: In FRx select File / Close All. This closes all open rows, columns, trees, and catalogs.

Resolution 3: Compact the current spec set database. to remove all lock tags from the database.

Note: Users must have exclusive use of FRx to compact any file.

1. In FRx, select Company / Specification Sets.
2. Note the location and file name for the specification set (.f32 file). 
3. Make a copy or backup of the specification set file.
4. Log on to FRx, and log all other out of FRx.
5. Select File / Compact FRx Database.
6. Select 'Current Spec Set Database'. This should reset locking information on the database.
7. If the error persists, delete any .LDB files located in the ..\Sysdata\ folder with the same name as the spec set database. LDB files contain database record locking information. These files can be deleted without harming the FRx database files. The .LDB files are regenerated when a program or user accesses the database file.