Utility network upgrade history

To keep a utility network current with the latest functionality, an upgrade may be necessary. This applies schema changes to the utility network dataset, network feature classes, and other related geodatabase objects. Use the Upgrade Dataset tool to perform the upgrade.

Learn more about requirements for the upgrade process

An upgrade of the utility network dataset is needed to take advantage of new functionality introduced through schema changes in the information model. The version of the ArcGIS Pro client and current Utility Network Version determines whether an upgrade is available for the utility network dataset. The upgrade process increments the Utility Network Version number.

When working with an enterprise geodatabase, the version of ArcGIS Pro and ArcGIS Enterprise determines the version of the utility network dataset that is created or upgraded. To learn more, see Utility network compatibility.

Keep in mind that not every ArcGIS Pro and ArcGIS Enterprise release introduce schema changes, and an upgrade of the utility network dataset is not required when moving to a new release. Upgrading is only required to take advantage of functionality introduced in a new version of the utility network.

Upgrades are cumulative between versions and include changes from skipped versions. For example, if you update the utility network from Utility Network Version 3 to Utility Network Version 5, all schema changes for versions 4 and 5 are included. When upgrading a utility network dataset from version 3 or earlier, additional steps are required after the upgrade process. Review steps for each version included in the upgrade path.

Tip:

The version and upgrade history for a utility network can be viewed in the General section of the Network Properties tab.

Upgrade to Utility Network Version 7

Utility Network Version 7 introduces support for 64-bit Object IDs and big integer fields, the ability to perform directional traces using the Flow direction field, and a new field to support joins and advanced labeling and rendering workflows with network diagrams. Upgrading a utility network to version 7 performs additional tasks which includes dropping and recreating indexes on all utility network tables to support 64-bit Object ID and big integer fields. As a result, this process may take longer to complete.

Additional steps are required before upgrading a utility network to version 7:

  • When working with an enterprise geodatabase, ensure the geodatabase is upgraded. Utility Network Version 7 introduces schema modifications that include the addition of 64-bit object IDs and big integer fields. 11.2.0 is the minimum enterprise geodatabase version to support 64-bit object ID and big integer fields.

When upgrading a utility network to Utility Network Version 7, the following changes occur:

  • The Object ID field for all utility network classes are migrated to use 64-bit object IDs.
  • A new field, FLOWDIRECTION, is added to the Line and EdgeObject classes in the domain network and the StructureLine and StructureEdgeObject classes in the structure network. This supports the Use Digitized Direction parameter on the Trace and Add Trace Configuration tools to respect the digitized direction of the line, the From and To global ID on edge objects, and the Flow direction attribute value when performing upstream and downstream trace operations.
  • A new text field, Info, is added to the TMP_JUNCTIONS, TMP_EDGES, TMP_CONTAINERS, JUNCTIONS, EDGES, and CONTAINERS diagram classes to support joins and advanced labeling and rendering workflows.
  • The domain and coded value descriptions for the UN_<ID>_IsDirty domain are updated to communicate whether a subnetwork is (0: Clean), (1: Dirty), or (2: Invalid).
  • An alias of Status is set for the ISDIRTY attribute field in the SubnetLine feature class and Subnetworks table.
  • The ERRORCODE field in the dirty areas and associations tables is updated from a Double to a Big integer field data type.

Additional steps are required after upgrading a utility network to version 7:

Upgrade to Utility Network Version 6

Utility Network Version 6 introduces various internal updates that benefit users working with Network Diagrams.

When upgrading a utility network to Utility Network Version 6, the following changes occur:

  • The ASSOCIATIONTYPE field on the Associations table is set as a subtype field to improve performance when displaying diagrams and editing associations.

Additional steps are required after upgrading a utility network to version 6:

Upgrade to Utility Network Version 5

Utility Network Version 5 introduces the ability to create and work with named trace configurations and exposes additional options for configuring the subnetwork definition for a tier. For more information, see Set Subnetwork Definition.

When upgrading a utility network to Utility Network Version 5, the following changes occur:

  • A new field, SUPPORTINGSUBNETWORKNAME, is added to all domain network classes with the exception of the Assembly feature class.
  • A new table, UN_<ID>_TRACECONFIGURATIONS, is added to the utility network schema to support the creation, usage, and sharing of named trace configurations.

