Jump to content

Date parameter passing incorrect date (T-1)


Recommended Posts

After we upgrade our server (commercial) to 4.7.1 from 4.5.1, all our reports are being generated for T-1 instead of current date.  Not just the automated reports but it's the same story when run manually.  If you select 11/01/2012 on the calendar, it'll run the report for 10/31/2012.

Initial research seems to point to a timezone discrepancy but we've sync'd all the timezones in our environments.  CentOS, Java, Tomcat6, Jasper 4.7.1.  It also said to "blank" out the timezone setting under datasource, it's a drop down and ours was already set to "use setting from database"  (I'm guessing this is what they mean by "blank"ing it out.


Please help.

Link to comment
Share on other sites

  • 2 weeks later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic


Please check that you log in to jasperserver using same timezone as you database, and jasperserver instance. 
If this not help check type of your datasource JDBC or JNDI?
If JDBC then try to switch to JNDI.
If nothing helps as a last resort you can edit datasource and select different timezone for it, so in runtime it will show correct value but it is not recommended way, better is just to upgrade to 5.0 there  several timezone issues was fixed.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...