How to load all UN components in a deployed UN schema?

Question

Hello,

We have an asset package with very huge data, 10 million records each in few Structure Feature Classes, and in few of the electric feature classes. When we tried deploying the asset package:

* Stage Utility Network --> Works
* Apply Asset Package --> Keeps on executing for 6 days and finally fails

We then tried another approach:

* Stage Utility Network --> Works
* Apply Asset Package (Without Load Data)--> Works

As of now we can see that it shows network rules under Network Properties. So, is it just the data and associations that we must take care which we left out?

Now, how should we proceed? What is the best approach to load all the data, associations and other components(that apply asset package without load data does not brings in) making it exactly work as it would if we would have applied the asset package with load data?

Any thoughts on this would be helpful.

GIS_kiwi4 · Answer

@Yogesh_Chavan - 10 million records is big but it's not "6 days of processing" big. 
Is there anything in the failure message that might suggest the root cause?

If the Apply Asset Package works without loading data then I think you can rule out any config errors (rules, tier definitions, etc)

It could be something much simpler that could be getting in the way of loading the data.
I am assuming you are trying to load data to an eGDB. 
Couple of things to check here - possibly pointing to network issues.

1) Can you load data while applying the asset package to local mobileGDB?
If yes, that confirms the AP, data, the tool are working as expected.

2) How is Pro connecting to eGDB? 
If you are using Pro locally but have a direct database connection to DB server in the cloud then it's not optimal. Try and run Pro on the same/adjacent machine next to the DB server. We have noticed loss of connection trying to keep the directDB connection open for long transactions.

3) Ensure the data you are trying to load is on local drive as your Pro.

4) Batch load data = Try first 1million records for each feature class or Maybe load one feature class at a time.

NOTE - When using append tools - you can run into issues where connection vertices are not created on intersecting features which means they are not "connected"

https://community.esri.com/t5/arcgis-utility-network-questions/load-data-into-existing-un/m-p/1563577#M4610

https://community.esri.com/t5/arcgis-utility-network-questions/snapped-features-not-creating-vertex-when/m-p/1561246#M4573:~:text=This%20is%20as,integrate%20can%20help.

Isaac_King · Answer

A behavior I have established as mandatory in my own projects is to first apply the asset package WITHOUT data and then apply again with data. It's possible (arguably expected) that the first time you go to apply an asset package, you will encounter some type of minor error that needs to be addressed. It is MUCH quicker to find this error if you apply without loading data. I would start here.

Once you've successfully applied an asset package without data, I would still try to load the data via apply AP. You are working with a lot of records, so any process within Pro is going to take quite a bit of time to run in its entirety. If you still run into issues, or you've just had enough of this issue - you could use a simple Append function to load each feature class individually.

I must stress the importance of successfully applying your asset package first though! Good luck!