I have a ModelBuilder process which carries out the following (diagram attached): * Uses a hosted feature layer containing site boundary polygons (Layer1) as an input to a Select Layer By Attribute tool * This uses a simple SQL expression to select rows in Layer1 meeting certain criteria * The Select Layer By Location tool uses a second hosted feature layer containing polygons (Layer2) as input features, and selects them based on an Intersect relationship with the Layer1 features selected in step 2. * The Calculate Field tool is used to overwrite text in a field of the selected rows in Layer2 When run 'in person' in ArcGIS Pro, the model runs without issue. However, it fails when run as a Scheduled Task, giving the following error: ERROR 000358: Invalid expression Failed to execute (Select Layer By Attribute). The error help page is not particularly useful in this instance. Any ideas? ModelBuilderDiagram.png

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Scheduled ModelBuilder task fails on Select Layer By Attribute using Hosted Feature Layers (Error 000358 Invalid Expression)

DataOfficer

I have a ModelBuilder process which carries out the following (diagram attached):

Uses a hosted feature layer containing site boundary polygons (Layer1) as an input to a Select Layer By Attribute tool
This uses a simple SQL expression to select rows in Layer1 meeting certain criteria
The Select Layer By Location tool uses a second hosted feature layer containing polygons (Layer2) as input features, and selects them based on an Intersect relationship with the Layer1 features selected in step 2.
The Calculate Field tool is used to overwrite text in a field of the selected rows in Layer2

When run 'in person' in ArcGIS Pro, the model runs without issue. However, it fails when run as a Scheduled Task, giving the following error:

ERROR 000358: Invalid expression
Failed to execute (Select Layer By Attribute).

The error help page is not particularly useful in this instance. Any ideas?

ModelBuilderDiagram.png

Find more posts tagged with

Analysis

Desktop

Accepted answers

All comments

DataOfficer

I've carried out some limited testing so far using 3.0 and it seems to have resolved the issue. I will report back if that changes though with further testing.

What's the new error message @Michael_VanHatten ?

BigLouC

Hi Michael, not I have not.

I was about to when I asked my GIS IT group if it was OK and they told me not to as it may also have issues. To wait until a further release is available.

Go figure, a release to fix the release that was to fix a previous release.

I will wait to see when I can install it and then let you know.

Sorry to hear you still have issues.

Michael_VanHatten

I installed 3.0 today and go figure I am still having issues. Now a new error message shows up, have you had a chance to install and try out the scheduler with 3.0?

BigLouC

Thank God I found this thread.

I also have been going crazy with this. Modified my model, my script, nothing worked when scheduling this to update a hosted feature layer. Manually it works perfectly.

I am not too frustrated as this has to run monthly, but man it can drive you nuts not knowing that is a bug.

Running on 2.9.3 right now.

I think 3.0 was released today.

Michael_VanHatten

Thanks Robert

Robert LeClair

Michael - BUG-000131693 was fixed at ArcGIS Pro 3.0...which should be released very, very soon I suspect with User Conference coming up next month. Esri tends to release software updates a few weeks before UC.

Michael_VanHatten

Has there been any progress with this bug? Do we have to wait until 3.0 for automatic geoprocessing? It seems like this should be low hanging fruit.

Ramon_de_Leon

I see, might be a separate issue then for hosted layers (I was working on local file geodatabase/SDE).

I did check though and I have a scheduled model tool (ArcGIS Pro 2.9.2) that has a bunch of "Select Layer by Attribute" (non-numeric field) and its been working, the thing though is I am working on a file geodatabase then overwriting my feature layer after am done with my geoprocessing.

You might want to try creating a local copy of your "feature layer" and use that as input for your model after you are done you can overwrite your feature layer or do a delete rows/append to just insert the records that have changes.

DataOfficer

Glad you got it working. My field is not numerical but it still fails unfortunately.

Ramon_de_Leon

Have the same issue using the "Select (Analysis)" tool on a scheduled model.... This is the workaround that kinda help me get it to work.

I've notice that the issue only happens when the SQL expression is referring to a numerical field... In my case I needed to select data that are greater than 0 (I'd imagine it would be more complicated if it is another threshold value or ranges), so what I did was:

create a new string field
calculate the value of the created field as text value of the field I wanted to do my integer based expression

• Do the "Select (Analysis)" tool with the expression using the text field:

Hopefully the bug gets fixed soon, it’s a lot of extra steps to get the select working on a scheduled tool.

Michael_VanHatten

Were you able to find a solution to this issue? I have a nearly identical model and I am getting the same error (Error 00358: Invalid expression) My model works great when I start it, does not work when scheduled. Very annoying

RyanBohan

This has been driving me nuts all morning. My model works just fine, if I manually click run, if I schedule it, it fails. I tracked it down to the same error 000358.

I'll check out the process to export to a python script, thanks for the tip

I found this youtube very helpful, if you already know models skip about 30 minutes in. https://www.youtube.com/watch?v=pIfS0saxpi8

Robert LeClair

I don't know when 3.0 will be released as I'm not on the ArcGIS Pro Dev Team (I'm in Training Services). You can export a model to a Python script and use Windows Task Scheduler to run the Python script. There's a blog article that describes the workflow here

DataOfficer

Is there a timeline for the 3.0 release?
Is it possible instead to export the models to Python and schedule those instead?

Thanks,
Rob

Robert LeClair

This is BUG-000131693 - Select Layer By Attributes fails with ERROR 000358 or ERROR 000732 when scheduled in ArcGIS Pro. It is fixed at ArcGIS Pro 3.0. There is no current workaround in ArcGIS 2.9.x unfortunately.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.