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; } } }

Insufficient Permissions??

AndreGirard

I'm trying to add a field into an existing feature and when doing so i get the following error:

We are on ArcSDE with SQL being the server DBMS.

I'm on ArcGIS Desktop 10.5.1

IT department has looked into things on the database & server side and haven't found anything out of the norm.

Any help would be appreciated

Thanks

Najděte více příspěvků označených jako

Accepted answers

All comments

George_Thompson

Are you connected as the data owner? What are your permissions according to ArcCatalog on the feature class.

There are some notes at the top of the help that may be present: Adding fields—Help | ArcGIS Desktop

You can add or remove fields as long as the following conditions are met:
You have write access to the data.
You're not currently editing the data in ArcMap.
No other users or applications are accessing the data including other ArcMap or ArcCatalog sessions.

AdrianWelsh

This almost seems like a database lock-up type of issue. It might be best to move this thread to ArcGIS Enterprise‌

(or maybe Enterprise GIS?? - things are tricky on the GeoNet sometimes...)

Is there a way to stop/start the database and try again?

Or maybe this article can help:

Manage geodatabase locks—Help | ArcGIS Desktop

AndreGirard

Well i looked into the locks and there is nobody locking the database.

Will have IT restart the database server and see how that goes.

Thanks

MikeVolz

Did you check to see if there are any patches for your version that might address this issue?

George_Thompson

Here is a patch that has some permissions fixes for SQL Server: Esri Support 10.5 (10.5.1)

AndreGirard

ran the patch and that did not resolve the problem.

Server will be restarted overnight and will update tomorrow as to where things stand

Thanks

TinaMorgan1

This is a SQL Server geodatabase? In the error the object you are trying to alter is GIS_Essex_power.dbo.sw_cubicle.Test_report

^I can't tell if the owner is 'dbo' or 'sw_cubicle'. SQL Server fully qualified naming conventions are database.schema.object

What is the full name of your database, schema and object. Are there periods in any of these names?

Have you ever been able to alter this object?

AndreGirard

The full name is GIS_Essex_Power.DBO.SW_CUBICLE

I was trying to add another field called "TEST_REPORT"

We recently upgraded to 10.5.1

I haven't had to any fields in quite some time so not sure if this is tied to the upgrade or another problem or not.

TinaMorgan1

Can you make sure that your user is still associated with the dbo schema? This can be confirmed in SQL Server Management Studio.

GelcysWilliams

I'm hitting this error now on a db I have permissions to edit - I can't add a new feature class. How did you guys resolve? I see a 13 in the error, I'm going to hunt for a SQL Native Client 13 maybe??? Let me know if I'm on the right track??

MikeVolz

Did you just recently perform an ArcGIS upgrade?

Did you apply the patch mentioned above?

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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