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.

附加信息

解决办法

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.

重现步骤