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

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

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

RobertKrisher

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

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.

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

George_Thompson

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

gpgisandsky

I'm trying with user Reti via the .sde

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?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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