Hi all,
I am using the latest ArcGIS Pro 3.02 to process a large dataset. The input is a polygon feature class which contains the distribution of 6000+ species. In the attribute table, each row represents the distribution of a particular species.
Using the Iterate Row Selection tool, I am trying to select the polygons, convert rasters, and collect the raster values (species by species). This submodel looks as follows

I then dragged and dropped this submodel into another model witht the Cell Statistic tool to sum up number of species in each pixel

I test-ran the model using a subset of the original input species data (10 species), it worked fine and the final outcome makes sense. The only issue is it takes about 1min to process 1 species in the submodel, 6000+ species means 100+ hours.
So I tried saving everything in_memory - the model runs so fast and it completed 150 species within a few minutes, then it reported the Out of memory error and stopped.
Then, after some research, I added the Delete tool to the submodel (see below)

Again the submodel can process all 6000+ species within 2 hours (using in_memory), however when it comes to the Cell Statistics tool, it reports the following error
ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.
Function Read Error [Local Function]
Function Read Error [Local Function]
Failed to execute (Cell Statistics).
I then removed the Delete tool and re-run the model for the 10 species subset of the data, and it works fine.
My question is if there is a faster way to process the whole dataset. I haven't tried the 100+ hrs approach yet.
Thank you.