Related
Recommended

CHKLCLEANUP Utility

ProjectWise keeps track of what files have been checked out, copied out, or exported, by username and node name in the dms_chkl table. Many times for various reasons entries into this table can get orphaned. If users share a machine and same ProjectWise Working Directory, this can cause issues with one user seeing "working directory in use".

There is a new utility available in 08.11.07.107 that will clean up old or orphaned records in the dms_chkl easily. This utility is called CHKLCLEANUP.

This utility was introduced in 08.11.07.107 and gets installed as part of the ProjectWise Administrator and must be run from the C:\Program Files\Bentley\ProjectWise\bin directory.

Chklcleanup only works with 08.11.07.xx datasources and will not find 08.11.05.xx datasources. 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.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\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.
    1. 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.
    2. 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.

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.

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.

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.

The final screen will give a message that the wizard has succeeded and a report of how many entries were deleted.

Bentley Recommends to have unique working directories for each user. Create a new unique working directory for the user via the PW administrator.

Allow the user to log back into the system and make sure the new working directory was created correctly.

See the Using the CHKLCLEANUP Utility in ProjectWise [TN] wiki article for more information on running this utility.

JP

  • Offline

    Utility refers to the usefulness or practicality of something in fulfilling a particular purpose or function. Whether it's the efficiency of a tool, the convenience of a service, or the effectiveness of a solution, utility is paramount in determining value. Businesses strive to optimize utility in their products and services to meet consumer demands and stay competitive. This pursuit often involves rigorous assessment and improvement processes, such as those observed in north american power reviews where the efficacy and reliability of energy providers are evaluated to ensure maximum utility for consumers.

  • Offline

    Is the chklcleanup.exe still a usable tool going forward to CONNECT or is here a better tool for cleaning p the database for orphan rows?

  • Offline

    On the preliminary steps, it is not an absolute requirement to check all files in first. the CHKLCLEANUP utility will ignore entries in the dms_chkl table for checked out or exported documents. This is only important if you want to physically delete your working directory as part of this process.

    The option for removing orphan rows for previously deleted users should only need to be run once.  Since ProjectWise V8 XM Edition, ProjectWise has automatically purged those records when the user is deleted.  However, you may have left over entries that need to be purged now if your datasource was used with ProjectWise version prior to V8 XM Edition.

Communities
Support and Services
Training and Learning
Social Media