topic Re: Adding/deleting fields in ArcMap 10.3.1 in Data Management Questions

Adding/deleting fields in ArcMap 10.3.1

CCGISCOOP — Tue, 07 Mar 2017 15:05:31 GMT

I am cleaning up an attribute table in Advanced Desktop ArcMap version 10.3.1. It is in an SDE database, registered, versioned, etc. I disconnected all other users and attempted to both delete a field and add a field. I kept receiving two different error messages. One said there were locks on the data - even after I disconnected everyone - and the other said I didn't have permission to perform the operation even though I created the data and have full edit priviledges. (SELECT, INSERT, UPDATE, DELETE). Can someone illuminate me to what I am missing? I searched the desktop help but did not find any useful information to trouble shoot my issue.

TIA.

Cathy

Re: Adding/deleting fields in ArcMap 10.3.1

JoeBorgione — Tue, 07 Mar 2017 15:53:34 GMT

Who owns sde.default? You or dbo, or sde? That may be conflict. Something I've taken quite a liking to is exporting a featureclass to an xml workspace, using xml notepad to make changes and then importing it back in. Admittedly, that may be overkill for your situation, but it's a viable option especially when creating feature classes based on an existing schema that isn't just what you want.

Re: Adding/deleting fields in ArcMap 10.3.1

RobertScheitlin__GISP — Tue, 07 Mar 2017 15:55:30 GMT

Cathy,

Is the user you are connecting with the owner of the data? That is the usual issue.

Re: Adding/deleting fields in ArcMap 10.3.1

CCGISCOOP — Tue, 07 Mar 2017 16:02:35 GMT

Hi Joe,

SDE is the owner of default. Should that matter, since we have a versioned database?

Re: Adding/deleting fields in ArcMap 10.3.1

CCGISCOOP — Tue, 07 Mar 2017 16:07:49 GMT

Thank you for the response Robert. SDE is the owner of the default version. And that is the version of the data I have in my map. I tried changing it to my version but the result was the same. Same errors.

Re: Adding/deleting fields in ArcMap 10.3.1

JoeBorgione — Tue, 07 Mar 2017 16:15:17 GMT

I just created a test feature class, registered it as versioned, and then deleted a field with no problem. I'm not sure what's going on; you mentioned that you are the owner, so I think we've sidestepped Robert's suggestion. I even deleted a field after switching the version to sde.default.

The one error of locks is pretty common, even after you pop off users; the best way I've found to get past that is to stop and restart the service. The permissions thing is strange though...

Re: Adding/deleting fields in ArcMap 10.3.1

CCGISCOOP — Tue, 07 Mar 2017 16:23:24 GMT

Thanks Joe,

Someone else mentioned stopping the service so I will give that a try. It has been a while since I have restarted the service so it might just be feeling cranky today??

Re: Adding/deleting fields in ArcMap 10.3.1

JoeBorgione — Tue, 07 Mar 2017 16:24:26 GMT

Yep. Sometimes you need to burp the baby....