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; } } }

Data Deleting When Applying Asset Package

JoshuaMoreno

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.

Find more posts tagged with

Accepted answers

MikeMillerGIS

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.

All comments

MikeMillerGIS

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

MikeMillerGIS

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.

JoshuaMoreno

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?

JoshuaMoreno

# 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)

JoshuaMoreno

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

MikeMillerGIS

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

JohnAlsup

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

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.