topic Re: Issue with 50000+ associations in ArcGIS Utility Network Questions

Issue with 50000+ associations

MaartenTromp — Sun, 12 Jul 2020 19:44:50 GMT

Has anyone been able to load 1.5 million+ associations? In an Enterprise Geodatabase it is possible to do ApplyAssetPackage and EnableTopology. But ValidateTopology crashes when edits are made that are connected to the existing network.

In an UNM FileGeodatabase ArcGIS Pro crashes, also when called from a python script.

Datasets with a maximum of 50000 associations seem to work fine.

We tested with Pro 2.4.3 with ArcGIS Enterprise 10.8.0 and Pro 2.5.2 with ArcGIS Enterprise 10.7.1

Any ideas on this?

Kind regards, Maarten Tromp

Re: Issue with 50000+ associations

mrasiukevicius — Mon, 13 Jul 2020 05:27:01 GMT

Can confirm that we have successfully loaded 800k associations into Enterprise Geodatabase on ArcGIS Enterprise 10.7 and 10.8 using ArcGIS Pro 2.5.1

Noticed one issue: association load operation performs N times faster if there are no relationships between UN FeatureClasses.

So we are dropping relationships in AssetPackage that contains data to load. And after data load, re-applying same AP SCHEMA_ONLY with relationships.

Re: Issue with 50000+ associations

MaartenTromp — Mon, 13 Jul 2020 15:26:19 GMT

TXS for your remark! If loading can be faster by doing that it would be nice. I will try.

The issue seems NOT related to the total number of associations, they indeed load slow but fine. But when Validating Topology on a part of the network that:

1: Connects to associations with many (max 500) associations to 1 junction

and/or 2: Connect to associations to/from junctions that are also pointerrors (stacked points).

and/or 3: Connect to part of the network that contains 1000+ errors.