Data Deleting When Applying Asset Package

[Joshua_Moreno]

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.

[JohnAlsup]

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

[MikeMillerGIS]

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

[Joshua_Moreno]

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

[Joshua_Moreno]

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

[Joshua_Moreno]

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? 

[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.

[Joshua_Moreno]

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.

[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.

[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