topic Re: Scheduled ModelBuilder task fails on Select Layer By Attribute using Hosted Feature Layers (Error 000358 Invalid Expression) in ArcGIS Pro Questions

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

DataOfficer — Thu, 10 Feb 2022 15:21:08 GMT

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?

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

Robert_LeClair — Thu, 10 Feb 2022 15:31:56 GMT

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.

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

DataOfficer — Thu, 10 Feb 2022 15:34:49 GMT

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

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

Robert_LeClair — Thu, 10 Feb 2022 15:44:15 GMT

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

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

RyanBohan — Mon, 07 Mar 2022 23:44:47 GMT

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

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

Michael_VanHatten — Thu, 12 May 2022 22:31:05 GMT

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

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

Ramon_de_Leon — Wed, 18 May 2022 20:31:02 GMT

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.

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

DataOfficer — Thu, 19 May 2022 08:35:31 GMT

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

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

Ramon_de_Leon — Thu, 19 May 2022 12:42:59 GMT

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.

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

Michael_VanHatten — Wed, 22 Jun 2022 19:12:12 GMT

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.

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

Robert_LeClair — Wed, 22 Jun 2022 19:15:49 GMT

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.

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

Michael_VanHatten — Wed, 22 Jun 2022 20:22:22 GMT

Thanks Robert

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

BigLouC — Thu, 23 Jun 2022 21:03:19 GMT

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.

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

Michael_VanHatten — Tue, 28 Jun 2022 20:40:39 GMT

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?

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

BigLouC — Wed, 29 Jun 2022 14:22:52 GMT

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.

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

DataOfficer — Wed, 29 Jun 2022 15:39:32 GMT

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 ?