date selection error BI4 infoView

[Former Member]

Hello community,

I’m facing a problem here and I am looking for your help

After migration to BI 4 I faced a problem with date selection prompt (In infoView) when I open or refresh a report.

For example, If I select 02/02/2013 00:00:00, the system change the input to 01/02/2013 23:00:00.

This is very urgent please help me

[Former Member · Accepted solution]

This is a bug in 4.1 which is logged with ADAPT01710199

Check the note below

930605 - BI4.1 - The time stamp in the prompt is changing every time on refreshing the report in HTML Mode of WebI Report

Following are the fixes for Business Intelligence Platform 4.1

• BI 4.1 SP01 Patch05
• BI 4.1 SP02 Patch01
• BI 4.1 SP03
• BI 4.1 SP03 Patch1
• BI 4.1 SP04

For a possible workaround, the Java Application server hosting BI Launchpad can be set to run using the UTC timezone to prevent time offsets in the prompt.

[Former Member · Accepted solution]

thank you Durgamadhab

i will try it.

[Former Member · Accepted solution]

I'm using Bi4.1 sp05 version but still facing the same problem

[Former Member · Accepted solution]

Hello,

I solved this issue one year ago by applying an SAP PATCH.

Let me know if you need more information.

Regards;

[Former Member · Accepted solution]

Hi youssef,

sorry for late reply,

which patch you used please let me know

[Former Member]

Adding the following parameter under 'Tomcat configuration - Java Tab' resolves the issue on windows.

-Duser.timezone=UMT

I would like to know if someone has tried this workaround on Linux?

[Former Member]

solved on AIX with start Parameters for Tomcat...

-Duser.timezone=UTC

[Former Member]

Hi,

Installed SP6 Patch6 and got it fixed finally.

SAP note 2221073

[Former Member]

Hi!

The Problem exists again. We have 4.1 SP6 patch 3 ...

summer / wintertime Problem. Workaround with UTC is not a good one... In this days it must be possible for a big Company like SAP to check summer/wintertime for all Versions.

We had this Problem in former days XI3.1 also ... It worked fine till 4.1 SP4 patch6 but when we updated we had the issue again ...

Incident is open...

😕 Tom

[Former Member]

Hi Thomas,

same problem with 4.1 SP6 Patch2.

Viewing a webi-report and selecting date input prompts is working fine (2015-12-14 00:00:00)

Scheduling a webi-report, selecting date input prompts and applying values, converts timestamp values to +2h. (2015-12-14 02:00:00).

Our timezone is UTC+2 (DST)

Any response from SAP?

Regards,

Tanel

[Former Member]

Thank you Durgamadhab

My version is BI 4.1 SP02 so i used Patch01 for BI 4.1 SP02.

[former_member197676]

Hi Youssef,

We have the same problem with SAP BusinessObjects BI Platform 4.1 Support Pack 1 Patch 2. After installing the patch have you fixed the issue?

Many thanks in advance,

[Former Member]

hello Jose Barnils,

The problem was fixed after installing the patch.