: Parameter "DATABASE_TIMEZONE" does not exist.

Posted on March 14, 2016 at 12:10pm

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: exception
 
net.sf.jasperreports.engine.JRRuntimeException: Parameter
"DATABASE_TIMEZONE" does not exist.
 
    at
net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:869)
 
    at
net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:887)
 
    at
com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.getValueParameter(JRTimezoneJdbcQueryExecuter.java:148)
 
    at
com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.<init>(JRTimezoneJdbcQueryExecuter.java:132)
 
    at
com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory.createQueryExecuter(JRTimezoneJdbcQueryExecuterFactory.java:51)
 
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1126)
 
    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.BaseReportFiller.fill(BaseReportFiller.java:396)
 
    at
net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:742)
 
    at
net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:58)
 
    at
net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:216)
 
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
 
    at
java.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 execution
 
net.sf.jasperreports.engine.JRRuntimeException: Parameter
"DATABASE_TIMEZONE" does not exist.
 
    at
net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:869)
 
    at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:887)
 
    at
com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.getValueParameter(JRTimezoneJdbcQueryExecuter.java:148)
 
    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.<init>(JRTimezoneJdbcQueryExecuter.java:132)
 
    at
com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory.createQueryExecuter(JRTimezoneJdbcQueryExecuterFactory.java:51)
 
    at
net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1126)
 
    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.BaseReportFiller.fill(BaseReportFiller.java:396)
 
    at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:742)
 
    at
net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:58)
 
    at
net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:216)
 
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
 
    at
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 
    at java.lang.Thread.run(Unknown Source)

When i call subjreport directly that's Ok

Where is my mistake

Regards

Phil

Jaspersoft® ETL
pcouas_1's picture
pcouas_1
217
Joined: Mar 31 2013 - 5:58am
Last seen: 6 years 4 months ago

3 Answers:

Posted on March 14, 2016 at 1:51pm

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.

hozawa's picture
hozawa
177225
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago
Posted on March 14, 2016 at 10:03pm

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's picture
pcouas_1
217
Joined: Mar 31 2013 - 5:58am
Last seen: 6 years 4 months ago
Posted on March 15, 2016 at 1:31am

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

 

 

pcouas_1's picture
pcouas_1
217
Joined: Mar 31 2013 - 5:58am
Last seen: 6 years 4 months ago
Feedback