topic Re: how to delete utility network and create a new one in ArcGIS Utility Network Questions

how to delete utility network and create a new one

gpgisandsky — Thu, 03 Apr 2025 16:56:44 GMT

Hi,

I have AGE 11.3 + Oracle 19c (with un7) + Pro3.3.2

I deleted Un dataset from Oracle and now when I copy Un dataset again from FGDB to EGDB by Copy&Paste (on *.sde - branch - default - user owner - portal connection in Pro with correct privileges) the following errors appear:

Start Time: giovedì 3 aprile 2025 18:44:07
ERROR 000260: Table not registered [RETI.UN_1323_WeightDefs]--Table not registered [RETI.UN_1323_EdgeWeights]--Table not registered [RETI.UN_1323_JunctionWeights]--Table not registered [RETI.UN_1323_ElementAssociations]--Table not registered [RETI.UN_1323_Topology]--Table not registered [RETI.UN_1323_EIDMappings]--Table not registered [RETI.UN_1323_Props]--The table was not found. [Error querying row from table RETI.UN_1323_Props]--DBMS table not found [ORA-00942: table or view does not exist] [RETI.UN_1323_Props]--The creation of the utility network failed. [RETI.Network]--Operation only allowed by the owner of the version [SDE.DEFAULT]
ERROR 000260: Table not registered [RETI.UN_1323_WeightDefs]--Table not registered [RETI.UN_1323_EdgeWeights]--Table not registered [RETI.UN_1323_JunctionWeights]--Table not registered [RETI.UN_1323_ElementAssociations]--Table not registered [RETI.UN_1323_Topology]--Table not registered [RETI.UN_1323_EIDMappings]--Table not registered [RETI.UN_1323_Props]--The table was not found. [Error querying row from table RETI.UN_1323_Props]--DBMS table not found [ORA-00942: table or view does not exist] [RETI.UN_1323_Props]--The creation of the utility network failed. [RETI.Network]--Operation only allowed by the owner of the version [SDE.DEFAULT]
Failed to execute (CopyMultiple).
Failed at giovedì 3 aprile 2025 18:47:37 (Elapsed Time: 3 minutes 30 seconds)

what should be done? I hope i dont have to strart from a new clean db istance.

thank you

Re: how to delete utility network and create a new one

George_Thompson — Thu, 03 Apr 2025 17:00:16 GMT

Are you copying the data into the Oracle database as the data owner (which appears to be "RETI") via the .sde connection?

Or are you trying to load this via a service?

Re: how to delete utility network and create a new one

gpgisandsky — Thu, 03 Apr 2025 17:01:50 GMT

I'm trying with user Reti via the .sde

Re: how to delete utility network and create a new one

George_Thompson — Thu, 03 Apr 2025 17:16:47 GMT

Ok, after the delete, did you see any of the "old" dataset items in the Oracle EGDB?

Re: how to delete utility network and create a new one

gpgisandsky — Thu, 03 Apr 2025 17:30:19 GMT

Re: how to delete utility network and create a new one

gpgisandsky — Thu, 03 Apr 2025 17:35:40 GMT

When I deleted un dataset in the *.sde there were only the four un tables (AqEdgeObject, AqJunctionObject, StructureEdgeObject, StructureJunctionObject) which I then deleted but the dataset has been completly canceled.

When I did copy & paste, after error above (Start Time: giovedì 3 aprile 2025 18:44:07)

the feature class AqLine (Aq is my domain network) remained at root level and not within RETI.UtilityNetwork dataset so I deleted it.

The db contain other dataset that are not involved in utility network so I need reuse the same instance.

Re: how to delete utility network and create a new one

PierreloupDucroix — Fri, 04 Apr 2025 02:12:31 GMT

Hello,

from my experience, you cannot just delete a UN dataset and expect to add another in replacement. Neither can you just copy / paste a UN dataset from a FGDB to an EGDB.

You have to delete and recreate the entire database (or schema at least) in order to delete all UN hidden tables that are installed by Esri.

Then you have to stage UN in the EGDB, then export an asset package from the FGDB and import it in the newly created dataset.

[EDIT] if you need to keep other datasets, maybe you can copy them into your FGDB and when exporting the asset package, use "All items in the workspace" option.

Re: how to delete utility network and create a new one

RobertKrisher — Fri, 25 Apr 2025 14:46:50 GMT

@gpgisandsky if you haven't already, log a case with support.