Hello, I am trying to port over an 10.3.1 script which used the old geometric network functionality in Python scripting. I am running ArcGIS Pro 2.6.2. In my script, I am creating multiple trace networks to set up a cleaned watercourse network for further hydrology and DEM processing (burning and flow directions etc). It creates the first network (wc_clean_net) to find connected segments (isolated segments are dropped) and enables the network no problem. It also successfully creates a second network (wc_net) in the same dataset (called "Layers") using an upstream trace this time from a particular pour point at the edge of the study area. But when I try to enable the network, I get the following error: 160326: The table already exists. Traceback (most recent call last): File "C:\_Workspace\Toolboxes\MNRF_TerrainToolsLocal\Pro\TerrainScripts\Step A.2. Prepare Water_new.py", line 756, in arcpy.EnableNetworkTopology_tn(wc_net, "", "ENABLE_TOPO") File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\tn.py", line 174, in EnableNetworkTopology raise e File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\tn.py", line 171, in EnableNetworkTopology retval = convertArcObjectToPythonObject(gp.EnableNetworkTopology_tn(*gp_fixargs((in_trace_network, max_number_of_errors, only_generate_errors), True))) File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 511, in return lambda *args: val(*gp_fixargs(args, True)) arcgisscripting.ExecuteError: ERROR 160326: The table already exists. Failed to execute (EnableNetworkTopology). Failed to execute (CreateGeometricNetwork). I can enable it manually by running the Toolbox command when I load the network into a map but I can't do it through python. Below is a sample of the script. First I try to clean up previous runs of the script deleting the networks before creating them again to help try isolating the problem. I am also checking for "TN_" tables (related to the trace network) that might not be cleaned up properly from previous bailed runs. As a last ditch effort, I tried copying all input feature classes and datasets to a new geodatabase to try running on a 'clean' geodatabase. No luck. Line 58 is where it bails. # Network clean-up from previous runs arcpy . AddMessage ( "Checking for Networks from previous run..." ) if arcpy . Exists ( wc_clean_net ) : arcpy . AddMessage ( " >> Deleting 'wc_clean_net'..." ) arcpy . Delete_management ( wc_clean_net ) if arcpy . Exists ( wc_net ) : arcpy . AddMessage ( " >> Deleting 'wc_net'..." ) arcpy . Delete_management ( wc_net ) arcpy . Delete_management ( WC_Clean ) if arcpy . Exists ( wc_select_net ) : arcpy . AddMessage ( " >> Deleting 'wc_select_net'..." ) arcpy . Delete_management ( wc_select_net ) arcpy . Delete_management ( WC_Select ) #arcpy.env.workspace = Output_Vector_GDB_Workspace arcpy . AddMessage ( "Workspace = " + arcpy . env . workspace ) CurrentLayer = "TN_*" arcpy . AddMessage ( "Checking for '" + CurrentLayer + "' orphan Network Tables..." ) GDB_Tables = arcpy . ListTables ( CurrentLayer , "All" ) tbl_ctr = 0 for tbl in GDB_Tables : tbl_ctr += 1 arcpy . Delete_management ( tbl ) arcpy . AddMessage ( " >> " + str ( tbl_ctr ) + " '" + CurrentLayer + "' tables deleted." ) arcpy . AddMessage ( "Performing Connected Trace to create WC Clean layer..." ) WC_Name = os . path . basename ( WC_Dissolve2 ) arcpy . AddMessage ( " >> Dissolved WC Name = '" + WC_Name + "'" ) arcpy . AddMessage ( " >> Creating Trace Network..." ) arcpy . CreateTraceNetwork_tn ( Layers , "wc_clean_net" , "" , [ [ WC_Name , "SIMPLE_EDGE" ] ] ) arcpy . AddMessage ( " >> Enabling Network..." ) arcpy . EnableNetworkTopology_tn ( wc_clean_net , "" , "ENABLE_TOPO" ) arcpy . AddMessage ( " >> Snapping buffer and pour points to network..." ) arcpy . Snap_edit ( wc_bf_and_pour_pts , [ [ WC_Dissolve2 , "EDGE" , "0.1 Meters" ] ] ) arcpy . AddMessage ( " >> Tracing network..." ) # Process: Trace Geometric Network ##arcpy.TraceGeometricNetwork_management(wc_clean_net, WC_Selection3, wc_bf_and_pour_pts, "FIND_CONNECTED", "", "", "", "", "", "NO_TRACE_ENDS", "", "", "", "AS_IS", "", "", "", "AS_IS") arcpy . Trace_tn ( wc_clean_net , "CONNECTED" , wc_bf_and_pour_pts , "" , "" , "" , "" , "" , "" , "" , "" , "" , "EDGES_ONLY" , "" , "" , "AGGREGATED_GEOMETRY" , "NEW_SELECTION" , "" , "Connected_Network_1" , "" , wc_traceout ) arcpy . MultipartToSinglepart_management ( wc_traceout , WC_Clean ) wc_clean_lyr = "wc_clean_lyr" arcpy . MakeFeatureLayer_management ( WC_Clean , wc_clean_lyr ) arcpy . AddMessage ( " >> Retrieving connected network results..." ) arcpy . AddMessage ( " >> Layer name is: {0}. Count is: {1}." . format ( os . path . basename ( WC_Clean ) , str ( arcpy . GetCount_management ( wc_clean_lyr ) ) ) ) arcpy . AddMessage ( "Performing Upstream Trace to create initial WC Select layer..." ) try : WC_Name = os . path . basename ( WC_Clean ) arcpy . AddMessage ( " >> Cleaned WC Name = '" + WC_Name + "'" ) arcpy . AddMessage ( " >> Creating Trace Network..." ) arcpy . CreateTraceNetwork_tn ( Layers , "wc_net" , "" , [ [ WC_Name , "SIMPLE_EDGE" ] ] ) except : arcpy . AddMessage ( " >> Network exists... bypassing creation" ) arcpy . AddMessage ( " >> Enabling Network..." ) arcpy . EnableNetworkTopology_tn ( wc_net , "" , "ENABLE_TOPO" ) arcpy . AddMessage ( " >> Snapping pour points to network..." ) arcpy . Snap_edit ( Flags_or_Sources_for_Tracing , [ [ WC_Clean , "EDGE" , "0.1 Meters" ] ] ) arcpy . AddMessage ( " >> Tracing network..." ) arcpy . Trace_tn ( wc_net , "UPSTREAM" , Flags_or_Sources_for_Tracing , Barriers_for_Tracing , "" , "" , "" , "" , "" , "" , "" , "" , "EDGES_ONLY" , "" , "" , "AGGREGATED_GEOMETRY" , "NEW_SELECTION" , "" , "Upstream_Network_2" , "" , wc_traceout2 ) if Barriers_for_Tracing != "" : arcpy . MultipartToSinglepart_management ( wc_traceout2 , Output_Vector_GDB_Workspace + "\\" + wc_inside ) wc_inside_lyr = "wc_inside_lyr" arcpy . MakeFeatureLayer_management ( Output_Vector_GDB_Workspace + "\\" + wc_inside , wc_inside_lyr ) arcpy . AddMessage ( " >> Retrieving upstream 'inside' network results..." ) arcpy . AddMessage ( " >> Layer name is: {0}. Count is: {1}." . format ( wc_inside , str ( arcpy . GetCount_management ( wc_inside_lyr ) ) ) ) else : arcpy . MultipartToSinglepart_management ( wc_traceout2 , WC_Select ) wc_select_lyr = "wc_select_lyr" arcpy . MakeFeatureLayer_management ( WC_Select , wc_select_lyr ) arcpy . AddMessage ( " >> Retrieving upstream 'select' network results..." ) arcpy . AddMessage ( " >> Layer name is: {0}. Count is: {1}." . format ( os . path . basename ( WC_Select ) , str ( arcpy . GetCount_management ( wc_select_lyr ) ) ) ) All I can think of is that the Enable function is trying to use the same system table name for the second network that was created for the first network. Am I missing something or is this a bug? Thanks, John

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

