pvbavel Posted February 25, 2016 Share Posted February 25, 2016 I've followed the exact instructions http://community.jaspersoft.com/project/web-service-data-source In Jaspersoft Studio I can run my created job and I receive results back, so that's great! However, when I publish that report to our Jaspersoft Reports server (6.2), connect it to the created web datasource and run the report, it fails:How to resolve this? Is it a bug?I receive the same error when running the examples "Number of Pedestrians Injured - ElasticSearch (POST)"or "Top 10 Most Dangerous Streets - Elastic Search (POST)". However the example "Google Map From To Journey" does work. report XML:<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0 --><!-- 2016-02-25T14:25:42 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Test" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="fa06d267-761a-4f87-b3b8-dabbd7b6b8ae"><property name="com.jaspersoft.studio.data.defaultdataadapter" value="YesPlan"/><queryString language="WebServiceQuery"><![CDATA[{ "fieldsMap" : { "name" : "data.name", "starttime" : "data.starttime", "endtime" : "data.endtime" }, "getparameters" : { }, "fields" : [ { "name" : "name", "expression" : "data.name" }, { "name" : "starttime", "expression" : "data.starttime" }, { "name" : "endtime", "expression" : "data.endtime" } ], "options" : { "contentType" : "application/json", "rootPath" : "", "baseUrl" : "events/date%3A02-01-2009?api_key=XXXXXXXXXXXXXX" }, "headersMap" : { }, "queryData" : "", "GETParameters" : { }}]]></queryString><field name="name" class="java.lang.String"/><field name="starttime" class="java.lang.String"/><field name="endtime" class="java.lang.String"/><background><band splitType="Stretch"/></background><title><band height="79" splitType="Stretch"/></title><pageHeader><band height="35" splitType="Stretch"/></pageHeader><columnHeader><band height="61" splitType="Stretch"><staticText><reportElement x="0" y="0" width="185" height="30" uuid="d3354440-e33e-4cab-82b6-8aa76243bac7"/><text><![CDATA[name]]></text></staticText><staticText><reportElement x="185" y="0" width="185" height="30" uuid="ad4c35c3-f332-4d70-bbfa-b43706f8977c"/><text><![CDATA[starttime]]></text></staticText><staticText><reportElement x="370" y="0" width="185" height="30" uuid="8d07a3c8-11a3-40a6-bd05-6ed80eefa4ce"/><text><![CDATA[endtime]]></text></staticText></band></columnHeader><detail><band height="125" splitType="Stretch"><textField><reportElement x="0" y="55" width="185" height="30" uuid="3f6b8188-3a55-4024-84bc-7d8986a15520"/><textFieldExpression><![CDATA[$F{name}]]></textFieldExpression></textField><textField><reportElement x="185" y="55" width="185" height="30" uuid="63f5f80a-e547-442c-a7bd-3914980ffe8c"/><textFieldExpression><![CDATA[$F{starttime}]]></textFieldExpression></textField><textField><reportElement x="370" y="55" width="185" height="30" uuid="557f659b-1821-4c90-aada-933e6467f0c7"/><textFieldExpression><![CDATA[$F{endtime}]]></textFieldExpression></textField></band></detail><columnFooter><band height="45" splitType="Stretch"/></columnFooter><pageFooter><band height="54" splitType="Stretch"/></pageFooter><summary><band height="42" splitType="Stretch"/></summary></jasperReport> Link to comment Share on other sites More sharing options...
kkriplani Posted February 26, 2016 Share Posted February 26, 2016 Is the datasource connection successful?else, copy the jasperserver.log and share the file here.Regards,KKriplani Link to comment Share on other sites More sharing options...
pvbavel Posted February 28, 2016 Author Share Posted February 28, 2016 I,ve found the following in the jasperserver.log javax.net.ssl.SSLException: hostname in certificate didn't match: <chasse.yesplan.nl> != <*.yesplan.be> OR <*.yesplan.be> OR <yesplan.be> When I ping chasse.yesplan.nl then it returns yesplan.be, how to workarround this issue? Thnx... Link to comment Share on other sites More sharing options...
pvbavel Posted March 2, 2016 Author Share Posted March 2, 2016 Error Trace com.jaspports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:210) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:134) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:922) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:878) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1774) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1118) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1047) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:944) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.DiagnosticLoggingContextCompatibleExecutorService$1.run(DiagnosticLoggingContextCompatibleExecutorService.java:61) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Response is null! at com.jaspersoft.webservice.data.query.WebServiceQueryExecuter.createDatasource(WebServiceQueryExecuter.java:184) at com.jaspersoft.webservice.data.query.WebServiceQueryExecuter.createDatasource(WebServiceQueryExecuter.java:1) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:526) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119) ... 11 more Caused by: net.sf.jasperreports.engine.JRException: Response is null! at com.jaspersoft.webservice.data.util.WebServiceConnector.callWS(WebServiceConnector.java:149) at com.jaspersoft.webservice.data.query.WebServiceQueryExecuter.createDatasource(WebServiceQueryExecuter.java:172) ... 17 moreersoft.jasperserver.api.JSException: Error filling report Arguments: at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1294) at net.sf.jasperre Link to comment Share on other sites More sharing options...
zishanjms Posted December 29, 2016 Share Posted December 29, 2016 @pvbavel how do you resolve this issue? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now