I am at my wits end and would love some guidance. I have a cyclical process that I am trying to perform, and I keep running into errors with replicas stopping it.
1. Every night, ArcGIS Pro recreates a polygon layer by doing an SQL query of an external dataset and updating attributes of a polygon dataset of property parcels (the parcels themselves don't change, but the attributes do)
2. These data are pushed to AGOL via a python script that overwrites the web layer
3. People using Field Maps get up in the morning, update their offline maps and collect data (adding attachments to the polygon layer and changing values in the column that gets updated nightly)
4. After work, the data from the field collection are downloaded into our external (non-GIS) database.
The problem I'm getting is that I cannot overwrite the web layer with an updated version because I get errors that there are issues with replicas: "Service cannot be overwritten if Sync is enabled and Replicas exist." So, to do an overwrite, i have to go in and manually delete each replica.
Is there a better way to do this process so that I do not have replica issues? I need a way that each day people can add data to this dataset in the field (and offline), and each night, I need to download these data and update the dataset so that the next day the field workers see up-to-date info.