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
