topic Re: Overwrite Feature Service Error in GeoAnalytics for Fabric Questions

Overwrite Feature Service Error

ClaireSullivan — Mon, 23 Jun 2025 16:57:28 GMT

I am having a reoccurring error with the Spark DataFrameWriter on overwrite mode. I am attempting to overwrite a data layer with ~50,000 records. When I first run the cell, the Feature Service is truncated but no new records are loaded. If I re-run the same cell, the records are loaded to the Feature Service. Has anyone else experienced this error?

Re: Overwrite Feature Service Error

SBattersby — Thu, 26 Jun 2025 18:37:42 GMT

I have not experienced this. Does this happen with one specific dataset or with every dataset that you try? Do you receive an error at all from the first run? If so, can you provide it?

And can you send a code example of what is/isn't working (redacting any credentials or feature service identifiers)?

Thank you,

Sarah.

Re: Overwrite Feature Service Error

ClaireSullivan — Wed, 09 Jul 2025 19:34:12 GMT

So far, I have only been using one dataset. There is no error, the run ends successfully but my dataset in AGOL is truncated instead of the new dataset being uploaded. When I run the cell again, the records are updated in AGOL. I am using this method to update my feature service:

## upload feature service

featureServiceDf.write.format("feature-service")\

.option("gis", "myGIS")\

.mode("overwrite")\

.option("serviceUrl", myURL)\

.option("layerId", 0)\

.save()

Re: Overwrite Feature Service Error

SBattersby — Fri, 18 Jul 2025 20:50:13 GMT

Hi Claire - we are working on reproducing this internally to see if we can figure out what might be happening. Just for a few more details for our testing - is your ~50,000 record dataset points, lines, polygons? If lines or polygons, are they really complex geometries (i.e., lots of vertices) or relatively simple?

Thank you, and I'll let you know if we can recreate this and get some ideas on the issue / how to address it.

-Sarah.

Re: Overwrite Feature Service Error

NoahSlocum — Thu, 24 Jul 2025 21:57:03 GMT

Hi Claire,
We are still investigating the behavior you're seeing, but as a workaround for now could you try the append mode with the truncate option set to True? This would be a good workaround if you don't have any schema changes in your layer. For example:

featureServiceDf.write.format("feature-service")\
.option("gis", "myGIS")\
.mode("append")\
.option("serviceUrl", myURL)\
.option("layerId", 0)\
.option("truncate", True)\
.save()

I'm hoping this will work as expected and not require running the same cell twice to update the layer.