Select to view content in your preferred language

Source tables missing in Prune Branch History tool

145
0
02-16-2026 06:40 AM
BogdanHristozov
Regular Contributor

Hi,

I have a geodatabase in Postgresql, with Utility Network deployed (ArcGIS Pro 3.5, ArcGIS Enterprise 11.5). I'm using the Prune Branch History tool to clear old archiving records, but noticed that some of the UN tables are missing from the log files. Here is the complete log file and you can see the ElectricDevice and ElectricLine tables are missing (rel. class ElectricLine__StructureJunction appears twice):

[2/16/2026 6:12:56 AM] Prune moment: 2/16/2026 2:12:56.769 PM
[2/16/2026 6:12:56 AM] Reporting how many rows would be pruned from each table.
[2/16/2026 6:12:57 AM] Would prune 0 rows from dg.ga.StructureBoundary__CircuitSource
[2/16/2026 6:12:59 AM] Would prune 0 rows from dg.ga.StructureBoundary
[2/16/2026 6:12:59 AM] Would prune 0 rows from dg.ga.StationEquipment
[2/16/2026 6:12:59 AM] Would prune 0 rows from dg.ga.CircuitSource
[2/16/2026 6:13:01 AM] Would prune 0 rows from dg.ga.StructureJunction
[2/16/2026 6:13:02 AM] Would prune 0 rows from dg.ga.ElectricLine__StructureJunction
[2/16/2026 6:13:02 AM] Would prune 0 rows from dg.ga.ElectricLine__StructureJunction
[2/16/2026 6:13:10 AM] Would prune 0 rows from dg.ga.PoleEquipment
[2/16/2026 6:13:10 AM] Would prune 0 rows from dg.ga.StructureJunctionObject
[2/16/2026 6:13:10 AM] Would prune 0 rows from dg.ga.StructureLine
[2/16/2026 6:13:10 AM] Would prune 0 rows from dg.ga.StructureEdgeObject
[2/16/2026 6:13:10 AM] Would prune 0 rows from dg.ga.ElectricAssembly
[2/16/2026 6:13:14 AM] Would prune 0 rows from dg.ga.ElectricJunction
[2/16/2026 6:13:14 AM] Would prune 0 rows from dg.ga.ElectricJunctionObject
[2/16/2026 6:13:14 AM] Would prune 15 rows from dg.ga.ElectricSubnetLine
[2/16/2026 6:13:14 AM] Would prune 0 rows from dg.ga.ElectricEdgeObject
[2/16/2026 6:13:18 AM] Would prune 6388 rows from dg.ga.UN_6_Associations
[2/16/2026 6:13:18 AM] Would prune 0 rows from dg.ga.UN_6_Diagrams
[2/16/2026 6:13:18 AM] Would prune 0 rows from dg.ga.UN_6_Aggregations
[2/16/2026 6:13:18 AM] Would prune 0 rows from dg.ga.UN_6_Relations
[2/16/2026 6:13:18 AM] Would prune 0 rows from dg.ga.UN_6_Edges
[2/16/2026 6:13:18 AM] Would prune 0 rows from dg.ga.UN_6_Junctions
[2/16/2026 6:13:18 AM] Would prune 0 rows from dg.ga.UN_6_Containers
[2/16/2026 6:13:18 AM] Would prune 0 rows from dg.ga.UN_6_Rules
[2/16/2026 6:13:18 AM] Would prune 13873 rows from dg.ga.UN_6_Subnetworks
[2/16/2026 6:13:19 AM] Would prune 90548 rows from dg.ga.UN_6_DirtyAreas
[2/16/2026 6:13:21 AM] Would prune 8 rows from dg.ga.UN_6_SystemJunctions
[2/16/2026 6:13:21 AM] Would prune 4233 rows from dg.ga.UN_6_Topology
[2/16/2026 6:13:21 AM] Would prune 0 rows from dg.ga.UN_6_JunctionWeights
[2/16/2026 6:13:21 AM] Would prune 29 rows from dg.ga.UN_6_EdgeWeights
[2/16/2026 6:13:21 AM] Would prune 30 rows from dg.ga.UN_6_Props
[2/16/2026 6:13:21 AM] Would prune 0 rows from dg.ga.UN_6_WeightDefs
[2/16/2026 6:13:47 AM] Would prune 22514 rows from dg.ga.UN_6_EIDMappings
[2/16/2026 6:13:47 AM] Would prune 381 rows from dg.ga.UN_6_ElementAssociations

arcpy.management.PruneBranchHistory(
    in_dataset=r"D:\Projects\GISROP-DG\TargetDatabase\ga@dg.sde\dg.ga.UtilityNetwork",
    out_log=r"D:\Projects\GISROP-DG\test.txt",
    report_only="REPORT_ONLY",
    system_tables_only="ALL",
    prune_before_date=None
)

 

What could be the reason for that?

Editing is working fine, as well as UN specific tasks such as update subnetwork and tracing tasks. 

0 Kudos
0 Replies