: Parameter "DATABASE_TIMEZONE" does not exist.

[pcouas_1]

Hi,

I have make an report with an SubReport with IRepor 5.6.0 and subReport name is name38.jasper, but when i call it from jasperServer

i have following eror message

2016-03-14 19:09:16,561 ERROR JRFillSubreport,pool-4-thread-24:878- Fill 1: exceptionnet.sf.jasperreports.engine.JRRuntimeException: Parameter"DATABASE_TIMEZONE" does not exist.    atnet.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:869)    atnet.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:887)    atcom.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.getValueParameter(JRTimezoneJdbcQueryExecuter.java:148)    atcom.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.<init>(JRTimezoneJdbcQueryExecuter.java:132)    atcom.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory.createQueryExecuter(JRTimezoneJdbcQueryExecuterFactory.java:51)    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1126)    atnet.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)    atnet.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437)    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:526)    atnet.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:396)    atnet.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:742)    atnet.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:58)    atnet.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:216)    at java.util.concurrent.ThreadPoolExecutor.runWorker(UnknownSource)    atjava.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)    at java.lang.Thread.run(Unknown Source)2016-03-14 19:09:16,562 ERROR AsyncJasperPrintAccessor,pool-4-thread-24:315 -Error during report executionnet.sf.jasperreports.engine.JRRuntimeException: Parameter"DATABASE_TIMEZONE" does not exist.    atnet.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:869)    at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:887)    atcom.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.getValueParameter(JRTimezoneJdbcQueryExecuter.java:148)    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.<init>(JRTimezoneJdbcQueryExecuter.java:132)    atcom.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory.createQueryExecuter(JRTimezoneJdbcQueryExecuterFactory.java:51)    atnet.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1126)    atnet.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)    at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437)    atnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:526)    atnet.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:396)    at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:742)    atnet.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:58)    atnet.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:216)    at java.util.concurrent.ThreadPoolExecutor.runWorker(UnknownSource)    atjava.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)    at java.lang.Thread.run(Unknown Source)[/code]

When i call subjreport directly that's Ok

Where is my mistake

Regards

Phil

[hozawa]

Your biggest mistake is in using JasperReports Server 5.6.0 because it's no longer supported. It contains bugs. Recommend you version up to 6.2.0.

[pcouas_1]

Hi,

I use Report 5.6.0 BUT JasperServer 6.2

In my main Report i have following line

    <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "report38.jasper"]]></subreportExpression>

 

Regards

 

 

[pcouas_1]

Hi,

 

I have resolved problem with replace

    <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "report38.jasper"]]></subreportExpression>

BY

  <subreportExpression><![CDATA["repo:report38Ress"]]></subreportExpression>

Then i have added an Ressource named report38Ress to my parent master Report in JasperServer. This new ressource is subReport jrxml file

 

Regards

Phil