topic Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service in ArcGIS Pro SDK Questions

Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

MohammedHilal_K — Fri, 12 Aug 2022 10:00:44 GMT

Hi,

I was trying to create an Add-Inn to update the subnetworks through REST API GP Service, because it is very fast compare to the inbuild tool in ArcGIS Pro. For testing purpose I used REST API GP Service directly, the process got success in my branch version. But after the update When I Try to create a feature in current branch version, am getting 'Object has no schema locks' Error. Sometimes I could solve that by switching the branch versions, but sometimes not.

Any suggestions should be appreciated.

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

RichRuh — Fri, 12 Aug 2022 20:35:45 GMT

Branch versioning does not support multiple concurrent editors against a single version. When you are updating a subnetwork with a direct REST call it's creating a second editing session. That's the source of the schema lock errors.

Have you tried using the Pro SDK to update the subnetworks rather than REST?

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

MohammedHilal_K — Wed, 17 Aug 2022 06:55:42 GMT

HI Rich,

I tried Pro SDK and it is taking about 10 minutes to updates the subnetwork, but when I tried with REST call, it is taking only less than one minute. Is there any way to solve the Schema locks error?

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

RichRuh — Wed, 17 Aug 2022 15:17:55 GMT

The time difference here is alarming and unexpected. Do you have fiddler installed? I'm wondering if you could examine the call to update subnetwork that is generated by the Pro SDK and see if it matches what happens when you manually call it? Is the Pro SDK updating multiple subnetworks?

--Rich

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

MohammedHilal_K — Tue, 23 Aug 2022 10:17:16 GMT

Hi Rich,
Both the REST call and ArcPro SDK is doing the same work, like updating multiple subnetworks. REST call is super fast taking about 1 minute. while ArcPro SDK taking about 8 to 10 minutes to update the subnetwork on first time. Second time the processing time is decreasing to 3 to 4 minutes. That's why I'm focusing to the REST call.
Also I noticed that if we are updating subnetwork for branch version from SDE.Default, not getting any schema locks error. But My task is to update the current branch version. Is there any idea that can add in to the Add-Inns, like switching the versions before and after updating the subnetwork?

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

RichRuh — Tue, 23 Aug 2022 17:23:36 GMT

Both the REST call and ArcPro SDK is doing the same work, like updating multiple subnetworks. REST call is super fast taking about 1 minute. while ArcPro SDK taking about 8 to 10 minutes to update the subnetwork on first time. Second time the processing time is decreasing to 3 to 4 minutes. That's why I'm focusing to the REST call.

When you call the Pro SDK to update a subnetwork, how long does the REST call take?

Also I noticed that if we are updating subnetwork for branch version from SDE.Default

I'm not sure what you mean here. Are you updating the subnetwork on the branch version or the default version?

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

MohammedHilal_K — Fri, 26 Aug 2022 11:01:51 GMT

In ArcPro SDK, I tried utilitynetwork.subnetworkmanager.UpdateAllSubnetworks (tierName,true), which is takes 8 to 10 minutes. Which is working fine and there is no schema locks error.

Second case, I directly call the REST API through URL(like '......../UtilityNetworkServer/updateSubnetwork') to updates the subnetwork. After this am getting schema locks error while trying to edit the current version features. if I can resolve this i will call this REST API though and Add-Inn.

One observation is that when we update subnetwork of a branch version by standing in default version, after updation switching back to the branch version and trying to edit the features is working without any schema errors. But my requirement is that if we click a button, the current branch versions subnetworks should be update.
Any help?

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

RichRuh — Fri, 26 Aug 2022 15:28:09 GMT

The schema locks error is expected. When you edit a version by calling the REST endpoint, it creates a write lock, since only one connection can be editing at a time.

What I am trying to understand is why it takes so long to call update all subnetworks from the SDK. If we can fix that problem then you'll be able to use the SDK instead of the REST endpoint, and the schema locks problem will be solved.

--Ric

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

Dwarburg — Mon, 08 May 2023 18:30:11 GMT

I get the same 'Object has no schema locks' error when trying to list branch version differences using ArcGIS API for Python. Is this also expected?

VersionList = _version.VersionManager(my_vms, my_gis).all
Version = VersionList[-1]
Version.differences(result_type = 'objectIds', moment = None)

Traceback (most recent call last):
... line 648, in _handle_json_error
raise Exception(errormessage)
Exception: Object has no schema locks.
(Error Code: 0)

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

LanceKirby2 — Tue, 26 Sep 2023 14:31:13 GMT

Hey @Dwarburg did you ever resolve this? Specifically the no schema locks error via the python api. I am running into the same issue.

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

MohammedHilal_K — Tue, 26 Sep 2023 15:44:14 GMT

I resolved this issue by using SDK. REST end point is not able to resolved my issue.

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

LanceKirby2 — Tue, 26 Sep 2023 21:22:31 GMT

Thanks. I figured it out for the python api, basically I just needed to call StartReading() and StopReading() methods on the version object.

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

Dwarburg — Fri, 03 Nov 2023 18:48:23 GMT

Yes, in the Python API this is resolved by .start_reading and .stop_reading which lcoks and unlocks the version for your script to read from it. I posted a description here on stack exchange. arcpy - Extracting data shown in Version Changes on Branch-Versioned feature service before reconcil...

Version.start_reading()
Differences = Version.differences(result_type='objectIds', moment=None) 
Version.stop_reading()

Re: Getting Object has no Schema locks Error while trying to create new feature, after Subnetwork Update through REST API GP Service

LanceKirby2 — Fri, 03 Nov 2023 22:44:12 GMT

I’m curious if you have had a use case where you need to do some edits to a version while the user has it in a project or actively using it somewhere.

I am currently needing to update some values in a versioned layer once a user finishes their edit. Right now I’m using just a normal update cursor with not many issues but it’s slow. Was testing with just using the .edit method on a version object through the API and I have to remove their lock in order to establish my own and update the data. After this they still need to reconcile and post, but are getting errors related to no schema locks. I am using .start_editing() and .stop_editing() which I thought would allow their lock to be reestablished, but doesn’t look like that is the case.