Product(s):	Bentley Raceway and Cable Management
	Version(s):	08.11.08.09
	Environment:	N/A
	Area:	Collaboration Manager
	Subarea:	N/A

Collaboration Manager indicates some resources are locked when the user that locked them no longer has the software open, preventing other users from using those resources. How do I unlock the resources?

Background

This indicates Bentley Raceway and Cable Management was stopped before a normal exit and the the database was not updated to release locked resources. This can occur after BRCM is closed by Task Manager or by a crash.

Steps to Accomplish

Option 1

See if the user that locked the resources can open the project and release the locks using Collaboration Manager.

Option 2

1. Use SQL Server Management Studio to connect to the SQL Server hosting the BRCM database.

2. Create a new View in the database and add the table ending in  "_INT_RLTC" that belongs to the project in question. The table name will begin with the BRCM_DB_ID value for the project. This value is found in the .PCF file for the project or as a ProjectWise project property and may not match the project's folder name.

3. Select all columns in the table and execute the query.

4. Find and delete the appropriate row(s) in the returned results. The LOCKED_BY column will contain BRCM_DB_STATIONID values. The BRCM_DB_STATIONID value can be set in the .PCF file. In a ProjectWise environment BRCM_DB_STATIONID is often configured to equal the machine name, so look for the machine name of the workstation used by the user that locked the resources.
   
   Alternatively, have all users close the software and delete the rows that remain in the "_INT_RLTC" table for the project.

Original Author:

Matt_P

Keywords: Update Physical, lock