Dirty objects table

The dirty objects table is a system-maintained table used to store information about edits made to nonspatial objects and associations in a telecom domain network. This table is created when the first telecom domain network is added to a utility network. When a nonspatial object or association in the telecom domain network is modified, a row is created for each in the dirty objects table. This additional table is used with nonspatial objects in a telecom domain network due to the use of foreign-key fields to manage certain association types instead of using the Associations table.

The dirty objects table can be accessed as a subtable of the utility network from the Contents pane of an active map.

Each row in this table represents the status of edits made to nonspatial junction objects, edge objects, and associations in the telecom domain network. When the object is locatable, a dirty area is also created for the first spatial feature in the containment hierarchy, which allows you to validate the network topology for edits in the current extent.

The dirty objects table stores information about the following:

  • Whether nonspatial objects and associations have been modified or are in error in the telecom domain network.
  • The objects that participate in an association.

The dirty objects table contains the following attributes:

Field nameField aliasDescription

OBJECTID

Object ID

The object ID for the record in the table.

SOURCEID

Network Source ID

The network source for the dirty object in the utility network.

GUID

FeatureGuid

The global ID of the object or association represented by the dirty object.

STATUS

Status

The Status field value is used to communicate how the dirty object was created.

Learn more about how to interpret Status field values

ERRORCODE

Error code

Errors on dirty objects are displayed using a bit encoded value that can represent one or more errors.

ERRORMESSAGE

Error message

Additional contextual information associated with the error.

CLUSTERKEY

Cluster key

Enables improvement of object clustering in the network topology.

CREATIONDATE

Creation date

The date the dirty object was created.

CREATOR

Creator

The user who created the dirty object.

LASTUPDATE

Last update

The last time the row in the table was updated.

UPDATEDBY

Updated by

The last user to update a row in the table.

GLOBALID

Global ID

The global ID of the row in the table.

Interpret Status field values

The Status attribute field value indicates the type of modifications that have been made to an object or association participating in the telecom domain network. The values displayed in the attribute field represent decimal values that correspond to a bit encoded value. The following table outlines the status bit values and how they are presented in the Status field:

Status bitStatus field valueDescription

N/A

0

The object or association is not dirty or deleted.

0

1

An inserted or updated object or association.

1

2

The object or association is deleted.

2

4

The object or association is in error.

3

8

The circuit is in error.

Validate dirty objects

Validating the network topology maintains consistency between what you see on the map and what is in the network topology. Associations with spatial features are used to determine the location of, and visually represent, nonspatial objects on a map. The locatability of nonspatial objects is important because spatial features provide a mechanism to create dirty areas and validate edits.

When a locatable object, or an association with one, is created or modified, a dirty area is created for the first spatial feature in its containment hierarchy. With telecom domain networks, dirty objects are validated through these dirty areas. Analytic operations rely on the network topology and may return unexpected results if dirty areas or objects exist. No dirty areas are created as a result of edits made to an object that is unlocatable. As a result, these edits are not reflected in the network topology.

The Trace tool provides a Validate Locatability option to identify objects traversed during a trace without the necessary containment, attachment, or connectivity associations in their association hierarchy. When this is enabled and unlocatable objects are discovered, an error is returned that includes the class name and global ID of the objects for inspection. The Modify Associations pane can be used to create the necessary associations for the object to be considered locatable.

Reconcile and post dirty objects

When a version is reconciled, it inherits the current state of the network topology from the default version. Dirty objects are then re-created for all objects, and dirty areas are re-created for the associated features edited in the named version that resulted in a dirty object being created. Validating dirty areas and objects inherited by the version during reconcile allows you to continue work in a version but prevents posting until the version is reconciled again. When these dirty objects are posted, it allows the topology for these modified features to be validated and rebuilt in the default version.