topic Re: Model Builder working fine but when using the Geoprocessing Scheduler, errors arise in ArcGIS Pro Questions

Model Builder working fine but when using the Geoprocessing Scheduler, errors arise

JustinH — Mon, 23 Sep 2024 19:37:19 GMT

Hi everyone. I am hoping someone can help me with this because as of now I am having to update feature services through this model manually (just running the model everyday). Our goal is to have this running every hour to update feature service.

My workflow generally follows the guidelines from @JianLange In this Tutorial

I laid a lot of the background in this post.

To summarize:

We have a feature service that is updated from a third party. The feature services are updated daily.
Our goal is to have data from a Polygon Feature Service (Updated From Third Party) joined to our Point Feature Service, which has most of the data (Updated From Third Party) and displayed in a dashboard.
The workflow looks like:
- Export Feature Service (so we do not manipulate the data that is being pushed by third party)
- Calculate a few fields
- Select By Attributes
- Join based on a unique ID
- Delete Rows
- Append to Feature Service

It is somewhat simple (I think) and the Model works perfectly fine when I run it from ArcPro manually. However, I do not want to run this everyday as our goal is to apply this workflow to multiple feature services.

When I go to schedule the tool to test, I get many errors. The error s are inconsistent but the majority of them are "000728: Field <value> does not exist within table." Sometime I also get a schema lock error but the 000728 is the most common. This is happening when the model comes to the Join Field operation.

I am sort of confused because this works just fine if I am running the tool normally. I am not totally sure where to start to trouble shoot this so here I am.

Thanks for your help!

Also: Seems like there are some other issues laid out here: this is the only other related post I have found.

https://community.esri.com/t5/arcgis-pro-questions/model-builder-schedule-not-working/m-p/1533431#M87835

Re: Model Builder working fine but when using the Geoprocessing Scheduler, errors arise

JustinH — Mon, 23 Sep 2024 21:19:08 GMT

Update: I recreated the model, I now get errors that say "160327: A column was specified that does not exist." when scheduling the tool. As before, the Model runs with no Warning or errors before I schedule the tool to run.

Re: Model Builder working fine but when using the Geoprocessing Scheduler, errors arise

JustinH — Wed, 25 Sep 2024 15:22:22 GMT

Update: I am providing Model details. Still no solutions. Could this be an issue with using Model Builder to update feature services in AGOL?

Re: Model Builder working fine but when using the Geoprocessing Scheduler, errors arise

JustinH — Wed, 02 Oct 2024 19:39:23 GMT

Still no solution unfortunately. Hoping someone can help!

Re: Model Builder working fine but when using the Geoprocessing Scheduler, errors arise

Rick_O_Hara — Sat, 16 Nov 2024 16:57:35 GMT

I'm also having multiple problems serving a geoprocessing tool that works fine in Model builder. When it is exported out I get ERROR 010340 in the app. Now, from arc pro, it just seems to freeze up when I go to publish anything.

If esri was a car manufacturer, they'd be out of business.

Re: Model Builder working fine but when using the Geoprocessing Scheduler, errors arise

JustinH — Wed, 14 May 2025 15:58:30 GMT

I am still having this issue. Every time I schedule a model builder tool, I get errors. The model works fine when it is not scheduled.