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; } } }

Overschrijf ArcGIS Online Feature Service met behulp van ArcGIS Pro Project

jskinner

Voorheen schreef ik een document over hoe je een ArcGIS Online feature service kunt overschrijven door te verwijzen naar een feature class en gebruik te maken van een truncate/append methode. Ik ontving veel feedback op dit document, waarbij sommige gebruikers beperkingen ondervonden zoals het niet ondersteunen van attachments, en het bijwerken van services met meerdere lagen. Deze oplossing is bedoeld om deze beperkingen aan te pakken. Hieronder staat een script om een ArcGIS Online feature service te overschrijven door te verwijzen naar een ArcGIS Pro project, en een video over hoe je het script gebruikt. Laat hieronder een reactie achter als er problemen of vragen zijn.<\/P>

Vind meer berichten getagd met

Reacties

AndreaB_

One more post here to close the loop - The bug for this is indeed BUG-000115592 and it's closed as a Known Limitation. The enhancement request is ENH-000179977 "Allow overwriting a hosted feature layer in ArcGIS Online when a joined view is present or a view with an area of interest is defined". It's In Review. And I'm hoping the documentation will be corrected to provide clarification on the known limitation. But most of all I hope with some Kudos on that Idea, Esri can implement this ability. Thanks.

AndreaB_

@JakeSkinner You're welcome. It's not documented well anywhere. I'm waiting on more info from Tech support. I also found BUG-000115592 and Idea: https://community.esri.com/t5/arcgis-online-ideas/allow-overwriting-a-hosted-feature-layer-in-arcgis/idi-p/1672183 Give it a Kudo please, everyone!

jskinner

Thanks @AndreaB_ for reporting this back on the thread. I was not aware of this limitation.

AndreaB_

Hi @JakeSkinner ,

Thank you for testing it out. I just did some testing also with Pro 3.6.1. The issue is: the feature layer has a View Layer created with an Area of Interest defined within it.

When I create my View Layer in AGO:

This blocks overwriting of the feature layer. 🛑

Esri tech support has provided some links:

Expected Behavior: Overwriting a hosted feature layer with a related view layer (including AOI-defined view layers) is currently a limitation in ArcGIS Online. This is documented in the following support article: Error: ArcGIS Pro ERROR Code 400, Unable to Delete Item
Community Discussion: Similar behavior is discussed in the Esri Community: Unable to overwrite a web layer – Error 400 "Joined View" layers will cause this error, as well as any view layers with Areas of Interest defined within them.
Current Bug: There is a bug in ArcGIS Online for this limitation: BUG-000172493.
Additional Documentation:

Attempting to overwrite feature layer with related... - Esri Community

I am VERY surprised this is expected behavior. I would expect this to be a bug and functionality that needs to be fixed as soon as possible.

jskinner

@AndreaB_ I could not reproduce this using Pro 3.6.1. Could you publish another service, create a view, and test the script with the new service? This will determine if it's an issue with the script/API, or with the service.

AndreaB_

Hi @JakeSkinner ,

It looks like I spoke too soon about the script working. Even though the date shows updated in AGO my data isn't updated. I do have a View Layer created on this hosted feature layer. Do you think that's the problem? Here is what I get if I run the .py code in IDLE:

Python 3.11.11 (main, Mar 3 2025, 15:29:37) [MSC v.1938 64 bit (AMD64)] on win32

Type "help", "copyright", "credits" or "license()" for more information.

= RESTART: E:\Code\Overwrite Feature Service\Overwrite Feature Service.py

Connecting to AGOL

Creating SD file

Overwriting existing feature service

Traceback (most recent call last):

File "E:\Code\Overwrite Feature Service\Overwrite Feature Service.py", line 68, in <module>

fs = sdItem.publish(overwrite=True, publish_parameters=pub_params)

File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\arcgis\gis\__init__.py", line 16825, in publish

return self._publish(**params)

File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\arcgis\gis\__init__.py", line 17201, in _publish

serviceitem_id = self._check_publish_status(ret, folder)

File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\arcgis\gis\__init__.py", line 17563, in _check_publish_status

raise Exception("Job failed.")

Exception: Job failed.

AndreaB_

Hi @JakeSkinner ,

The .py seems to run in Windows task scheduler because the item detail page in AGO says "item updated" with today's date. But the Last Run result in Windows Task Scheduler says 0x1.

Do you have any ideas?

