we have a simple workspace MSsql spatial reader and elastic search writer, but we are having this error, attached text file
Any idea
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
ElasticSearch coordinates are always stored in LL-WGS84. If spatial data in a different coordinate system enters the ElasticSearch writer, then FME will try and reproject the data to LL84. In this case, it looks like the SQL Server reader is not returning a recognized coordinate system for the dbo.Parcels_View table. Use FME Data Inspector to view the dbo.Parcels_View table and confirm the source coordinate system. You might have to explicitly set the coordinate system on the SQL Server reader.
@boubcher It looks like Kibana does not support geo_shape. I found this request for them to add support. There seems to be several requests for this here and here . You could add your thoughts to one of these discussions.