Trace Network Enabling Problem

JohnGaiot

Hello,

I am trying to port over an 10.3.1 script which used the old geometric network functionality in Python scripting. I am running ArcGIS Pro 2.6.2.

In my script, I am creating multiple trace networks to set up a cleaned watercourse network for further hydrology and DEM processing (burning and flow directions etc). It creates the first network (wc_clean_net) to find connected segments (isolated segments are dropped) and enables the network no problem. It also successfully creates a second network (wc_net) in the same dataset (called "Layers") using an upstream trace this time from a particular pour point at the edge of the study area. But when I try to enable the network, I get the following error:

160326: The table already exists.

Traceback (most recent call last):
  File "C:\_Workspace\Toolboxes\MNRF_TerrainToolsLocal\Pro\TerrainScripts\Step A.2. Prepare Water_new.py", line 756, in <module>
    arcpy.EnableNetworkTopology_tn(wc_net, "", "ENABLE_TOPO")
  File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\tn.py", line 174, in EnableNetworkTopology
    raise e
  File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\tn.py", line 171, in EnableNetworkTopology
    retval = convertArcObjectToPythonObject(gp.EnableNetworkTopology_tn(*gp_fixargs((in_trace_network, max_number_of_errors, only_generate_errors), True)))
  File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 511, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError:  ERROR 160326: The table already exists.
Failed to execute (EnableNetworkTopology).
 Failed to execute (CreateGeometricNetwork).<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I can enable it manually by running the Toolbox command when I load the network into a map but I can't do it through python.

