Parameter DATABASE_TIMEZONE does not exist- urgent

Posted on September 18, 2008 at 12:48pm

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...

JasperReports® Server
rghanta's picture
rghanta
114
Joined: Aug 29 2008 - 8:56am
Last seen: 15 years 1 month ago

11 Answers:

Posted on September 18, 2008 at 4:03pm

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

gabrielinux's picture
gabrielinux
1234
Joined: Apr 20 2007 - 8:27am
Last seen: 16 years 5 months ago
Posted on September 19, 2008 at 6:13am
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
rghanta's picture
rghanta
114
Joined: Aug 29 2008 - 8:56am
Last seen: 15 years 1 month ago
Posted on September 19, 2008 at 7:11am

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

lucianc's picture
lucianc
87143
Joined: Jul 17 2006 - 1:10am
Last seen: 17 hours 24 min ago
Posted on September 22, 2008 at 11:05am
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
rghanta's picture
rghanta
114
Joined: Aug 29 2008 - 8:56am
Last seen: 15 years 1 month ago
Posted on June 30, 2009 at 3:02am

 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.

sillybyte's picture
sillybyte
25
Joined: Jun 30 2009 - 2:52am
Last seen: 14 years 3 months ago
Posted on July 1, 2009 at 7:32pm

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

swood's picture
swood
24617
Joined: Jun 21 2006 - 12:48pm
Last seen: 10 years 11 months ago
Posted on August 10, 2009 at 5:45pm

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

kellyxia's picture
kellyxia
19
Joined: Jul 24 2009 - 6:02pm
Last seen: 14 years 2 months ago
Posted on August 12, 2009 at 4:49pm

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

swood's picture
swood
24617
Joined: Jun 21 2006 - 12:48pm
Last seen: 10 years 11 months ago
Posted on November 2, 2011 at 5:13am

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.

 

munkee's picture
munkee
12
Joined: Jan 17 2011 - 2:37am
Last seen: 12 years 8 months ago
Posted on November 2, 2011 at 12:48pm
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:\\\\...."
raylee's picture
raylee
183
Joined: Feb 18 2010 - 12:06pm
Last seen: 13 years 7 months ago
Posted on November 3, 2011 at 5:50am

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.

munkee's picture
munkee
12
Joined: Jan 17 2011 - 2:37am
Last seen: 12 years 8 months ago
Feedback
randomness