Connection Cleanup Tool

The Connection Cleanup tool improves performance by fixing or deleting invalid connections.

It looks for orphaned records in object tables (records that no longer have a parent record), then deletes the appropriate parent and child records.
It looks for “unpaired” connections (connection records that do not have two “sides,” or in other words, are not connected to anything), then deletes the connection records.
If a circuit is affected, its child objects are deleted or recalculated as needed.

If the application was properly configured from the beginning of your implementation and if users have been editing with the proper Fiber Manager tools, there should not be anything to clean up. Invalid connections are sometimes created if the application is not properly configured. For example, if the ArcFM Fiber Object Deleted Autoupdater was not configured for certain features, there could be orphaned records as fiber facilities were deleted in your database. Or, if users improperly deleted or split fiber facilities without using ArcFM/Fiber Manager tools, there could be invalid records.

IMPORTANT:

Before using this tool, back up your database.
This tool is hidden by default and must be first unlocked with a “key” from Support. Contact your Support representative to attain this key and discuss this tool. Your Support representative can also discuss fiber availability count options that can be recalculated with the tool at the same time it is deleting invalid records.
Run this tool first in an Esri version. After running the tool, perform your own QA/QC to validate that only expected records were deleted. This version is not used to reconcile and post the changes to the default (the number of records could be too voluminous for the post process). Instead, this test version is discarded, then you re-run the tool against the default version of the SDE database.
This tool should only be run by a database administrator and used with extreme caution. It deletes records as it runs, and therefore, you cannot cancel, undo, or back out of the operation once it has started.
Given the size of the database, this tool could run for several hours.

Although this is an administrative tool, you run it in ArcMap. Use Customize Mode to add the tool to your toolbar.

To use the Connection Cleanup tool:

Read all the points under the “Important” note above.
Create an Esri Version.

IMPORTANT: Even though you are in a version, there is no way to undo or back out of the operation once it starts. The Connection Cleanup tool saves its changes while they are made.
Click the Connection Cleanup tool.
1. If you have pending edits, you are prompted to save or discard them.
In the confirmation dialog, which states the operation cannot be undone, click Yes.
A dialog appears once complete. Use Windows Event Viewer to see the log file of the items that were processed. Ensure these items match your expected results.
Optionally, you can run the tool again within the same version to validate the results further. If the tool ran successfully, there should not be any new records discovered in the second pass. If new records were discovered, you should investigate them.
After validating the results, discard the version.
If you have not already, back up your database.
Repeat these steps against the default version of the SDE database.