Error: An error occurred during report execution

[ariahi]

Error: An error occurred during report execution.
The report could not be executed: No subreport of name rsfsx://jaspersubreport/e746ea16-6f67-4d42-b22f-d1aee4993fe8/logo found.
To get help please contact an administrator.
Details
net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: No subreport of name rsfsx://jaspersubreport/e746ea16-6f67-4d42-b22f-d1aee4993fe8/logo found.

Please help me

[phillipjohnson]

For anyone else coming across this, it seems to be a compilation error with the sub-report. Here was my solution:

• Upload each sub-report as its own master report
• Run the sub-reports until you find one with an error. I had an error with an unsupported enumeration for stretchType
• Fix the sub-report
• Re-upload the corrected sub-report on the master report

[aaronmartin1651]

EDIT:
I have a very detailed post (still unsolved at the moment) that may be helpful to read through

https://forum.reportserver.net/viewtopic.php?id=781

My report does not have any subreports and I am getting this error. Any suggestions?

[IF_Eduardo]

For completeness:

@aaronmartin1651

Issue appears to be with Jasper Studio installation, somehow when creating a JRXML file it is inserting data that makes ReportServer believe there is a subreport present even when there is not. Subsequent installs on other pcs allow the creation of reports and uploading of reports with no problems.

Cheers,
Eduardo

[saroshmk]

I see the same message on my instance of ReportServer

Error: An error occurred during report execution.
The report could not be executed: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: TileDS.
To get help please contact an administrator.

I have a Jasper Report with 7 subreports. The offending subreport had a Dataset called TileDS, which was removed. But even after uploading the latest subreport, RS seems to be referring to the older JRXML.

I’ve deployed the subreport on it’s own and run it. It executes without a compilation error.

Are the JRXMLs cached? Is there a way to clear it?

[saroshmk]

The issue is resolved! I missed checking catalina.out There was an SQL error. Resolving it sorted the problem out.

The error message involving the older Jasper dataset name got me thinking wrong. Looks like if the code doesn’t compile under RS, it errors with reference to the version of code it holds (as against the version that was just uploaded).

Is this right?

[IF_Eduardo]

Hello saroshmk,

are you sure the log entry corresponds with your execution attempt, and not with a past error ? When you replace a subreport with a newer version, the subreport is compiled during upload. It is hard to imagine that after this old references exist. Please check again.

Regards,
Eduardo