Merge Command keeps failing

8885
8
02-08-2015 07:51 PM
JaimeTyson
New Contributor

I have a large, convoluted polygon file in SDE. I have it broken up in order to have faster refresh within mxd's, but I need to be able to merge all of the polygons together for the final product. The merge command keeps failing, as does dissolve or any other tool I try to use. I have more success in a shapefile, and am able to merge small area together at a time, but as I get close to having everything merged together, everything I try fails. Has anyone been able to successfully do this kind of task?

Tags (3)
0 Kudos
8 Replies
TeroRönkkö
Occasional Contributor

What does the merge say as error in result window?

0 Kudos
JaimeTyson
New Contributor

The Merge Command cannot be completed.

0 Kudos
JayantaPoddar
MVP Esteemed Contributor

Hi Jaime,

An alternative of Merge tool could be Append (Data Management).

Keep in mind, Append tool will not create a new output feature class. So, you need to create a new feature class in ArcCatalog, with same schema as your data (Import Coordinate system, and Field attributes). Then continue with Append tool.

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

Thanks,

Jay



Think Location
0 Kudos
JaimeTyson
New Contributor

The append did not merge the features together.

0 Kudos
MichelleWilliams1
Occasional Contributor III

Any other ideas for this issue? Mine worked last Friday, then IT made some changes to my system and now I'm getting the "Merge command can not be completed" message.

Last Friday - Due to other issues, IT removed 10.2.2 and 10.4.1 ArcMap, then reinstalled 10.4.1.5686

Any ideas on a fix?

0 Kudos
Scott_Harris
Esri Regular Contributor

Try running Check Geometry to see if you get any errors returned:

Check Geometry—Help | ArcGIS Desktop 

MichelleWilliams1
Occasional Contributor III

Bless you, Scott, that fixed everything.

CorySmith1
New Contributor

Late for OP but wanted to share a solution that worked for my situation on this error. I had ~500,000 polygons and merge could only do ~5000 at once [thanks for the bad algorithms + uninformative error messages, ArcMap!]. Dissolving everything together also failed.

Instead I created a new integer field = objectID / 1000 and dissolved based on that field, giving me ~500 polygons. I repeated a similar procedure going to ~100 then ~20 then ~5 polygons until I was finally able to merge everything together. So, basically just a few rounds of dissolve.

This may not fix every situation & Repair Geometry is a good idea too. But hopefully this can help others struggling.

0 Kudos