Changed FieldName in Attribute Table, Lost Features on Map

Question

In a fit of OCD I changed the field name for one of the fields [from PlaceName to Place_Name] in the attribute table associated with a feature class [so that it matched the field names in other feature classes].  This caused ArcGIS to message me: "FDO Error: 0 [Failed to label layer Marker for class Default.]".  Since the only feature class that had had one of its field names changed was "Marker", a dead giveaway.

So (a) the table is still there [right-click on the feature class in the Table of Contents, select Attribute Table] but (b) only newly added [newly as in: since I screwed the table up] features in this class now show on the map.  How do I bring the whole table back, please?  Oh, I went back to the Attribute Table [catalog right-click on the feature class in the geodatabase, selected properties and then selected the fields tab] and restored the field name to its original.  Didn't seem to resolve anything.

Many thanks, indeed ...

Bill Cole

Zeke · Answer

By 'backup map file' do you mean the mxd? You could try opening one, but I doubt that's the problem, since it appears to be in the feature class itself. Whatever mxd references it would presumably have the same problem.

Did you try adding a new field and using Field Calculator to populate it with values from the old field? If that works, you could then delete the original field. Another possible option, if you have Arc 10.2 or above, is to rename the field with the Alter Field tool, although it may be too late for that to help.

If none of that works, if you want to zip up your feature class and post it here, I'll take a look at it. Also post what you want the label to show. Good luck.

WilliamCole · Answer

I did MXD Doctor which came up clean.

I removed the layer and added it back to the same map.  No result.

I added the layer to a new map.  No result.

I exported the layer to a Shapefile and then added that new feature class back to the original map.  No result.

I keep a backup of my map files that goes back 30 days.   Would this feature class be a separate file?  and, if so, what is its nominal path and extension, please?  Maybe there's an outside chance I can restore one of my old one of these files.

Thanks again, very much.

Zeke · Answer

Yes, what I was thinking is that maybe the field name is correct, but Arc is only associating it internally with the new features. There could be a corrupt table in the gdb, but I wouldn't play with those.Try removing the layer and adding it back. Or add it to a new map and see if it works. You could also try running MXD Doctor against the mxd. If none of those work, try exporting the file to a shapefile or new feature class and exporting it back (or just add it back in if that works for you).