on 11-02-2015 4:31 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I'm having exactly the same problem. in Timezone CEST (GMT+1)
Does anyone have SP06 installed and not having this issue? I'm currently working through the Patches and try to find out if one of those causes this or if it's related to SP06 installation.
I have raised an incident as well.
Regards - Johannes
Thanks Onkar, SAP also informed the same. As you suggested tried hardcoding timezone which didnt help.
Looks like we have to plan patch upgrade every month as whenever we raise an incident most of the times it ends up as a bug. in last three months we have patched our environments 3 times
Requested SAP to provide some workaround in the current patch BI 4.1 SP06 Patch 3 as one more sudden patch upgrade would be difficult for us. Looking forward for SAP's response.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.