Using the CHKLCLEANUP Utility in ProjectWise [TN]


	Applies To

	Product(s):	ProjectWise Administration
	Version(s):	V8i (08.11.07.xx+)
	Environment:	N/A
	Area:	N/A
	Subarea:	N/A
	Original Author:	Bentley Technical Support Group

Overview

ProjectWise keeps track of all the files that have been checked out, copied out or exported via the dms_chkl table in the ProjectWise database. This table can accumulate orphan records that generally do not cause any problems. The table can be cleaned up should one of the following issues occur:
·         A user has many files checked\copied out and their system crashes beyond repair.
·         Users using the same machine have the same ProjectWise working directory. When one user tries to checkout a file that the other user has copied out, he may get an error. "working directory is in use"...

The dms_chkl tracks what files have been checked out, copied out, or exported, by username and node name.

The 08.11.07.107 version of ProjectWise delivers a utility to help users cleanup the dms_chkl table. The utility, chklcleanup.exe, gets installed as part of the ProjectWise Administrator and must be run from the C:\Program Files\Bentley\ProjectWise\bin directory as it needs required libraries from this folder.

Currently the utility only works with 08.11.07.xx + datasources and will not find 08.11.05.xx datasources.

*** Note:
·         There is no audit trail option to record these actions.
·         This utility only cleans up the database and does not delete the files from the physical machines they were original copied out too.

Preliminary steps
1.       Have the users whose entries you will be deleting check all files in.
2.       Purge their working directories via the local document organizer.
3.       Log out of the system.
4.       Have the users delete their working directories.

Steps to run the CHKLCLEANUP.EXE
1.       On a system that has the ProjectWise Administrator installed, Open Windows Explorer and navigate to C:\Program Files (x86)\Bentley\ProjectWise\bin
2.       Double click the CHKLCLEANUP.EXE
3.       Click next on the welcome screen
4.       You are then prompted to choose and log into a datasource.
5.       The next screen gives you the choice to “remove copy out locations” by username or by machine name
6.       If you check user name the next screen lists all the users in the datasource. Check the names you wish to remove the copy out entries for.
a.       There is an option to export the list to a cvs file. This option gives the User Name, User Description, and Document Count, in a comma delimited file.
b.      Another option on this page is explained as follows: Some DMS_CHKL location records may be left over after removing users, use this option to remove these orphan rows.
7.       If you checked Machine name, the next screen lists all the machines listed in the dms_chkl table in the datasource that have files copied out. Check the machine names you wish to remove the copy out entries for.
a.       There is an option to export the list to a cvs file. This option gives the Machine Name and Document Count in a comma delimited file.
8.       On the next screen you are given a summary of your choices and asked to confirm that you want to delete the copy out location entries.
9.       The final screen will give a message that the wizard has succeeded and a report of how many entries were deleted.
10.   Bentley Recommends to have unique working directories for each user. Create a new unique working directory for the user via the PW administrator.
11.   Allow the user to log back into the system and make sure the new working directory was created correctly.