I configured an elasticsearch connection and it is succesful when testing it. When creating an import integration with the elasticsearch connection it gives me a connection error with the message "Object reference not set to an instance of an object".
Object reference not set to an instance of an object (Elasticsearch)
- Last Post 5 weeks ago
Thank you for contacting us.
Please specify if the same issue occurs if you select your connection in Query Tool (+NEW-> QUERY).
Also, do you have any tables there at the moment?
We are looking forward to your reply.
The same thing happens if i make a new SQL query and select the elasticsearch connection (see attachment).
As elasticsearch is a document store I don't quite have tables, but I do have existing indicies containing documents.
Thank you for your reply with the details.
We will investigate the issue and inform you about the results as soon as possible.
We have fixed the issue. The fix will be available with the nearest Skyvia update. We will definitely inform you when Skyvia is updated.
The issue is related to indexes without fields (except id one). In your cases, they are:
As a workaround, you can either remove these indexes or add some fields to them.