"com.jaspersoft.jasperserver.api.JSException: Error filling report" and "net.sf.jasperreports.engine.JRException: Resource not found"

Posted on September 27, 2013 at 1:15am

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Hi Attached is the copy of my jasper report which has 3 subreports in it. While running it I am getting below errors:

Please help to crossveryfy the rxml and let me know if this error is due to subreport path or I need any other modification ?

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 net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:695) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1474) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:874) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:754) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: net.sf.jasperreports.engine.JRException: Resource not found at : ////reports////subreports////report8_subreport1.jrxml 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(JRFillSubreport.java:287) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:257) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:457) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:337) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:273) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:144) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) ... 9 more

Error Message
net.sf.jasperreports.engine.JRException: Resource not found at : ////reports////subreports////report8_subreport1.jrxml

Error Trace
net.sf.jasperreports.engine.JRException: Resource not found at : ////reports////subreports////report8_subreport1.jrxml 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(JRFillSubreport.java:287) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:257) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:457) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:337) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:273) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:144) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:733) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:695) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1474) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:874) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:754) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619)

Attachments:

report10_-_copy.jrxml

iReport Designer

JasperReports® Server

ujjawalkhare11

Joined: Sep 26 2013 - 5:22am

Last seen: 8 years 4 days ago

4 Answers:

Posted on September 27, 2013 at 6:36am

Here is the solution:

1. login to jasperserver.

2. Go to View-->Repositry

3. Right click on Reports-->Add Resource-->File-->jrxm

4. Choose below:

a. Type of File: JRXML

b. Upload subreport.jrxml from your system (if more then one subreports then upload one by one after you complete procedure of uploading frist jrxml file.)

c. Give a name for your jrxml file in name field. (In my case i gave name as report8_subreport1, report8_subreport2 and report8_subreport3

d. save loacation: /reports and click on submit.

5. After you upload all subreports now its time to edit subreport dir in main.jrxml file.

Follow the steps below.

Note. Name given to subreport jrxml files is actually should be involved in jrxml dir path. so here our path of subreports should follow below patterns:

"repo:/reports/<name_of_subreport>"

so in my case this path will be :

"repo:/reports/report8_subreport2"

so in main.jrxml file i will have to mention like below:

Be noted that in DefaultValueExpression field we need to give local path of our system where main.jrxml file is saved.

for reference i am also attaching my main.jrxml file here (report10-Copy.jrxml)

6. Now once editing of main.jrxml is done again follow the steps that were used to upload subreport.jrxml files.

7. Now its time to create a link with database to run our report:

a. Go to report-->Add Resource-->JasperReport

b. Give a name to report (this name will be the link to run your report)

c. choose "select a jrxml from repositry" and under brouse in "Reports" you can find your main.jrxml file as a namethat was choosen by you while uploaded main.jrxml.

d. click on datasource and choose a database connection from which you are retrieving the report.

e. Click on submit.

Now your report is ready to run. Just click on link of you final setup (will appear under "Reports") and your report will run.

"HAVE FUN"

Attachments:

Attachment	Size
report10_-_copy.jrxml	3.66 KB

ujjawalkhare11

Joined: Sep 26 2013 - 5:22am

Last seen: 8 years 4 days ago

Posted on September 27, 2013 at 2:44am

At a first glance this looks like a path issue

Caused by: net.sf.jasperreports.engine.JRException: Resource not found at : ////reports////subreports////report8_subreport1.jrxml

I'd say, check your path.

I encounterd a similair issue when running a report with subreports in iReport Designer while the report was on the Jasperserver (imported via the repositorybroweser)

Later i figured i only could preview the report through the Japserserver.

sjoerd.jump

521

Joined: Oct 29 2012 - 2:39pm

Last seen: 9 months 4 weeks ago

Hi I have changed path as suggested by you and now it says:-
"Repository file resource ////reports////subreports////report8_subreport1.jrxml could not be loaded"

My jrxml file entry is as below:

ujjawalkhare11 - 8 years 9 months ago

add comment

Posted on October 2, 2013 at 3:17am

Try this as subreport expression

<![CDATA["repo:/reports/subreports/report8_subreport1_jrxml"]]>

hopes it helps..let me know..

hishamkmr

438

Joined: Sep 4 2013 - 5:07am

Last seen: 8 years 2 months ago

No I have tried by keeping this expression
<![CDATA["repo:/reports/subreports/report8_subreport1_jrxml"]]>
also...
I got the same error like "/reports/Filename.jrxml" file could not be loaded.
May I know the reason?
Thank you

s.jyothsna1 - 8 years 6 months ago

File could not be loaded means something is wrong with jrxml file..I didn't have passed the parameter to subreport.
Any how its working fine now..
Thank you

s.jyothsna1 - 8 years 6 months ago

I am using parameter with subreport and got error "Repository file resource /reports/sinc/07.Cargue_por_entidades_obligadas_subreport1 could not be loaded"

vivek_satle - 6 years 9 months ago

add comment

Posted on December 4, 2013 at 11:26pm

general solution to this is described here: http://stackoverflow.com/a/20374515/1915920

andreasX

369

Joined: Nov 8 2013 - 2:31am

Last seen: 5 years 3 months ago

Main menu

"com.jaspersoft.jasperserver.api.JSException: Error filling report" and "net.sf.jasperreports.engine.JRException: Resource not found"

Jaspersoft Community 'Read-Only' as of July 8, 2022

4 Answers:

Tags

Main menu

You are here

"com.jaspersoft.jasperserver.api.JSException: Error filling report" and "net.sf.jasperreports.engine.JRException: Resource not found"

Jaspersoft Community 'Read-Only' as of July 8, 2022

4 Answers:

Tags