topic Re: Data Deleting When Applying Asset Package in ArcGIS Utility Network Questions

Data Deleting When Applying Asset Package

Joshua_Moreno — Wed, 15 Oct 2025 06:24:53 GMT

Hello,

I am trying to stand up a test UN using Apply Asset Package or Asset Package to Geodatabase (tried both) and my data is deleting when completing. It is also taking over 2 hours to create the UN. Would this be because I am excluding certain configurations?

I am using the expanded model but only want to include primary and secondary distribution for electric.

I have about 20 assemblies and they completely delete when I check the assembly table in the UN.

Re: Data Deleting When Applying Asset Package

JohnAlsup — Wed, 15 Oct 2025 12:16:06 GMT

Are you using a D_Configuration table to define what the resulting UN should contain?

Re: Data Deleting When Applying Asset Package

MikeMillerGIS — Wed, 15 Oct 2025 12:19:41 GMT

In the AP Workspace folder, can you share the log file? When you say delete, the data or schema?

Re: Data Deleting When Applying Asset Package

Joshua_Moreno — Wed, 15 Oct 2025 15:24:53 GMT

Sure thing, I'll provide that shortly. It has been deleting data, schema stays the same.

Re: Data Deleting When Applying Asset Package

Joshua_Moreno — Wed, 15 Oct 2025 15:47:38 GMT

# Started: 2025-10-14 20:02:36.924769
arcpy.management.Append(
inputs="\\\\amznfsxpwrp9uab.coi.gis.org\\share\\Pro Projects\\Expanded Electric UN Model\\IPU Electrical Model\\IPU_Electrical_Asset_Package.gdb\\UtilityNetwork\\ElectricAssembly",
target="\\\\amznfsxpwrp9uab.coi.gis.org\\share\\Pro Projects\\Expanded Electric UN Model\\Test_IPU_UN.geodatabase\\UtilityNetwork\\ElectricAssembly",
schema_type="NO_TEST",
field_mapping=None,
subtype=None,
expression="NOT( (AssetGroup = 1 AND AssetType IN (0,1,2)) OR (AssetGroup = 2 AND AssetType IN (0,1,2)) OR (AssetGroup = 3 AND AssetType IN (0,41,42)) OR (AssetGroup = 4 AND AssetType IN (0,61,62,63,64,65,66)) OR (AssetGroup = 5 AND AssetType IN (0,81,82)) OR (AssetGroup = 6 AND AssetType IN (0,101,102,103)) OR (AssetGroup = 7 AND AssetType IN (0,360)) OR (AssetGroup = 8 AND AssetType IN (0,8)) OR (AssetGroup = 9 AND AssetType IN (0,121,122)) OR (AssetGroup = 10 AND AssetType IN (0,41,42,161,284)) OR (AssetGroup = 11 AND AssetType IN (0,181,182,183,184,185,186,187,188,189,190,191,192)) OR (AssetGroup = 12 AND AssetType IN (0,201,202,203)) OR (AssetGroup = 13 AND AssetType IN (0,360)) OR (AssetGroup = 14 AND AssetType IN (0,221,222,223,224)) OR (AssetGroup = 15 AND AssetType IN (0,241,242,243,244,245)) OR (AssetGroup = 16 AND AssetType IN (0,261,262,264,265,266,267,268,269,270,271,272)) OR (AssetGroup = 17 AND AssetType IN (0,281,282,283,284)) OR (AssetGroup = 18 AND AssetType IN (0,301,302,305,306,309,310,311)) OR (AssetGroup = 19 AND AssetType IN (0,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345)) OR (AssetGroup = 20 AND AssetType IN (0,290,291,292,293,294,295)) OR (AssetGroup = 21 AND AssetType IN (0,303,307)) OR (AssetGroup = 22 AND AssetType IN (0,304,308)) OR (AssetGroup = 24 AND AssetType IN (0,24)) OR (AssetGroup = 31 AND AssetType IN (0,91,92,93,94,95)) )",
match_fields=None,
update_geometry=None,
enforce_domains=None,
feature_service_mode=None,
)

'''
Start Time: Tuesday, October 14, 2025 8:02:37 PM
0 row(s) from \\amznfsxpwrp9uab.coi.gis.org\share\Pro Projects\Expanded Electric UN Model\IPU Electrical Model\IPU_Electrical_Asset_Package.gdb\UtilityNetwork\ElectricAssembly were appended to \\amznfsxpwrp9uab.coi.gis.org\share\Pro Projects\Expanded Electric UN Model\Test_IPU_UN.geodatabase\UtilityNetwork\ElectricAssembly
Succeeded at Tuesday, October 14, 2025 8:03:41 PM (Elapsed Time: 1 minutes 4 seconds)

Re: Data Deleting When Applying Asset Package

Joshua_Moreno — Wed, 15 Oct 2025 15:50:29 GMT

This is what I am seeing in the gp_calls.txt for the ElectricAssembly that is missing data. I will try to create a new configurations table and retry with a subset of the data to see if this happens still. Could it be that I was excluding certain default configurations that causes the "expression" query excluding the data?

Re: Data Deleting When Applying Asset Package

MikeMillerGIS — Wed, 15 Oct 2025 16:18:02 GMT

With a config table, it applies a sql query to exclude asset groups and types that are no longer valid in the target. If you run that query against your asset package(select by attribute), do you get any records?

Also, you will see much faster times running locally. Running with source and result on a network share drastically slows down performance.

Re: Data Deleting When Applying Asset Package

Joshua_Moreno — Wed, 15 Oct 2025 16:35:51 GMT

Just ran a select by attribute for Asset Group 18 and AssetType 309 which is what is contained in my data and it selected correctly. Could it be that the default configurations I selected is excluding this asset group and type?

Currently setting up the config table and see there are 32,000 rows to sift through. What would be the most efficient way to mark things as evaluated/keep when applied for items I want in my UN? Is it just a 1 by 1 task to find things using that correlate with my asset package? I see most things as "Ignored", should this be default to include everything?

I essentially want to remove anything but distribution and secondary, we're an all underground medium to low voltage system.

Re: Data Deleting When Applying Asset Package

MikeMillerGIS — Wed, 15 Oct 2025 16:48:39 GMT

According to the sql, which is NOT (AssetGroup = 18 AND AssetType IN (0,301,302,305,306,309,310,311)), the config table is removing that item.

Re: Data Deleting When Applying Asset Package

MikeMillerGIS — Wed, 15 Oct 2025 21:49:53 GMT

You should focus on subtypes, removing them, will remove the asset types(domain codes) and all related UN properties. So set all items in the subtype section that you do not want to Always Remove