how to delete utility network and create a new one

[gpgisandsky]

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

[George_Thompson]

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?

[gpgisandsky]

 I'm trying with user Reti via the .sde

[George_Thompson]

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

[gpgisandsky]

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.

[gpgisandsky]

.

[PierreloupDucroix]

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.

[RobertKrisher]

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