nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error 500 - Could Not Reserve Object IDs

JasminePrater

I am trying to add a new feature to an existing Portal 11.1 service that I published in a datastore I created. I am a SQL Server admin and ArcGIS Enterprise admin. I have tried editing the layer in ArcGIS Pro and in a map on Portal. I tried this last week and encountered the same issue. When I try to add the point, whether by Paste Special from another layer or by creating a new, blank feature, I receive the following message:

Failed to create Water Valve.
Error code: 500
Description: Internal server error.
Message: Unable to complete operation.
Details: Could not reserve object IDs.
Insufficient permissions [42000:[Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The EXECUTE permission was denied on the object 'i25_get_ids', database 'xyz', schema 'dbo'.] [WaterValve]

In Pro, I have tried this in a version I created for the service and a second version to make sure something wasn't wrong with my first version. I've tried with these versions on Private, Protected, and Public settings. I've tried pulling the data into a brand new ArcGIS Pro session without connections to anything other than Portal since I am using data from multiple sources and have a combination of Traditional and Branch Versioning in the original project. This WaterValve service is uses Branch Versioning. I have also checked the sharing in Portal, even though I'm the owner of the service and the admin. I have restarted the ArcGIS Server Windows service and restarted the WaterValve service.

Anyone have any ideas of what the issue could be, or things I could try to resolve this?

Find more posts tagged with

Accepted answers

JasminePrater

We eventually discovered our IT Manager had disabled our user account by mistake and we were able to get it resolved internally. We had been working with Esri Technical Support who had us check many things, but that was ultimately the issue.

All comments

JBeasley

Hi Jasmine, I know this is old but we are getting this error when attempting to create a new row in a feature layer that is published as a referenced service. The user account that was disabled, was that the ArcGIS Server service account, the data owner, or another account? We have granted many permissions to stored procedures and table objects, but no difference so far. I am just trying to narrow down which account to look at. Thank you!

JasminePrater

simoxu

Make sure the account you use to connect to the enterprise geodatabase has sufficient permissions: read and write permission. You are the portal admin, so your portal privilege should not be a problem.

The credential your service use to connect to the database will be stored in your registered data store.

Depending on your enterprise geodatabase authentication:

If the data is stored in a database that you access using database authentication, the database user you provide when registering the database must have permissions to the data.

If you access data through operating system authentication, add the ArcGIS Server account to the database and grant it permissions to the resources that it needs to access. When the service runs, it will sign in to the database management system as the ArcGIS Server account.

Hope this helps.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.