Environment: BI 4.1 SP06 patch 3
Windows Server 2008 R2 SP1
Clustered environment with 2 CMS and 2 Web servers
SQL Server 2012
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.
Onkar Velhal replied
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.