laptop and a wrench

Bug

Association records in which the primary or secondary features do not exist in the DEFAULT version lead to the Enable Network Topology tool crashing or returning a misleading error.

Last Published: June 3, 2021 ArcGIS Pro
Bug ID Number BUG-000137860
SubmittedMarch 2, 2021
Last ModifiedJune 25, 2025
Applies toArcGIS Pro
Version found2.4.2
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusWill Not Be Addressed

Additional Information

We apologize that we were unable to address this issue within the current product support cycle.  If the issue continues to affect your work in a supported release, please contact Technical Support.

Workaround

Use SQL to determine which associations are orphaned, and then clean them up via the feature service using ArcGIS Pro:

1) Identify all unique networksourceid values present in the association table. For example:

select distinct fromnetworksourceid from <OWNER>.un<_DSID_>associations where GDB_BRANCH_ID = 0

select distinct TONETWORKSOURCEID from <OWNER>.un<_DSID_>associations where GDB_BRANCH_ID = 0

2) Use the <UN name>_<UN_ID>_FeatureSourceID coded value domain to determine which feature classes/internal UN tables to which these networksourceid values correspond.

3) Use nested SQL statements to search for any globalids existing in the association table, but not existing in the corresponding networksourceid table. For example:

--default only from network source id

select objectid from <OWNER>.un<_DSID_>associations where gdb_branch_id = 0 and fromnetworksourceid = 6 and fromglobalid not in (select globalid from <OWNER>.<DOMAINNAME>DEVICE where GDB_BRANCH_ID = 0)

 

select objectid from <OWNER>.un<_DSID_>associations where gdb_branch_id = 0 and fromnetworksourceid = 8 and fromglobalid not in (select globalid from <OWNER>.<DOMAINNAME>ASSEMBLY where gdb_branch_id = 0)

 

select objectid from <OWNER>.un<_DSID_>associations where gdb_branch_id = 0 and fromnetworksourceid = 9 and fromglobalid not in (select globalid from <OWNER>.<DOMAINNAME>JUNCTION where gdb_branch_id = 0)

 

--default only to network source id

 

select objectid from <OWNER>.un<_DSID_>associations where gdb_branch_id = 0 and TONETWORKSOURCEID = 6 and TOGLOBALID not in (select globalid from <OWNER>.<DOMAINNAME>DEVICE where GDB_BRANCH_ID = 0)

 

select objectid from <OWNER>.un<_DSID_>associations where gdb_branch_id = 0 and TONETWORKSOURCEID = 7 and TOGLOBALID not in (select globalid from <OWNER>.<DOMAINNAME>LINE where GDB_BRANCH_ID = 0)

 

select objectid from <OWNER>.un<_DSID_>associations where gdb_branch_id = 0 and TONETWORKSOURCEID = 9 and TOGLOBALID not in (select globalid from <OWNER>.<DOMAINNAME>JUNCTION where GDB_BRANCH_ID = 0)

 

4) Users have a list of objectids of associations. Delete them by adding the UN feature service to ArcGIS Pro. Open the association table, select by attributes, and then delete the rows.

Steps to Reproduce

Bug ID: BUG-000137860

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options