Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Regards,

Sohel

Tags:
replied

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.

Improvising:
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.

Regards,

Onkar

2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question