Schema Lock Error

Question

Hello everyone,

I have created a Utility Network in SDE and am currently trying to import rules. However, I keep encountering this error although it is not being used by another user and I also have not shared it yet as a service.

I should mention that Subnetwork Controllers have been imported by another user.

Does anyone have any insights into why I might be getting this error?

Thanks in advance!

rkrisher · Answer

Because Adding Rules uses the SDE connection, and requires an exclusive schema lock, you will need to stop any services connected to that database before you can add a rule. You will also need to make sure that there are no other connections to the database.

rohanrajan_hms · Answer

I did not find why it happened but this worked for me MOST OF THE TIMES.

* Disable and Enable network topology and Validate entire extent once.
* Remove Locks to the connection in Administration 
* Save and Close all active Users / ArcGIS Pro stations currently using the service.
* Open a fresh ArcGIS Pro project and map
* Add the service to a fresh map.
* Add Rule