enable utility network topology errors

[gpgisandsky]

Hi,

I deployed Utility Network v7 on ArcGIS Enterprise 11.3 (Oracle 19) with ArcGIS Pro 3.3.2.

When I try to enable the Utility Network topology directly on the .sde connection, it fails.

I also tried enabling the Utility Network topology through the service, but that fails as well.:

ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.

Failed to execute (EnableNetworkTopology).

I also tried updating ArcGIS Pro from 3.3.2 to 3.3.5, but the operation still fails.

I also tried to excute repair geometry  but when I select xy Device from my project the following error appear:

Error 003341 This operation is not supported on Esri Spatial Types.

Has anyone experienced a similar issue?

[gpgisandsky]

@RobertKrisher , @MikeMillerGIS Do you have any ideas?

[RobertKrisher · Accepted solution]

Please log a case with support.

[gpgisandsky]

Hi @RobertKrisher the ticket has been opened with ID 03901423 from Italy.  Do you have visibility on this?

[RobertKrisher]

@gpgisandsky I will try to keep an eye on it as it develops, but at this point we need to work it through the process until we can get something reproducible to development.

If you copy your utility network from Oracle to a File or Mobile Geodatabase, does it succeed there? If not, that's a much easier reproducible issue to push through support.

If you can enable the network topology in a local geodatabase, try copying the dataset back into an enterprise environment and version the dataset.  If versioning fails, that narrows down the issue. If that works, then you can move forward with that utility network.

[gpgisandsky]

Hi @RobertKrisher you are very kind. I tried twice with an empty enterprise gedatabase. I wrote a document with all steps that i follow to migrate asset package to enterprise geodatabase. Also I have assetpackage file and a file geodatabse that I used to try anything. I can enable network topology on file geodatabase and i haven't error within. Can I send you all data and docs by e-mail? Do you need a Oracle dump too?

[RobertKrisher]

@gpgisandsky Does this work in a local geodatabase? What happens if you copy the enabled network topology to enterprise and version it?

[gpgisandsky]

In a local geodatabase anything works fine.

In the enterprice geodatabase I follow these steps:

1)

• On Open PRO with un owner
• On an empty geodatabase with direct connetcion reti.sde (with branch option) :
  • Stage Utility Network  (UNTOOLS 3.3.3.1)
  • Apply Asset Package (UNTOOLS 3.3.3.1)
• On UtilityNetwork dataset and un tables (right click of dataset/table-->manage-->check on versioning branch and Editor Tracking) .
• Execute tool “Enable Topology” on reti.sde (branch option and network topology off)ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.
  FDO error: -2147196578
  The requested operation is unsupported by instance db.
  Failed to execute (EnableNetworkTopology).

If I open network topology information on db I have the value one on Dirty area count.

Regarding "What happens if you copy the enabled network topology to enterprise and version it?"

Do you want that I try to copy and paste utility network that I have on a file geodabase (with enabled topology) directly in the empty enterprise geodatabase (without stage, apply... steps)?

[RobertKrisher]

@gpgisandsky yes, I am suggesting you try copying a utility network with an enabled network topology from a local geodatabase to an enterprise geodatabase.

[gpgisandsky]

@RobertKrisher I tried to:

a)  Copy and Paste UtilityNetwork with an enabled network topology in on Oracle 19c.  This time, the topology works fine. Now, I can enable and disable the topology without issues. The ASSOCIATIONSTATUS  field is populate correctly for associations. Howerver, when I try to edit a structure junction container and add a content feature (using Modify association in ArcGIS Pro) the following error apper:

b) Using the ASSETPACKAGE file geodb (without associations due to a known bug when applying the asset creation CSV of associations—see my post on ESRI Community),  I attemped to deploy on Postgres15 (with stage un+apply asset untools 3.3.3.1 method).

After deployment, I imported the associations using the Import Association tool (Utility Network Tools). The tool completed successfully, but the ASSOCIATIONSTATUS value was not correctly populated for Content/Container associations—it remained set to "None".

However, if I use ArcGIS Pro with the UN feature service to edit a structure junction container via Modify Association, and then add a content feature, the association is applied correctly, and the ASSOCIATIONSTATUS is updated appropriately.

c) Using the same file geodatabase, I tried again on Postgres 15. This time, I used Copy & Paste to migrate the Utility Network. In this case, the ASSOCIATIONSTATUS values were correctly populated. Also, editing a structure junction container using Modify Association in ArcGIS Pro and adding content updated the ASSOCIATIONSTATUS as expected.

So the un solution work fine only in case C) but I need to work on Oracle (case A). What might be causing "Edit operation failed" issue?