DST Issue?

[former_member190781]

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

[onkarvelhals · Accepted solution]

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

[johannes_nissen · Accepted solution]

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

[johannes_nissen · Accepted solution]

I have rolled back to Patch01 of ServicePack06.

within this Patchlevel it seems to work.

[former_member190781 · Accepted solution]

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.

[former_member190781 · Accepted solution]

Onkar your solution worked! I was doing it wrong. I entered Duser.timezone=CST as per my server timezone whereas I had to enter Duser.timezone=UTC in Tomcat > Java parameters which resolved the issue.

Appreciate your help

[onkarvelhals · Accepted solution]

Glad to hear it worked!

[former_member190781 · Accepted solution]

Although it fixed the issue but the parameter is causing all the times in UTC only. Both from BI Launchpad and CMC if you have selected web browser locale.