Below is a sample of the script.

First I try to clean up previous runs of the script deleting the networks before creating them again to help try isolating the problem. I am also checking for "TN_" tables (related to the trace network) that might not be cleaned up properly from previous bailed runs. As a last ditch effort, I tried copying all input feature classes and datasets to a new geodatabase to try running on a 'clean' geodatabase. No luck. Line 58 is where it bails.

<SPAN class="comment token"># Network clean-up from previous runs</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Checking for Networks from previous run..."</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>wc_clean_net<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Deleting 'wc_clean_net'..."</SPAN><SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>wc_clean_net<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>wc_net<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Deleting 'wc_net'..."</SPAN><SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>wc_net<SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>WC_Clean<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>wc_select_net<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Deleting 'wc_select_net'..."</SPAN><SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>wc_select_net<SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>WC_Select<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#arcpy.env.workspace = Output_Vector_GDB_Workspace</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Workspace = "</SPAN> <SPAN class="operator token">+</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="punctuation token">)</SPAN>
CurrentLayer <SPAN class="operator token">=</SPAN> <SPAN class="string token">"TN_*"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Checking for '"</SPAN> <SPAN class="operator token">+</SPAN> CurrentLayer <SPAN class="operator token">+</SPAN> <SPAN class="string token">"' orphan Network Tables..."</SPAN><SPAN class="punctuation token">)</SPAN>
GDB_Tables <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListTables<SPAN class="punctuation token">(</SPAN>CurrentLayer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"All"</SPAN><SPAN class="punctuation token">)</SPAN>
tbl_ctr <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
<SPAN class="keyword token">for</SPAN> tbl <SPAN class="keyword token">in</SPAN> GDB_Tables<SPAN class="punctuation token">:</SPAN>
    tbl_ctr <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>tbl_ctr<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" '"</SPAN> <SPAN class="operator token">+</SPAN> CurrentLayer <SPAN class="operator token">+</SPAN> <SPAN class="string token">"' tables deleted."</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Performing Connected Trace to create WC Clean layer..."</SPAN><SPAN class="punctuation token">)</SPAN>

