Feeder Manager Step 8: Initialize Electric Trace Weights

Initialize Electric Trace Weights prepares a new database for Feeder Manager functions by populating the field with the model name MMELECTRICTRACEWEIGHT; this field must also be associated with the MMElectricTraceWeight weight created when the geometric network is built. Initializing also adds to this field information found in bitgates.

TIP: If the Initialize Electric Trace Weights button doesn't appear on your ArcFM Solution toolbar, you may add it.

Before You Begin

Ensure your MaxLocksPerFile Registry settings are high values (200,000 for example). A low setting will cause errors during initialization. There are three MaxLocksPerFile entries in the Registry at the following locations:

  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Jet 3.5\

  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x\

  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0\

IMPORTANT:
  • The Initialize Electric Trace Weights function makes some assumptions about the database design; if that design deviates from the ArcFM standard database design in some key ways then it may be necessary to develop a customized version of the function.

  • Versioning: If possible, initialize trace weights before the dataset has been registered as versioned. If you choose to initialize trace weights on a dataset with versions, you could potentially encounter thousands of conflicts. If the dataset is already registered as versioned, consult with your database administrator and delete any versions and unregister the dataset as versioned. Refer to Esri documentation for more information.

How Geometric Networks Affect Initializing Electric Trace Weights

You can use the Initialize Electric Trace Weights function before or after creating a geometric network. However, it is recommended that you run Initialize Electric Trace Weights before creating the geometric network because the initialization process will be much faster. Running this function after creating a geometric network can be very slow.

TIP:
  • A geometric network icon will appear in the electric dataset if the network has already been created.

  • File Geodatabases: If you are using a file geodatabase, the Initialize Electric Trace Weight function requires a geometric network. You will need to ensure a geometric network exists in the file geodatabase before initializing the trace weights.

Initializing Trace Weights in SDE Geodatabases

If you are using the initialize Electric Trace Weights function on a dataset in an SDE geodatabase, it is highly recommended that you use it before registering the dataset as versioned and before you create a geometric network. If the dataset is versioned, it may require a significant amount of time to initialize trace weights. For example, the process could take several days for a dataset with more than 100,000 edges because of the overhead involved in updating weight-associated fields in a versioned database.

You can initialize trace weights in an SDE geodatabase when:

  • The dataset is not registered as versioned and does not have a geometric network.

  • The dataset is registered as versioned and has a geometric network.

You cannot initialize trace weights in an SDE geodatabase when:

  • The dataset is registered as versioned but does not have a geometric network.

  • The dataset is not registered as versioned but has a geometric network

Function Availability

Below is a table that describes when the Initialize Electric Trace Weights function is available in each type of geodatabase.

Geodatabase Type

Geometric Network

Registered as Versioned

Initializing Trace Weights Available

personal

no

n/a

yes

personal

yes

n/a

yes

file

no

n/a

no

file

yes

n/a

yes

SDE

no

no

yes

SDE

no

yes

no

SDE

yes

no

no

SDE

yes

yes

yes

Initialize Trace Weights With NO Geometric Network

This procedure applies to personal and SDE geodatabases and cannot be performed on file geodatabases. Initializing trace weights before creating the geometric network is much quicker than initializing with the network already created. To initialize trace weight values before the network is created:

IMPORTANT: Dropping geometric networks and deleting versions may have dire consequences. Before doing either of these, consult with your Database Administrator and refer to Esri documentation.
  1. Ensure a geometric network does not exist.
    If a geometric network does exist but you want to initialize the dataset without the geometric network; drop the geometric network and compress the geodatabase.
  2. If initializing an SDE geodatabase, check whether the dataset is registered as versioned.
    If the dataset is registered as versioned, delete any versions and unregister the dataset as versioned. 
  3. Select the electric dataset.
  4. Click the Initialize Electric Trace Weights button.
  5. A dialog box will display the feature classes that will be updated. Only feature classes containing a field with the MMElectricTraceWeight field model name will be affected. Click Yes to proceed or No to cancel.
  6. When you run Initialize Electric Trace Weights without a geometric network, Feeder Manager creates the following .txt files. 
    • FdrMgrWeightInitSQL.txt is a log file of all SQL statements that were used to update the tables.

    • FdrMgrWeightInitLastStatement.txt stores only the last SQL statement that executed successfully. If this statement matches the last statement in the FdrMgrWeightInitSQL.txt file, then Initialize Electric Trace Weights executed successfully.

    In Windows XP, Windows Server 2003 and Windows Server 2003 R2, these files are stored in the following directory: Documents and Settings\[User]\Application Data\Miner and Miner\ArcFM. In Windows 7, Windows Server 2008 and Windows Server 2008 R2, these files are stored in the following directory: Users\[User]\AppData\Roaming\Miner and Miner\ArcFM.

Initialize Trace Weights With a Geometric Network

If you do choose to initialize weight values after the geometric network has been built, it is recommended that you disable Feeder Manager's tracing autoupdaters.

To initialize trace weight values after the network is created:

  1. Disable Feeder Manager's tracing autoupdaters.
    1. Right-click the geometric network and select Feeder Manager | Settings.
    2. Uncheck the Tracing Autoupdaters Enabled field. Do NOT disable the weight autoupdater while initializing trace weights when a geometric network exists.
    3. Click Save. The change is effective immediately, without the need to restart ArcCatalog.
  2. Select the electric geometric network feature class.
  3. Right-click and select Feeder Manager | Initialize Electric Trace Weights.
  4. Check the event log. If it shows no errors, trace weights were successfully initialized. 

Initialize a Dataset Registered as Versioned and With a Geometric Network

This procedure applies to only SDE geodatabases. Before using this procedure, be aware that initializing trace weights when the network already exists and the dataset is registered as versioned could take a significant amount of time and generate several conflicts.

TIP: If you must use this procedure, consider deleting all versions before starting.
  1. Ensure that the dataset is registered as versioned. 
  2. Select the electric geometric network feature class.
  3. Right-click and select Feeder Manager > Initialize Electric Trace Weights.  
  4. Check the event log. If it shows no errors, trace weights were successfully initialized. 
QR code for this page

Was this helpful?