topic Re: Summary Statistics tool Error in Model Builder in ModelBuilder Questions

Summary Statistics tool Error in Model Builder

Anonymous User — Mon, 12 Aug 2019 20:08:35 GMT

I am using the summary statistics tool in an iteration in model builder. When I run the model some times it works just fine and other times I get an error. The error says that it can't delete the table that is created by the summary statistics tool and that it may be locked by another application. I don't have anything else open that I know of that would cause a lock on this table. Any ideas as to why I'm getting this error?

Re: Summary Statistics tool Error in Model Builder

DanPatterson_Retired — Mon, 12 Aug 2019 22:35:35 GMT

did you ever open the table? (lock sometimes)

did you save between runs of the model? (sometimes clears out locks)

change the output filename and/or location

No guarantees, locks are challenging

Re: Summary Statistics tool Error in Model Builder

DuncanHornby — Tue, 20 Aug 2019 11:54:26 GMT

Where are you writing the summary table? If IN_MEMORY that may cause an issue too.

Re: Summary Statistics tool Error in Model Builder

Anonymous User — Tue, 20 Aug 2019 12:24:49 GMT

I tried writing the summary table to in_memory and to a database. Neither one worked. I was never able to get it to work in ArcMap. I opened the same model in ArcPro and it worked without having to change anything.

Re: Summary Statistics tool Error in Model Builder

curtvprice — Mon, 09 Sep 2019 06:00:39 GMT

Some things are better in Pro and one issue you may have been running into is ArcMap background processing which is the default setup. ArcMap foreground and background often have problems with various things, including file locks and properly passing layers between the foreground and background. In Pro -- all tools are run in the "background" in the GP processing thread.