Skip to Content

DST Issue?

Environment: BI 4.1 SP06 patch 3

Windows Server 2008 R2 SP1

Clustered environment with 2 CMS and 2 Web servers

SQL Server 2012

Webi reports

Issue: while creating a new schedule when we select the date parameters and apply the dates after clicking on apply the dates are getting changed.

Example: In one report I started creating new schedule and click on parameters and selected following dates as start and end date.

Start Date 11/01/2015 12:00:00 AM End Date 11/30/2015 12:00:00 AM

Once click on apply, the parameters show dates as below. (This is for server in CST timezone)

Start Date 10/31/2015 7:00:00 PM End Date 11/29/2015 6:00:00 PM

And for servers in PST time zone the times are getting changed as below.

Start Date 10/31/2015 5:00:00 PM End Date 11/29/2015 4:00:00 PM

Our Dev server is in CST time zone and TEST and PROD is in PST timezone.

I am wondering if its a DST related issue as the users started reporting this issue today only, tried rebooting the servers but didn't help.

Have raised an incident with SAP waiting for their response.

FYI, no issues with report refresh.



Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Nov 02, 2015 at 06:07 PM

    Hi Sohel,

    I guess this shouldn't be related with DST. It smells like bug which was documented in 1892328 or 1931911 (offset here looks like its -6 hours which is GMT; so time is changed to GMT). However nothing seems to match exactly with this behavior.

    You can check Java timezone and change Duser.timezone similar to the server timezone.

    Also, check what is time zone for web servers and change it to CST.

    Hope this helps.



    Add comment
    10|10000 characters needed characters exceeded