Append (Data Management) failing with ultra large datasets

492
3
08-10-2017 03:51 PM
MarcoBoeringa
MVP Regular Contributor

Hi all,

I am currently attempting to Append a couple of point datasets with a total of 370M points in three feature classes. All datasets reside in File Geodatatabases (three separate ones), and I am appending to one of the existing feature classes.

The data resides on a 2TB SSD with plenty of free space (>1TB). The machine runs ArcMap 10.5.1 and has 16GB RAM and Windows 10 as OS.

Now I have successfully done this with datasets with up to well over 100M records as final result dataset on Windows 7 machine, but I am now getting consistent failures with these. The error number is the not very useful generic 999998: Unexpected error type error and happens somewhere half way, so probably in the range of 100-200M records having been appended.

Clearly, with so many records, I might potentially run out of some resource, but it certainly isn't disk space.

Has anyone else been successful in appending feature classes with over 100M records each and well over 300M total, and especially also on Windows 10?

0 Kudos
3 Replies
DanPatterson_Retired
MVP Esteemed Contributor

Can you test in Pro?  The tool is the same, but the memory limits imposed by ArcMap aren't there.

Also, have you tried the Append one at a time or are you doing them all at once?

MarcoBoeringa
MVP Regular Contributor

Hi Dan,

Seems you were right. Pro succeeded in appending the 370M records into one feature class. However, I never saw RAM usage of Pro exceed more than just over 1GB, so I am a bit at loss at why ArcMap fails. Seems there is another limitation not so much related to total RAM, but to the 32 bit nature of ArcMap?

Anyway, I am now also attempting this one other time from ArcCatalog instead of ArcMap. I saw another GeoNet discussion where it was suggested that running tools from ArcCatalog instead of ArcMap made a difference in some cases, with tools run from the catalog window in ArcMap failing but not in ArcCatalog.

DanPatterson_Retired
MVP Esteemed Contributor

Good find... I assume that you are running ArcCatalog separately and not from within ArcMap, if so, you have removed the memory overhead of ArcMap

0 Kudos