Report working in Jaspersoft Studio but not on Jaspersoft server?

Posted on February 25, 2016 at 5:37am

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>

 

Web Service Data Source
pvbavel's picture
pvbavel
54
Joined: May 28 2013 - 11:47pm
Last seen: 6 years 11 months ago
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 more
ersoft.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

 

pvbavel - 7 years 2 weeks ago
add comment

3 Answers:

Posted on February 26, 2016 at 4:49am

Is the datasource connection successful?
else, copy the jasperserver.log  and share the file here.

Regards,
KKriplani

kkriplani's picture
kkriplani
5022
Joined: Sep 4 2015 - 2:18am
Last seen: 11 months 1 week ago
Posted on February 28, 2016 at 2:03am
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...
pvbavel's picture
pvbavel
54
Joined: May 28 2013 - 11:47pm
Last seen: 6 years 11 months ago
Posted on December 29, 2016 at 12:33am

@pvbavel how do you resolve this issue?

zishanjms's picture
zishanjms
54
Joined: Dec 22 2016 - 10:35pm
Last seen: 6 years 2 months ago
Feedback
randomness