Select to view content in your preferred language

generating trace network on oracle sde

571
5
11-13-2023 12:42 AM
NajmEddine
New Contributor II

we are trying to create a trace network on a dataset in an oracle sde, but this error is displayed: 001904: The SDE or DBMS administrator cannot create a distribution network or a trace network.

 

Capture error trace network.png

 

0 Kudos
5 Replies
DanPatterson
MVP Esteemed Contributor
NajmEddine
New Contributor II

Hi, thank you for your replie. i'm trying to generate the trace network with the sde profile, which is the owner of the database.

0 Kudos
George_Thompson
Esri Notable Contributor

You must  load the trace network into another data owner for the tool to work: https://pro.arcgis.com/en/pro-app/latest/help/data/trace-network/create-a-trace-network.htm

  • The input feature dataset must be from a database connection established as a database-authenticated user and owner of the input feature dataset. This user must have database privileges to create content and cannot be an OS-authenticated user, a database administrator, or the geodatabase administrator account. This database-authenticated user will become the database trace network owner on creation of the trace network.
--- George T.
NajmEddine
New Contributor II

Hello, thanks for your answer. we have created a database user and we shared with him the creation privileges of the class set concerned, and for the portal, we are connected by the same user. but we have this problemWhatsApp Image 2023-11-14 at 10.19.35.jpeg

0 Kudos
George_Thompson
Esri Notable Contributor

It still looks like the trace network is still owned by the SDE user. If that is the case, you need to copy over (or reload) the trace network in as the database user that you created. That DB user must have all the permissions to own data (https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/privileges-oracle.htm). 

--- George T.
0 Kudos