wedjaaopen / elasticjasper Goto Github PK

There is an issue with the "Hits Mode".

Independent of the "required" query, for example
{
"query": { "match": { "@msghost": "ALFA" }},
size: 3
}

additional (hardcoded?) query or even queries
{"from":0,"size":100}
{"from":100,"size":100}
...

are executed in Elasticsearch and both the preview and report are created from the results of these additional queries, surprisingly trimmed to the required count of records (3 in the example above).

As a result, it is not possible to query specific "matching" records from the Elasticsearch database within the "Hits Mode", because the oldest unfiltered records are always presented by the plugin from Elasticsearch.

Hi,
I am trying to use ElasticJasper adapter on jasper studio.
when i create a new report using Elasticjasper adapter i get this error:

java.lang.NoSuchMethodError: net.sf.jasperreports.data.AbstractDataAdapterService: method ()V not found
at net.wedjaa.jasper.elasticsearch.adapter.ESAdapterService.(ESAdapterService.java:51)
at net.wedjaa.jasper.elasticsearch.adapter.ESAdapterFactory.createDataAdapterService(ESAdapterFactory.java:111)
at net.wedjaa.jasper.elasticsearch.adapter.ESAdapterFactory.createDataAdapterService(ESAdapterFactory.java:119)
at com.jaspersoft.studio.data.DataAdapterServiceFactoryImpl.getDataAdapterService(DataAdapterServiceFactoryImpl.java:46)
at net.sf.jasperreports.data.DataAdapterServiceUtil.getService(DataAdapterServiceUtil.java:71)
at com.jaspersoft.studio.data.ui.SimpleQueryWizardDataEditorComposite.readFields(SimpleQueryWizardDataEditorComposite.java:218)
at com.jaspersoft.studio.wizards.datasource.StaticWizardDataSourcePage.run(StaticWizardDataSourcePage.java:380)

Note that I am using elasticsearch 2.3.0 and jasper studio the 6.2.2

Thank you in advance

The query parser don't allow to insert parameters.

This is a bit speculative but I'm running into transport errors when trying to communicate with ElasticJasper 6.2.2 and my 5.1.1 instance of ES. ES throws the following errors:

[2017-02-03T09:41:47,883][WARN ][o.e.t.n.Netty4Transport ] [CVOqk_g] exception caught on transport layer [[id: 0x4fdc82d6, L:/172.17.
0.2:9300 - R:/172.17.0.1:57676]], closing connection
java.lang.IllegalStateException: Received message from unsupported version: [2.0.0] minimal compatible version is: [5.0.0]
at org.elasticsearch.transport.TcpTransport.messageReceived(TcpTransport.java:1236) ~[elasticsearch-5.1.1.jar:5.1.1]
at org.elasticsearch.transport.netty4.Netty4MessageChannelHandler.channelRead(Netty4MessageChannelHandler.java:74) ~[transport
-netty4-5.1.1.jar:5.1.1]

I'm a bit new to ES however the errors correlate to the times I'm trying to connect with EJ. If this is a compatibility issue, are there plans to work with 5.0?

Running JasperStudio 6.3.0.

I have entered my hostname, port and cluster name. I validated the values from elasticsearch.yml. I also telneted into the box to ensure the port was open.

I get this error:

NoNodeAvailableException[None of the configured nodes are available: [{#transport#-1}{xx.xx.xx.xxx}{c3duanalytics1/xx.xx.xx.xxx:9300}]]
    at org.elasticsearch.client.transport.TransportClientNodesService.ensureNodesAreAvailable(TransportClientNodesService.java:290)
    at org.elasticsearch.client.transport.TransportClientNodesService.execute(TransportClientNodesService.java:207)
    at org.elasticsearch.client.transport.support.TransportProxyClient.execute(TransportProxyClient.java:55)
    at org.elasticsearch.client.transport.TransportClient.doExecute(TransportClient.java:288)
    at org.elasticsearch.client.support.AbstractClient.execute(AbstractClient.java:359)
    at org.elasticsearch.action.ActionRequestBuilder.execute(ActionRequestBuilder.java:86)
    at org.elasticsearch.action.ActionRequestBuilder.execute(ActionRequestBuilder.java:56)
    at net.wedjaa.elasticparser.ESSearch.executeSearch(ESSearch.java:509)
    at net.wedjaa.elasticparser.ESSearch.executeSearch(ESSearch.java:524)
    at net.wedjaa.elasticparser.ESSearch.runQuery(ESSearch.java:555)
    at net.wedjaa.elasticparser.ESSearch.runQuery(ESSearch.java:568)
    at net.wedjaa.elasticparser.ESSearch.getFields(ESSearch.java:621)
    at net.wedjaa.elasticparser.ESSearch.getFields(ESSearch.java:631)
    at net.wedjaa.elasticparser.ESSearch.test(ESSearch.java:638)
    at net.wedjaa.jasper.elasticsearch.adapter.ESAdapterService.test(ESAdapterService.java:115)
    at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:162)
    at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:59)
    at java.lang.Thread.run(Thread.java:745)

Trying to create a hits mode data adapter will fail with the message: "Reason org/json/JSONObject".

This issue is related to WedjaaOpen/ElasticSearchOSGI#1