Orphaned Versions Clean Up Tool

This tool cannot be used on an Access database.

Sessions and designs are similar in that they have GIS components in addition to their records in the Process Framework database. Both sessions and designs (and in some cases, work requests) have corresponding versions. Sessions and designs also have a corresponding stored display. When a session or design is deleted, their associated versions and stored displays will need to be deleted as well.

When you delete a node such as a session, design, or work request from Session Manager or Workflow Manager, the deletion must be accurately reflected in ArcMap. The GIS components are deleted in the Process Framework extension, and the corresponding version in ArcMap is flagged for deletion. This flag marks the version as "orphaned" in the geodatabase.

This tool also removes any temporary post versions (appended with _MMPOST) which cannot be deleted. This temporary version exists until the design is deleted. If the design isn't deleted, the temporary version remains indefinitely. This tool also cleans up these temporary versions. These versions should be cleaned up regularly if you're using Designer.

To use this tool, follow the steps outlined below.

Login into the geodatabase as SDE. The user you login with must have permissions to delete any versions. For example, if you login as ARCFM, only versions owned by ARCFM may be deleted. The SDE user has permissions to delete any versions.
Click the ArcFM Orphaned Versions Clean Up button.
If this is the first time you've used this tool on the current geodatabase, you will be prompted to log into Process Framework as well. Use a login that has permissions to access the Process Framework database.

An Orphan Versions Cleanup log will display the number of orphans removed and any errors if they occurred.

To clean orphans from another geodatabase, you will need to close ArcCatalog, re-open it, and select the Orphaned Versions Clean Up tool again.