laptop and a wrench

Bug

The error message returned when running the Add Rule geoprocessing tool in the Utility Network toolbox does not provide a clear indication of the issue with the access status of the default version.

Last Published: August 16, 2019 ArcGIS Pro
Bug ID Number BUG-000122212
SubmittedMay 7, 2019
Last ModifiedMarch 8, 2024
Applies toArcGIS Pro
Version found2.3.1
StatusIn Product Plan

Description

Certain geoprocessing tools that modify schema within the Utility Network toolbox must be run when connected as the database and portal owner of the utility network dataset from a database connection.  When sde.Default access is protected, these operations fail with the error:

Operation only allowed by the owner of the version [sde.DEFAULT]

Tools that perform DDL (data definition language) operations and require a client/server database connection display this behavior:

  • Add Rule
  • Create Utility Network
  • Delete Rule
  • Disable Network Topology
  • Enable Network Topology
  • Import Associations
  • Import Rules
  • Import Subnetwork Controllers
  • Update Portal Dataset Owner

Cause

The utility network restricts schema modification to the database utility network owner.  Schema modifying tools perform DDL operations that cannot be completed as the database utility network owner against sde.DEFAULT when access is set to Protected.

Workaround

The access property for sde.DEFAULT must be temporarily changed to Public to perform these changes. 

Execute these schema modifying operations against the database connection as the utility network database owner through the following workflow:

  1. Stop the associated feature service within ArcGIS Server Manager.
  2. Pause the database from accepting new connections.
    1. Make a connection as the geodatabase administrator, right-click the connection file, and select Properties
    2. Deselect the check box next to Geodatabase is accepting connections, and click OK
  3. Alter access for sde.DEFAULT to Public
    • Using a database connection as the geodatabase administrator, modify the version properties through the Versions view by using the Alter Version geoprocessing tool. 
  4. Execute the desired tool with a connection as the utility network database owner.
  5. Change the access for sde.DEFAULT to Protected
  6. Update the database to accept connections from within the database properties
    1. Make a connection as the geodatabase administrator, right-click the connection file, and select Properties
    2. Select the check box next to Geodatabase is accepting connections, and click OK
  7. Restart the feature service within ArcGIS Server Manager

Alternatively, the following tools can be executed when accessing the Input Utility Network directly from a feature service. When the sde.Default version is protected, the active portal account must be a portal administrator or the owner of the service. 

  • Enable Network Topology
  • Disable Network Topology 

Steps to Reproduce

Bug ID: BUG-000122212

Software:

  • ArcGIS Pro

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic