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

Unable to Alter Field Name

JoshWhite

I download a file geodatabase from an outside source. For some reason when the file creator does a join the field names get really long so I attempt to shorten them back the original field name after I use the copy features tool to import them into my sde. I was using the Alter Fields tool but it has been failing. I keep getting an error that certain fields cannot be changed because they are a custom sde type column.

I would understand this if I was actually altering one of these types of fields but I am not. These are the fields I am trying to alter by removing the SDE_SDE_Parcels_

I just tried to do this manually since the tool was not working correctly. Any idea on how to get around this issue?

Find more posts tagged with

Accepted answers

AsrujitSengupta

Yes, I'll recommend that, Make all the required changes in the File gdb itself and then load the data into the sde geodatabase.

Making these changes in the File gdb will be much easier and you won't have to worry about things like permissions, locks, etc.

All comments

AsrujitSengupta

Yes, I'll recommend that, Make all the required changes in the File gdb itself and then load the data into the sde geodatabase.

Making these changes in the File gdb will be much easier and you won't have to worry about things like permissions, locks, etc.

AsrujitSengupta

It doesn't seem to be a permission issue, as you can modify some of the other Field names.
It also doesn't seem like a Locks issue as you are able to rename the other fields.

JoshWhite

I am using 10.3. Yes I have tried changing the fields in the properties view in ArcCatalog, that is what I was attempting to do when I captured the second screenshot. I didn't check to see if I could alter the aliases until after I tried what Asrujit suggested so it probably wouldn't be a good test at this point. I am also wondering about permissions BUT I am currently the only user other than a couple of feature services. Could the feature services possibly be creating a schema lock? Seems odd I can change some fields but not all of them though. The fields I am struggling to change are the fields that are original to the feature class and are not part of the table that is joined before being uploaded to the flexviewer that I am using clip & ship to download from. I hope all of that made sense.

JoshWhite

Running everything manually as a test and that works, do you think I should run the alter fields tool in my model before I copy to my SDE?

ChrisSmith7

What version are you using? Have you tried it from the feature class properties view in ArcCatalog? Can you change the aliases? If SDE, maybe it's a perms issue...

AsrujitSengupta

Josh White what happens i you try to rename the fields in the File geodatabase itself and then try to load the data in the SDE geodatabase? Does that work?

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.