Parameter DATABASE_TIMEZONE does not exist- urgent

[rghanta]

My requirement in one of the reports is to fetch two different fields using two different queries. So I am using sub report for the same. I developed the report with a sub report and it works perfectly in iReport. But when I deployed the Jasperreport in jasperserver and run it, it throws an error “Parameter DATABASE_TIMEZONE does not exist”. Can some body provide a solution for this? Also is there any other way to eliminate subreport and achieve my requirement?

Thanks in Advance.

Ram...

[gabrielinux]

In iReport, go to View -> Paremeters and make sure your parameters are defined.  If they aren't, add them.

[rghanta]

Hi Gabriel,

 

Thanks for your quick response. But my issue is not with iReport. With iReport my report is working fine and I get this error only when I deploy the report in Jasper Server.

 

Thx,

Ram

[lucianc]

I guess that your master report is referring to *.jasper files compiled by iReport.

This would not work, you'll need to upload the subreport JRXMLs to JasperServer as file resource, and used repo: URIs as subreport expressions in the master report.

Regards,

Lucian

[rghanta]

Thank you Lucian...It works for me if I use the subreport JRXML files and change the expressions to repo:.

 

Thank you once again.

 

Best Regards,

Ram

[sillybyte]

 Hello,

I am facing the same error,  could you help me understand how you have included the files form the repository. When i tried uploading the files to the repository, jasperserver could not find the jrxml files.

[swood]

How did you add the subreport JRXML files into JasperServer?

 

Did you change your master report to refer to the subreport JRXMLs with a "repo:/<folder>/<folder>/name" reference?

 

Sherman

Jaspersoft

[kellyxia]

I have the same problem and I tired:

"repo:/opt/jasperserver-3.5.0/ireport/MitsuwaReportJrxmlFiles/byStoreSub.jrxml"

but japserserver game me an error:

com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error loading object from URL : repo:/opt/jasperserver-3.5.0/ireport/MitsuwaReportJrxmlFiles/byStoreSub.jrxml

did i do it wrong?

Thanks.

 

Kelly Xia

[swood]

You have to load the JRXML file into the JasperServer repository, not into the JasperServer WAR or file system. The "repo://..." URI points to folders and resources in the repository.

 

Sherman

Jaspersoft

[munkee]

Hi,

Sorry to dig up old forum posts, Its just this is the exact issue that I'm facing.

Whilst using: ireports 4.0.2 & Jasperreports server 4.1.2

I just dont get where to change the expressions to repo: on the subreports.

Is it whilst adding a Resource as a Jrxml Type, Resource bundle.

Does the repo: part go in front of the 'ID', 'Name' or 'Resource File' ?

The only error that I receive whilst trying to 'Run JasperServer Report' from within ireports or JSR's is:

'Parameter "DATABASE_TIMEZONE" does not exist'

 

Please can someone shed some light on this?

Many thanks.

 

[raylee]

I'm not sure why that error exists but to get around it I just created a parameter called DATABASE_TIMEZONE with no default value and type java.util.TimeZone and that got rid of the error.

 

repo: isn't specified on the subreport. It's specified on the main report or report using the subreport. Specifiy it in the "Subreport Expression" instead of "C:\\...."

[munkee]

Brilliant, thanks for telling me how to get rid of that annoying 'DATABASE_TIMEZONE' Error.

One final thing, I cannot seem to get the format of the "Subreport Expression" correct.

I've tried

repo:\\Reports\Current_files\Tenure.jrxml

repo:Tenure.jrxml

repo:\\Tenure.jrxml

None of the above work, I'm pretty sure that I'm doing something very simple wrong.

When I run the report from either iReports or Jasperreports Server on the web, I get the error:

iReports: Resource not found at : Tenure.jrxml

Web UI: com.jaspersoft.jasperserver.api.JSExceptionWrapper: Resource not found at : Tenure.jrxml

 

Thanks.