Object reference not set to an instance of an object (Elasticsearch)

  • 24Views
  • Last Post 5 weeks ago
0
votes
Daniel Fabricius posted this 24 April 2023

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".

Attached Files

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 24 April 2023

Hello Daniel,

 

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.

 

Best regards,

Mariia

0
votes
Daniel Fabricius posted this 24 April 2023

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.

0
votes
Mariia Zaharova posted this 24 April 2023

Hello Daniel,

 

Thank you for your reply with the details.

We will investigate the issue and inform you about the results as soon as possible.

 

Best regards,

Mariia

0
votes
Mariia Zaharova posted this 27 April 2023

Hello Daniel,

 

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:

search-native-connector-test

search-salesforce-test

 

As a workaround, you can either remove these indexes or add some fields to them.

 

Best regards,

 

Mariia

 

0
votes
Mariia Zaharova posted this 5 weeks ago

Hello Daniel,

 

We have fixed the issue and updated Skyvia with the fix.

Feel free to check it and contact us in case of any further issues.

 

Best regards,

Mariia

Close