Thanks,

AndreaB_

Hi @JakeSkinner ,

Sorry for the confusion - I edited my post from last week. Your script is working great. I'm using ArcGIS Pro 3.5.5.

The bug, BUG-000171689, comes from ArcGIS Online and Esri tech support tells me the defect is currently under review with the development team.

But I'm using your script as a workaround to avoid that bug. Without your script I would be "cooked", as the kids say. 😊

Thank you!!

jskinner

Hi @AndreaB_, I could not reproduce this. What version of ArcGIS Pro are you running? I tested with ArcGIS Pro 3.6.1, which is version 2.4.2 of the arcgis module.

AndreaB_

Hi @JakeSkinner,

I am running into this AGO bug, BUG-000171689, https://support.esri.com/en-us/bug/after-truncating-the-feature-layer-the-visibility-scale-bug-000171689 "After truncating the feature layer, the visibility scale range of feature layer has been unexpectedly reset at the REST endpoint" when I run an ArcGIS Pro model that truncates and appends my hosted feature layer in AGO. So I thought I could use your script as a work around. Your script is great - but it still resets the visibility scale range for the feature layers in AGO.

visibility scale orig before overwrite.JPG visibility scale after overwrite script.JPG

If I do a manual Overwrite Feature Layer using ArcGIS Pro - it keeps the visibility scale range for my layers. But I need to run this as a script nightly.

Are you able to add this to your code to keep the visibility range on the layers?

I'm not sure how else to work around this at this point.

***Edit - And.....nevermind. Your script works as a perfect work around and it does maintain the visibility range. I had unknowingly run the Model after your script so I had bad results.

Thank you!

ModernGIS

@JakeSkinner

Since I have last integrated this app into my update workflows, I have done a tremendous amount of development on our AGOL platform. The main dataset is maintained and edited on ArcGIS Pro from our internal server and updated to AGOL for usage in Field Maps, Survey123 and Workforce.

I have started including attachments to feature classes and related GDB tables with relationship classes.

One of the issues I have recently found is when I run the script and it updates a Hosted Feature Layer on AGOL (Feature classes, tables, relationships, etc), the data appears to be updated when I open the data dialog in My Content. However, when I open the map in Map View/Field Maps, the related tables are not reflecting the updates from the same Hosted Feature Layer. This is all from the python script.

When I run the tool in ArcGIS Pro to overwrite the hosted feature layer, the related tables in the Map Viewer do infact reflect the updated changes.

Any thoughts on the script you provided or something I am overlooking?

SenadHodzicNR

@JakeSkinner So reading through the script, no matter what you still need to disable sync to update the feature service? Has anyone tested to see if their Offline Map Areas are preserved after this script is run?

haksinguiliam

This is fantastic! 🙏

One suggestion to the recording, which by the way, did an excellent job of listing possible changes user like me would potentially make, is having a couple view layer created. I would assume using the script wouldn't disconnect view layer or receive any failed update error, but it would be comforting to see in the video.

Tharu20B

Wow!!

I learned lot of things from this. Thank you.

tomshewring

@JakeSkinner thats sorted it. Thanks.
Although we had deployed the Local Intranet change to all users, it had not been deployed on the server running the Overwrite (Portal) Feature Service script. Thanks for your help. Much appreciated.

jskinner

@TomShewring this should not occur if you're running command prompt as a named user in Portal, and you have Portal's URL added to the Local Intranet (i.e. Start > Internet Options > Security tab > Local Intranet > Sites > Advanced > specify the portal URL (minus the web adaptor) > Add):

tomshewring

Hi @JakeSkinner , changing to these settings (and using the Portal WebAdaptor address) -
when I run the script from the command line I get a security challenge

So I could not run this as a scheduled task on the Windows server

jskinner

@TomShewring try removing the username/password variables from the following lines:

These should not be needed if you Windows Authentication is enabled. It will use the window's account that's signed into the server.

tomshewring

@JakeSkinner
1. Yes Windows Authentication is enabled on Portal WebAdaptor
2. Enterprise (Portal / Federated Server / Datastore) version 11.3
3. I have tried the script with

(i) ArcGISPro 3.3.1 -

and

(ii) ArcGISPro 3.1.4

jskinner

@TomShewring

Do you have Windows Authentication enabled on Portal's web adaptor?
What version of Enterprise?
What version of the arcgis api for python?

tomshewring