Additional steps are required after upgrading a utility network to version 5:

  • Review the service settings for existing utility network services after the upgrade. In the operations allowed section for the Utility Network capability, ensure all operations allowed are checked to include operations specific for ArcGIS Enterprise 10.9.
  • When upgrading a utility network dataset from version 3 or earlier, additional steps are required to incorporate cumulative changes made with utility network version 4. For more information, see the Additional steps required after upgrading a utility network to version 4 section below.

Upgrade to Utility Network Version 4

Utility Network Version 4 introduces a new dirty area model that incorporates error management and enables the ability to create and work with nonspatial junction and edge objects. Additional options are also exposed to configure the subnetwork definition for a tier. For more information, see Set Subnetwork Definition.

When upgrading a utility network to Utility Network Version 4, the following changes occur:

  • The point, line, and polygon error sublayers are removed and are no longer available as sublayers of the utility network layer.
  • The schema of the dirty areas and associations tables are modified to store error information.
    • The UPDATETYPE field is removed from the dirty areas table.
    • The STATUS field is now used in the dirty areas table to indicate the type of dirty area. This field is added to the associations table.
    • The ERRORCODE and ERRORMESSAGE fields are added to the dirty areas and associations tables.
    • A PERCENTALONG field is added to the associations table.
  • All dirty areas in named versions are truncated. This step is necessary to incorporate schema changes made to the dirty areas table. New dirty areas are generated after upgrade in the default version by enabling the network topology and performing a reconcile in all named versions.
  • The AssociationStatus domain is updated to include changes with the built-in feature restrictions of a utility network.
  • A nonunique attribute index is added on the SUBNETWORKNAME and SUBNETWORKCONTROLLERNAME fields of the Subnetworks table.
  • A new field, SUPPORTEDSUBNETWORKNAME, is added to all domain network classes. This field is used to store the subnetwork of features supported by features in the Assembly feature class.
    • The update subnetwork operation no longer updates the SUBNETWORKNAME field to store the subnetwork for features in the Assembly feature class.
    • During the upgrade, the SUBNETWORKNAME field is updated to no longer be system maintained; however, it is not deleted. While not required, this can be removed from the Assembly feature class to avoid confusion.
  • Additional subnetwork properties are stored for each tier:

    • Valid Junctions.
    • Valid Junction Objects.
    • Valid Edge Objects.
    • Valid Subnetwork Controllers now lists devices and junction objects that are set as valid subnetwork controllers.

  • A new code and description value are added to the system-provided UN_<ID>_IsDirty coded value domain (2: Invalid). This supports a new subnetwork status of Invalid on the Is dirty attribute when updating a subnetwork beginning with ArcGIS Pro 3.1, to indicate that conditions are present that prevent a subnetwork from being updated.

To model and work with a large number of real-world features that share a common geographical space, nonspatial junction and edge objects are introduced as part of the utility network schema:

  • For the structure network, the following tables are created:
    • StructureJunctionObject
    • StructureEdgeObject
  • For each domain network, the following tables are created:
    • <domain_network>JunctionObject
    • <domain_network>EdgeObject
  • The system-provided UN_<ID>_FeatureSourceID coded value domain is updated with the addition of the following code and description values for the structure network and each domain network:
    • <ID>—Structure Junction Object
    • <ID>—Structure Edge Object
    • <ID>—<domain_name> Junction Object
    • <ID>—<domain_name> Edge Object

Additional steps required after upgrading a utility network to version 4

  • Register the feature dataset that contains the utility network as branch versioned to version the new junction and edge objects. To learn more, see Register a dataset as branch versioned.
  • Enable the network topology.
  • Remove and re-add the utility network layer in existing maps to reflect the updated dirty area and error symbology.
  • Publish new services with an updated map that includes the nonspatial junction and edge object tables. You can do this by publishing new web feature layers or overwriting existing web feature layers.
  • Reconcile all named versions to regenerate dirty areas based on schema changes made during upgrade.

Upgrade to Utility Network Version 3

When upgrading a utility network to Utility Network Version 3, the following changes occur:

  • A new system-provided network attribute is added to the utility network. Flow direction is a hidden system-provided network attribute that is stored In Line; this was created to support future work with flow direction implemented with Utility Network Version 7.