topic Re: Add Rule Tool Fail to Run in ArcGIS Utility Network Questions

Add Rule Tool Fail to Run

Brian_Colson — Fri, 10 Mar 2023 22:48:45 GMT

@RobertKrisher or @MikeMillerGIS or anyone else in the Community,

We have a Water irrigation Utility Network, which we are attempting to clean up some missing rules which we need to fix some of our network topology errors. Using the Schema owner, connected to the SQL Server, I am attempting to run the Add Rule tool within ArcGIS Pro, and I can't the tool to run or get past this error.

This is within the development environment, which we refreshed from production recently, via the SQL back end. I am connected as the utility network owner (within ArcGIS Enterprise 10.9) running ArcGIS Pro 2.9.5, and network topology disabled.

I made sure all services were stopped, tried it with the edit service running, and nothing gets past it. I get other errors that are more helpful, which lead me to connecting to the enterprise GDB, via the schema owner, which is why I find it weird that it is saying it has to be the owner of a version.

I thought I would try here, before I go to support.

Just wondering if anyone is experiencing the same issue with the add rule tool.

Thanks!

Re: Add Rule Tool Fail to Run

PaulLeBlanc1 — Fri, 10 Mar 2023 22:51:35 GMT

Is your default version protected? https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/manage-branch-versions.htm

Re: Add Rule Tool Fail to Run

RobertKrisher — Fri, 10 Mar 2023 22:56:41 GMT

If that is the case, try assigning the version management role to yourself and you should be able to get past this issue. See this blog or the online help if you want more info about this role.

Re: Add Rule Tool Fail to Run

Brian_Colson — Fri, 10 Mar 2023 23:07:46 GMT

Yup, that was the issue. Would be nice if that Add Rules tool gave me an error that told me it couldn't process because the default version was protected.

Back in business. Thank you both @PaulLeBlanc1 and @RobertKrisher .

Re: Add Rule Tool Fail to Run

Brian_Colson — Fri, 10 Mar 2023 23:09:08 GMT

To be clear, I used the Alter Version tool to remove the protection temporarily. That was the fix.

Re: Add Rule Tool Fail to Run

RobertKrisher — Sat, 11 Mar 2023 00:18:17 GMT

Thanks, I'll mark this as the solution you took. You should check out the Version Management role in a lower environment if you haven't already, it will allow you (as an admin) or any other super users to make changes to default while it is protected. This saves you the trouble of having to remember to run alter version to switch the version between protected / public when making schema changes. I would say it also means that you can post changes using your normal account, but you appear to already have a process in place for handling posting to your protected default.

Re: Add Rule Tool Fail to Run

MichaelHirschheimer — Sat, 11 Mar 2023 21:41:48 GMT

There is an Esri tech support article that identifies which Utility Network GP tools need SDE.DEFAULT to be Public to execute.

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

Re: Add Rule Tool Fail to Run

Brian_Colson — Mon, 13 Mar 2023 23:12:15 GMT

Yes, we are using the version management role already. Weird that even with my Version Manager, being my UN owner, I still couldn't add the rule, which was driving me crazy on a Friday afternoon. Thanks for the prompt reply!

Re: Add Rule Tool Fail to Run

Brian_Colson — Mon, 13 Mar 2023 23:12:39 GMT

Good to know @MichaelHirschheimer . I will follow that bug now. Thanks!