English

Unable to run schema-modifying geoprocessing tools on a utility network when sde.DEFAULT is protected.

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:

  • Create Utility Network
  • Disable Network Topology
  • Enable Network Topology
  • Add Rule
  • Delete Rule
  • Import Rules
  • Import Associations
  • 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 Pubic 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 or 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 

Related Information