Issue with 50000+ associations

Question

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

MaartenTromp_SSO · Answer

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.

mrasiukevicius · Answer

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.