Merging features in an enterprise geodatabase

Question

I have 2 records in the attribute table of a feature class contained in a non-versioned enterprise gdb that I want to merge into one.  I've done this before without an issue but this time when I select the merge tool from modify features I get an error message at the top that says "the destination layer type cannot be merged" and the merge button at the bottom is grayed out.  Anyone know why this is and how to get around it?

Michele · Answer

Yes. Straight from the database. It also has a feature service and possibly a map service created from it. I can’t recall off the top of my head. Perhaps that’s why??  We don’t use arc online to edit anything. It’s just there for users to use or add into their project. Maybe if I try to merge it before I append it to the database that would work. I think that’s what I was doing in the past. A feature was left out a few weeks ago and I was trying to add it after the fact then merge it, but I guess I can’t do that in an sde that has services. I’ll have to try that on Tuesday. Thanks for talking this through with me. Sometimes that’s all you need to figure it out. 🙂

Eugene_Adkins · Answer

Understood.

Just for clarification, the feature class you’re working with is straight from the database or is sourced from a feature service (a published editable service) and not a map service, correct?

Michele · Answer

I mean 2 rows in the same attribute table of 1 feature class that have the same exact attributes in each field (column). I guess they are technically features and they are in a polygon feature class. I’m just trying to combine like rows of the same attributes into 1 row instead of having multiple rows. The merge features edit tool usually works but for some reason I am getting that error message when I add that SDE layer into the GP tool. I can’t even attach a screen shot bc it’s on a network that’s not connected to the internet.

Hope that clarifies it. It’s tough to explain with just words.