@JakeSkinner , thanks - moving the 'Clear scratch directory' section to the beginning of the script, above the section that connects to AGOL/Portal - this works.
One further thing I don't understand is - I have to use the <portalurl>:7443/arcgis address. If I use the WebAdaptor address I get errors such as these (even though I am using the same username and password in each scenario) -
Traceback (most recent call last):
File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\arcgis\auth\_auth\_winauth.py", line 75, in __init__
creds = gssapi.raw.acquire_cred_with_password(
File "gssapi\raw\ext_password.pyx", line 75, in gssapi.raw.ext_password.acquire_cred_with_password
gssapi.raw.exceptions.BadNameError: Major (131072): An invalid name was supplied, Minor (2529639136): Configuration file does not specify default realm

File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\arcgis\auth\_auth\_winauth.py", line 84, in __init__
raise Exception("Please ensure gssapi is installed")
Exception: Please ensure gssapi is installed

Do you know why this is?

jskinner

@TomShewring I've seen this error occur sporadically in some implementations (mine included), and I'm unable to find a cause. To workaround the issue, I recommend moving the Clear scratch directory section to the beginning of the script. For example, move this section of code above the section that connects to AGOL/Portal.

tomshewring

Hi @JakeSkinner , a hosted feature service.
I have got the 'Update service with previous properties' working - I had to use the siteadmin (default Administrator) account when connecting to Enterprise (Portal).
I now have a error in the 'Clearing scratch directory' section. I do not have ArcGISPro open (I am running this script from the command line not from within ArcGISPro) - so I do not know what application could be locking the WebUpdate.sd?
Traceback (most recent call last):
File "E:\AGOL_Scripts\Geoprocessing\ScheduledTools\NHLEonPortal\updateNHLEonPortal2.py", line 102, in <module>
arcpy.Delete_management(file)
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 7665, in Delete
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 7662, in Delete
retval = convertArcObjectToPythonObject(gp.Delete_management(*gp_fixargs((in_data, data_type), True)))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
arcgisscripting.ExecuteError: ERROR 000601: Cannot delete C:\Users\tshewring\AppData\Local\Temp\scratch\WebUpdate.sd. May be locked by another application.
Failed to execute (Delete).

jskinner

@TomShewring are you attempting to update a hosted feature service, or a referenced service?

tomshewring

I am running this script with an internal Enterprise (Portal) with IWA.

The script is working for me up until 'Update service with previous properties'

Traceback (most recent call last):
File "<string>", line 81, in <module>
File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\json\__init__.py", line 346, in loads
return _default_decoder.decode(s)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\json\decoder.py", line 337, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\json\decoder.py", line 355, in raw_decode
raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

jskinner

@cog_GIS_Admin here is helpful document on how use Windows Task Scheduler with python scripts:

https://community.esri.com/t5/python-documents/schedule-a-python-script-using-windows-task/ta-p/915861

cog_GIS_Admin

Thanks Jake, that was the issue. Now working on getting it to auto run with the server task scheduler.

jskinner

@cog_GIS_Admin check the casing of your username, this is case sensitive. For example, if your AGOL login is cog_GIS_Admin, and you specify cog_gis_admin, it will not authenticate.....even though cog_gis_admin will work in a web browser.

cog_GIS_Admin

My post keeps getting marked as spam, not sure why. I'll try again. This script is just what I was looking for, but I am getting an error trying to log into AGOL.

Connecting to AGOL
Traceback (most recent call last):
File "E:\Scripts\Workorders_CD\NewOverwriteWebLayers.py", line 30, in <module>
arcpy.SignInToPortal(portal, user, password)
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\__init__.py", line 2609, in SignInToPortal
return _SignInToPortal(*args, **kwargs)
ValueError: Error signing on to https://arcgis.com/.

Message : s
Details : Unable to generate token.

Any ideas?

cog_GIS_Admin

This script seems to be just what I am looking for, but I get an error when trying to login to AGOL.

Connecting to AGOL
Traceback (most recent call last):
File "E:\Scripts\Workorders_CD\NewOverwriteWebLayers.py", line 30, in <module>
arcpy.SignInToPortal(portal, user, password)
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\__init__.py", line 2609, in SignInToPortal
return _SignInToPortal(*args, **kwargs)
ValueError: Error signing on to https://arcgis.com/.

Message : s
Details : Unable to generate token.

Any Thoughts?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle links

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