error with jasperreport subreports

[ujjawalkhare11]

Hi I am trying to populate a report using jasperserver. My main report has 3 subreports while running this report on ireport it works fine but in jasperserver it is throwing below exceptions:

The server has encountered an error. Please excuse the inconvenience.

 

Error Message

com.jaspersoft.jasperserver.api.JSException: Error filling report

Error Trace

com.jaspersoft.jasperserver.api.JSException: Error filling report at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1030) at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:211) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:135) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:733) at

Error Message

net.sf.jasperreports.engine.JRException: Resource not found at : report8_subreport1.jasper

Error Trace

net.sf.jasperreports.engine.JRException: Resource not found at : report8_subreport1.jasper at net.sf.jasperreports.repo.RepositoryUtil.getResourceFromLocation(RepositoryUtil.java:255) at net.sf.jasperreports.repo.RepositoryUtil.getReport(RepositoryUtil.java:208) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateReport(JRFillSubreport.java:329) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:359) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate

 

Attaches is my main.jrxml file.

be noted that when giving subreports parameter as $P{SUBREPORTS_DIR} + "report8.subreport.jasper" ---> Its throwing DATABASE_TIMEZONE error. so by both methods I am getting error. Please suggest a possible modification.

 

[ujjawalkhare11]

Hi Updated SUBDIR path as :-
<subreportExpression class="java.lang.String"><![CDATA["C://Users//ukhare//Desktop//report//report8_subreport2.jasper"]]></subreportExpression>

Now getting below error:

 

The server has encountered an error. Please excuse the inconvenience.

 

Error Message

net.sf.jasperreports.engine.JRRuntimeException: Parameter "DATABASE_TIMEZONE" does not exist.

Error Trace

net.sf.jasperreports.engine.JRRuntimeException: Parameter "DATABASE_TIMEZONE" does not exist. at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:646) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:661) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.getValueParameter(JRTimezoneJdbcQueryExecuter.java:148) at

Updated main jrxml is also attached.

 

 

 

[hishamkmr]

is it populating data from i-report and throwing error only at jasper server?

 

[dheerursm]

I do have similar problem with one of my report. My main report and subreport are working good when I run them in Jasper studio but when once I publish both the main report and sub report to jasper server, reprot is returning with the same error.

 

Please let me know if you find any solution.

 

Thanks.