WC_Name <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>basename<SPAN class="punctuation token">(</SPAN>WC_Dissolve2<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Dissolved WC Name = '"</SPAN> <SPAN class="operator token">+</SPAN> WC_Name <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Creating Trace Network..."</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CreateTraceNetwork_tn<SPAN class="punctuation token">(</SPAN>Layers<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"wc_clean_net"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>WC_Name<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SIMPLE_EDGE"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Enabling Network..."</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>EnableNetworkTopology_tn<SPAN class="punctuation token">(</SPAN>wc_clean_net<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ENABLE_TOPO"</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Snapping buffer and pour points to network..."</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Snap_edit<SPAN class="punctuation token">(</SPAN>wc_bf_and_pour_pts<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>WC_Dissolve2<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"EDGE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"0.1 Meters"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Tracing network..."</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># Process: Trace Geometric Network</SPAN>
<SPAN class="comment token">##arcpy.TraceGeometricNetwork_management(wc_clean_net, WC_Selection3, wc_bf_and_pour_pts, "FIND_CONNECTED", "", "", "", "", "", "NO_TRACE_ENDS", "", "", "", "AS_IS", "", "", "", "AS_IS")</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>Trace_tn<SPAN class="punctuation token">(</SPAN>wc_clean_net<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CONNECTED"</SPAN><SPAN class="punctuation token">,</SPAN> wc_bf_and_pour_pts<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"EDGES_ONLY"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"AGGREGATED_GEOMETRY"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Connected_Network_1"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> wc_traceout<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MultipartToSinglepart_management<SPAN class="punctuation token">(</SPAN>wc_traceout<SPAN class="punctuation token">,</SPAN> WC_Clean<SPAN class="punctuation token">)</SPAN>
wc_clean_lyr <SPAN class="operator token">=</SPAN> <SPAN class="string token">"wc_clean_lyr"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>WC_Clean<SPAN class="punctuation token">,</SPAN> wc_clean_lyr<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Retrieving connected network results..."</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Layer name is: {0}. Count is: {1}."</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>basename<SPAN class="punctuation token">(</SPAN>WC_Clean<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> str<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>wc_clean_lyr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Performing Upstream Trace to create initial WC Select layer..."</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
    WC_Name <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>basename<SPAN class="punctuation token">(</SPAN>WC_Clean<SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Cleaned WC Name = '"</SPAN> <SPAN class="operator token">+</SPAN> WC_Name <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Creating Trace Network..."</SPAN><SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>CreateTraceNetwork_tn<SPAN class="punctuation token">(</SPAN>Layers<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"wc_net"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>WC_Name<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SIMPLE_EDGE"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Network exists... bypassing creation"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Enabling Network..."</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>EnableNetworkTopology_tn<SPAN class="punctuation token">(</SPAN>wc_net<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ENABLE_TOPO"</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Snapping pour points to network..."</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Snap_edit<SPAN class="punctuation token">(</SPAN>Flags_or_Sources_for_Tracing<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>WC_Clean<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"EDGE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"0.1 Meters"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Tracing network..."</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Trace_tn<SPAN class="punctuation token">(</SPAN>wc_net<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"UPSTREAM"</SPAN><SPAN class="punctuation token">,</SPAN> Flags_or_Sources_for_Tracing<SPAN class="punctuation token">,</SPAN> Barriers_for_Tracing<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"EDGES_ONLY"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"AGGREGATED_GEOMETRY"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Upstream_Network_2"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> wc_traceout2<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">if</SPAN> Barriers_for_Tracing <SPAN class="operator token">!=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">:</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>MultipartToSinglepart_management<SPAN class="punctuation token">(</SPAN>wc_traceout2<SPAN class="punctuation token">,</SPAN> Output_Vector_GDB_Workspace <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> wc_inside<SPAN class="punctuation token">)</SPAN>
    wc_inside_lyr <SPAN class="operator token">=</SPAN> <SPAN class="string token">"wc_inside_lyr"</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>Output_Vector_GDB_Workspace <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> wc_inside<SPAN class="punctuation token">,</SPAN> wc_inside_lyr<SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Retrieving upstream 'inside' network results..."</SPAN><SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Layer name is: {0}. Count is: {1}."</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>wc_inside<SPAN class="punctuation token">,</SPAN> str<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>wc_inside_lyr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>MultipartToSinglepart_management<SPAN class="punctuation token">(</SPAN>wc_traceout2<SPAN class="punctuation token">,</SPAN> WC_Select<SPAN class="punctuation token">)</SPAN>
    wc_select_lyr <SPAN class="operator token">=</SPAN> <SPAN class="string token">"wc_select_lyr"</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>WC_Select<SPAN class="punctuation token">,</SPAN> wc_select_lyr<SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Retrieving upstream 'select' network results..."</SPAN><SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" >> Layer name is: {0}. Count is: {1}."</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>basename<SPAN class="punctuation token">(</SPAN>WC_Select<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> str<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>wc_select_lyr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All I can think of is that the Enable function is trying to use the same system table name for the second network that was created for the first network.

Am I missing something or is this a bug?

Thanks,

John

Vind meer berichten getagd met

Accepted answers

Jonathan DeRose

@JohnGaiot It is possible to have multiple trace networks in the same feature dataset as long as the participating feature classes aren't the same; however, this appears to be a defect. I apologize for the inconvenience. We have been able to reproduce and have created an internal issue to be addressed. You can track this as BUG-000136866.

All comments

AndreasGutweniger

>4 years later, I am facing the same problem as the OP:

arcpy.tn.EnableNetworkTopology(tnname)

arcpy.tn.EnableNetworkTopology(
    in_trace_network = tnname 
)

raises an error:

ExecuteError: ERROR 160326: The table already exists.
Failed to execute (EnableNetworkTopology).

First programmatically disabling the network (as John Gaiot suggested) doesn't work.

But no problem, if I execute "Enable Network Topology" manually (from the Geoprocessing Toolbox).

What's the status of BUG-000136866? (I couldn't find out how to track it...)

JohnGaiot

Thanks Jon for the update. Looking forward to the fix. As a workaround, I keep adding the disable/enable combination for each network created, which seems to be doing the trick.

I found a bigger issue regarding a performance hit in Pro of the DA Update Cursor when processing data in loops compared to ArcMap. I will have to report this in the appropriate forum when I have a chance as it was enough to halt my development and turn to other pressing matters in the interim.

Jonathan DeRose

JohnGaiot

UPDATE #3: Even stranger finding... I tried to remove the enable topology functions and it logically came up with an error that topology was not enabled when trying to set flow direction. So basically, I found after creating each network, I had to first disable and then enable topology before setting flow direction and performing a trace successfully. Very weird behaviour, but I seem to be getting results now, which are not exactly the same as I was getting in ArcMap but at least I can troubleshoot my trace results now.

Below attached is a code snippet showing 1 of the 3 network/traces being performed and the weird logic that made it run successfully.

code.txt

Anonymous User

UPDATE #2: What appears to be happening here is that when I create each network, they are automatically enabled. I don't have to include the "EnableNetworkTopology_tn" function after creating the Trace, which contradicts the help instructions for the toolbox.

JohnGaiot

UPDATE: I tried saving the results of the first trace to a dataset in a new file geodatabase, created a new network (wc_net) and still got the same 'table already exists' error when I try to enable the network. Nothing else exists in the geodatabase because I just created it. So I have no clue why it's doing this...

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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