topic Re: generating trace network on oracle sde in ArcGIS Pro Questions

generating trace network on oracle sde

NajmEddine — Mon, 13 Nov 2023 08:42:14 GMT

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.

Re: generating trace network on oracle sde

DanPatterson — Mon, 13 Nov 2023 09:16:53 GMT

full error message

001904: SDE or DBMS admin user cannot create a utility network or trace network.—ArcGIS Pro | Documentation

Re: generating trace network on oracle sde

NajmEddine — Mon, 13 Nov 2023 10:16:29 GMT

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.

Re: generating trace network on oracle sde

George_Thompson — Mon, 13 Nov 2023 14:55:57 GMT

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.

Re: generating trace network on oracle sde

NajmEddine — Tue, 14 Nov 2023 09:20:28 GMT

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 problem

Re: generating trace network on oracle sde

George_Thompson — Tue, 14 Nov 2023 12:11:56 GMT

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).