Webi Report 'LastExecutionTime' is One Hour Ahead

[Former Member]

BI 4.1 Server & Client SP4 no fix packs, MS Server 2008 R2 Standard

We have BO Enterprise installed on a server set to local time (LIMA which does not have DST). Unfortunately as per the screenshot, from both Webi thick and thin clients, the LastExecutionTime and LastExecution data are always one hour behind.

Is there a way to resolve this?

Have checked server time

Have checked system locale

[Former Member · Accepted solution]

Hello Joe,

Such issue observed when Day Light Saving takes place.

Verify the time on the server where application server (Tomcat) is installed. I believe you can do it by log in to CMC, selecting the CMC preferences. Make sure you have time zone set to Default - Local to web server in CMC and Infoview preferences.

Regards,

Mahesh

[Former Member · Accepted solution]

Hi....as per the screenshot it looks OK to us. Any other ideas?

[Former Member]

If you're using JAVA, you need to have run the TZUpdater tool provided by Sun. Once we ran that, all the timestamps became correct. Also, ESD, MST and HST all have an extra bug that requires an additional fix from Sun.

[former_member230417]

Hi Joe,

Please try to Hardcode your timezone in Tomcat Server.

--Stop Tomcat application server.

--Go to Tomcat configuration.

--JAVA tab -> Java options.

--Add –Duser.timezone= <your time zone>

--Start the tomcat.

Refer to the below link add the right timezone for your location.

http://bytes.com/topic/java/answers/15954-alphabetic-java-time-zones-continent-ocean-city-format

Regards,

Nachiket

[Former Member]

Hi there, we tried but got the following error (and TC wouldnt start again)