Hello colleagues,
I've created a model using ArcGIS Pro 2.5.1 that works fine when I write all outputs to the file geodatabase. So I want to improve performance and write intermediate outputs to in_memory Workspace. I was surprized to find that just changing the location of outputs that are not parameters can cause the issues.
For example Select by Attribute tool stops with a message "Invalid expression". After changing back to .gdb location it works fine. Here is the expression.
Another model stopped on Erase tool with a message "Can't open a feature class" (or something like that) but after I've changed back to .gdb it works. Than I tried to repeat the error to make screenshot but the second time it worked with "in_memory" location.
Have any ideas what's wrong here? I'd like my models to work fast and predictable but now I'm confused.