pcouas_1 Posted March 14, 2016 Share Posted March 14, 2016 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 jasperServeri have following eror message2016-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 OkWhere is my mistakeRegardsPhil Link to comment Share on other sites More sharing options...
hozawa Posted March 14, 2016 Share Posted March 14, 2016 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. Link to comment Share on other sites More sharing options...
pcouas_1 Posted March 15, 2016 Author Share Posted March 15, 2016 Hi,I use Report 5.6.0 BUT JasperServer 6.2In my main Report i have following line <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "report38.jasper"]]></subreportExpression> Regards Link to comment Share on other sites More sharing options...
pcouas_1 Posted March 15, 2016 Author Share Posted March 15, 2016 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 RegardsPhil 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