This discussion is archived
0 Replies Latest reply: Nov 16, 2010 12:25 AM by 814283 RSS

ThinGraph timezone / dateFormat problem

814283 Newbie
Currently Being Moderated
Hey,

We're using BI Beans to display history statistics concerning security attacks/issues per day. Normally, the X-axis looks like this (dots act like spaces):

18....21....24....27....30....02....05....08....11....14
Oct 10............................Nov............................

A customer of ours complained last week about his graph labels on the X-axis to be displayed incorrectly. They sent a screenshot displaying the labels like this (*vertically* aligned underneath the X-axis, dots act like spaces):

2010-....2010-....2010-....2010-....2010-....2010-....

We were thinking this had to do with the daylight saving time switch of last week, so we started to investigate why especially this customer had problems and the others didn't. Then we saw that the Java timezone was set to Australia/Sydney instead of our software's default Etc/GMT. That seemed to be causing the problem described here. It appears that the Tasmanian timezone is the only Australian Timezone that shows the X-axis labels correctly.

We currently changed the customer's timezone to the one above, but what could be causing the dateFormat to be displayed incorrectly? It seems the Date objects are just printed out as 2010-10-18 hh:ss (only the '2010-' part is visible on the graph), instead of actually formatting them.

I already did a search on Google and this forum, but I can't seem to find any thread concerning the problem we have.

The version of the library we're using (and this in a Java 1.5 environment):

ComponentBuildVersion=3.2.2.0.24.2
ComponentBuildMode=nondebug
Copyright=Copyright ¬ 2001, 2005, Oracle. All rights reserved.
ComponentNumber=10.1.2.67.0
ReleaseDescription=BI Beans 10.1.2 Production Release

We're not actually defining a custom dateFormat in our XML configuration. We only use the predefined Oracle constants, which have always worked up until now, for the default timezone:

<Graph version="3.2.0.22" name="Graph" ... timeAxisTimeFormat="NONE" timeAxisDayFormat="AUTOMATIC" timeAxisMonthFormat="MONTH_SHORT" timeAxisYearFormat="YEAR_SHORT" graphType="LINE_VERT_ABS">

Anyone else had this problem?



Thanks and kind regards,

Jeroen

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points