wedjaaopen / elasticjasper Goto Github PK
View Code? Open in Web Editor NEWElasticSearch Plugin for Jasper Reports Studio
License: Apache License 2.0
ElasticSearch Plugin for Jasper Reports Studio
License: Apache License 2.0
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
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.