Background:
We've collected road data using an API and imported it into Databricks with the intention of displaying it on maps in ArcGIS Enterprise Portal. However, I'm encountering a problem when trying to upload a dataframe containing linestrings to the feature server in ArcGIS Enterprise Portal.
Issue:
When I attempt to save the dataframe from Databricks to the feature server, I receive the following error:
"java.lang.Exception: No supported append format found"
I'm not using the append command; I'm simply trying to save the dataframe. Initially, I thought the issue might be related to the data format, but the data is structured correctly with:
What's puzzling is that I can upload a dataframe with point geometries to ArcGIS Enterprise Server without any problems, but linestrings result in the error.
Troubleshooting Steps Taken:
Data Format Verification:
Version Comparison:
Current Environment:
Databricks Cluster:
ArcGIS Enterprise Portal:
Additional Observations:
Questions:
Potential Causes and Solutions:
Compatibility Documentation:
Possible Factors:
Best Contact at Esri:
I'm open to all suggestions and would greatly appreciate any insights.
Hey @Vegove
We are able to reproduce this at our end. The issue is specific to the upload format being chosen when writing to the service, it is not related to the Databricks environment or firewall restrictions.
Here is an alternative approach that can resolve this:
You can set the appendFormat to "featureCollection" and coalesceAppends to "False". The following code snippet can be used:
spark.conf.set("geoanalytics.sql.featureService.appendFormat", "featureCollection")
spark.conf.set("geoanalytics.sql.featureService.coalesceAppends", "False")
Can you please try it and let us know if it resolves the issue at your end?
-Artemis
Yes, this worked! Thank you for the help @ArtemisFili