DATABASE_TIMEZONE

[sushmitas]

Hello,

 

I have published a master report which contains one subreports.

I get below error..

Can you suggest me inorder to solve this problem.

Code:

Post Edited by sushmita shyamal at 02/18/09 17:18

Post Edited by sushmita shyamal at 02/19/09 12:42

[lucianc]

See here.

HTH,

Lucian

[sushmitas]

Hello Lucian,

 

I tried this also but still the problem is same.....

 

 

Code:

<subreport><reportElement x="0" y="60" width="200" height="74"/>				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression><subreportExpression class="java.lang.String<![CDATA[$P{SUBREPORT_DIR} + "report1_subreport1.jasper"]]></subreportExpression></subreport>

[sushmitas]

Thanx a lot. I have solved it.

[highjo]

hello!

i'm having the same issue with the jasperserver 3.7RC and since i'm new i have some questions for you guys.

1. i don't really know where to make that change.I'm confused i don't if i should be in ireport in which case will edit the jrxml file on my file system let's say D:/work/ireport/myproject/thefile.jrxml or i should find it somewhere in the deployed jasperserver in my tomcat webapps folder.

2 if we load the file from the jasperserver add Ressource->jasperreport or add Ressource inside the definition of another report(the main report in this case) where is that file loaded.

Thank you very much for reading

[highjo]

i've fixed it.seems like you have to do it from the ireport.i'ld like to know how to do it manually though

[sudhanshu2t1]

 Hi all 

 

 when i try to run a jasper report on server 4.5 >I am getting  this 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:606) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:621) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.getValueParameter(JRTimezoneJdbcQueryExecuter.java:150) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.<init>(JRTimezoneJdbcQueryExecuter.java:134) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory.createQueryExecuter(JRTimezoneJdbcQueryExecuterFactory.java:50) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:728) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:629) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1159) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:802) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:746) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:640) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:205) at java.lang.Thread.run(Thread.java:619)