nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to apply revised asset package to the same utility network

Song_Li

Hi, I have staged a UN on SDE and applied one Asset Package to it. One of my colleague made some updates to the Asset Package and I want to incoorpate all the changes made. What's the easiest way to do this? Here are the options I am thinking:

1. wipe out the existing SDE (not sure how to do it in ArcPro) and restage the UN

2. Apply the revised asset package to the same UN

3. Compare and find out the changes, is there tool to compare Asset Packages?

Thanks,

Song

Find more posts tagged with

Accepted answers

DanielSimo

Hi @Song_Li

The below is the workflow that I currently use:

Delete the UNM Enterprise Geodatabase via SQL Server Management Studio (i.e. in SQL Server Management Studio, right-click the database and click Delete).
Create a brand-new Enterprise Geodatabase in SQL Server.
Create a UNOWNER in the new Enterprise Geodatabase.
Stage a Utility Network in the new Enterprise Geodatabase.
Apply the revised Asset Package to the new Enterprise Geodatabase.

I hope that helps. Regards

All comments

VishApte

Hi Song,

If you have already applied Asset Package to EGDB/SDE, correct method to make changes is

1. Use Utility Network admin tools to make changes.

2. Export the model as Asset Package for future use.

If you need to make whole lot of changes, changing asset package might be easier. To redeploy, the easiest way I find is to drop the entire geodatabase but if it is shared with other feature classes then you need to disable and drop the Utility Network Topology first and then drop the UN dataset and related tables that participate in the topology.

Song_Li

Thanks Vish, I have already applied Asset Package to EGDB/SDE. I can make change with UN admin tools, but they are super slow. Hence I would rather make the changes in File Geodatabase or directly to the Asset Package.

How do you drop the entire geodatabase? is there a tool in ArcPro to reset? or we need to reset it in SQL Server?

Thanks,

Song

AngeloCirocco2

Hi Song & Vish,

We have worked with modifying the UN data model from a EnterpriseGDB -> AssetPackage -> Enterprise GDB over a number of iterations.

We found that in addition to dropping the UN datasets and tables; we needed to ensure all the UN related domains were also removed; otherwise we would get strange errors during applyassetpackage.

Song_Li

Thanks Angelo, how do you drop the EnterpriseGDB? by deleting the dataset and all tables in ArcGIS Pro? Simply "stage UN" comes back with an error message. Cheers, Song

AngeloCirocco2

Hi Song,

If it is possible to revert back to an empty database with SQL Management (i.e. prior to enabling the Enterprise GDB) this would be preferable.

Otherwise if this is not possible (as was our case) after disabling the UN topology; we needed to delete the UN dataset (containing the domain featureclasses and UN topology entity); and the nonspatialobject tables for each domain using the delete data management tool. Then we had to iterate over all the domains in a python script to remove the numerous UN domains (all out domains where UN related in our EGDB). Only then could we call stageUN and applyAP tools again to repopulate using a modified data model.

Note we have only used this technique to prototype upgrading to UN v5 in a staging environment were this this process worked for us, but if you are getting errors from the tools I would think esri tech support may need to assist you.

DanielSimo

Hi @Song_Li

The below is the workflow that I currently use:

Delete the UNM Enterprise Geodatabase via SQL Server Management Studio (i.e. in SQL Server Management Studio, right-click the database and click Delete).
Create a brand-new Enterprise Geodatabase in SQL Server.
Create a UNOWNER in the new Enterprise Geodatabase.
Stage a Utility Network in the new Enterprise Geodatabase.
Apply the revised Asset Package to the new Enterprise Geodatabase.

I hope that helps. Regards

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.