Query virtual index (ES datasource) got error "There are no connector nodes with JDBC enabled that can process the request at this time."

Siren Federate (Elasticsearch Plugin)
1

I am trying out virtual index (ES datasource from another ES cluster).

The Elasticsearch version I am using is 7.17.7, with Siren Federate plugin version 7.17.7-29.0.

I setup “remote cluster”, and could perform “cross cluster query” without problem.

And I created datasource and vitual index (appeared) without problem.

However, when performing query, I got the error “There are no connector nodes with JDBC enabled that can process the request at this time.”

Can anyone please hint me what could be the cause of the error?

Notice that the data source is not JDBC datasource.

Thanks.

2

Hi @Trevor_Lee

Even if you do not have a jdbc data source, you need to configure a node to be a jdbc enabled node, see how to do it:

https://docs.siren.io/siren-federate-user-guide/29/siren-federate/connector-apis.html#siren-federate-jdbc-node

This jdbc node will then be used by the coordinator to communicate with the remote cluster. The naming jdbc is a tech debt from a previous era that was not yet updated.

Kind regards

3

Thanks! It works now!