HANA LargeTimeDiff DBTime

[Former Member]

Hello,

I am installing BW on HANA and during installation got an error in step "Check DDIC Password".

When I check the logs I see that the system stops and I see this error

*** ERROR => AppServerTimeSync:

   LargeTimeDiff DB <-> Appl.Server: 3600 sec. [zdate.c 1694]

*** ERROR => AppServerTimeSync, LargeTimeDiff DBTIME - AppServerTime:

   AppServer time in internal format: 1414117447

   AppServer in local time: 2014/10/23 20:24:07 CT

   DBServer time in internal format: 1414121047

   DBServer time in local time (db_time): 20141023212407

   Of AppServer Timezone: UTC + sec 21600 (TZ not set) [zdate.c 1739]

The following command line we can see that the user of HANA "HDVADM" shows another hour.

In Honduras are currently 12:12:00 p m

admin @ hanadev: ~> date

Fri October 24 2014 12:12:13 CT

admin @ hanadev: ~> su cbdadm

Password:

hanadev: cbdadm 22> date

Fri October 24 2014 12:12:35 CT

hanadev: cbdadm 23>

Also in SAP HANA studio one hour ahead when Honduras current shown:

SELECT CURRENT_TIMESTAMP FROM DUMMY

CURRENT_TIMESTAMP

October 24, 2014 1: 12: 45.755 PM

As I can solve this problem.

Best Regards

[Former Member]

Hello,

Thanksyou all.

The problems is solved, the DBA of the client solved.

Best regards!

[RolandKramer]

Hi,

See the following Document - Implementation - BW on HANA Export/Import | SCN

Chapter 1.1.3.

This describes the Problem and the Solution.

Best Regards

Roland

[Former Member]

Hi Hidalgo,

I solved the problem by changing the timezone of the HANA Operating system user to the same location of the Application Server, in my case "TZ = America / Sao_Paulo" in  .sapenv*sh  files

Best Regards

Ricardo Nunes

[JimmyYang]

Hi Ricardo,

What were your indexserver.ini settings for the use_startup_timezone?

Best Regards,
Jimmy

[Former Member]

Hi Jimmy,

There are no use_startup_timezone parameter in indexserver file (probably is there the default ),   but what worked for me was the time zone settings for  sidadm user in the  .setenv.csh file .

Regards,

Ricardo

[Former Member]

By default this parameter is hidden until unless you have made it to false explicitly.

[JimmyYang]

Hi,

There is a note that is more specific to HANA.

1932132 - Large time difference between application server and HANA database

This note describes steps to import the TZ tables and then set the use_startup_timezone parameter so that HANA will use the TZ tables.

This note is used a lot to resolve any timezone issues.

Best Regards,
Jimmy

[Former Member]

Hi Jimmy,

I'm having the same problem that Hidalgo. Note that you suggested is not released by SAP. Is there any other known solution?

Best Regards,

Ricardo

[Former Member]

Hello Ricardo -

Last week this note 1932132 is taken back by SAP and its under update - you should implement this note so that you can load TZ tables in your hana box in order to avoid this error during TZ change.

Thanks

Dev

[Prabhith]

Hi ,

It seems like the time services are not synchronised.

There is a very generic old note in the topic DATE_LARGE_TIME_DIFF

101726 - Incorrect times and time zone setting

BR

Prabhith

[hugo_amo]

Hi Hidalgo,

Make sure that the time synchronization is configured correctly on both servers. It seems that the timezone of one server is not your local timezone, explaining the time difference.
Also make sure that the server time is synchronized with a time server.
Execute on both servers:

"net time /setsntp:" followed by the hostname of the time server / NTP server

You can check the time configuration by "net time /query".

And reboot both servers.

Hope this helps.

Regards,

Hugo

[Former Member]

Hello Hugo,

Thanks for your hep,

Both services are on the same server. As it currently allows SAP.

Users have the same time set, but in SAP HANA Studio continues one hour ahead

SELECT CURRENT_TIMESTAMP FROM DUMMY is the query

I continuous with the problem.

Best regards

[Former Member]

Sorry,

Add line for hana user:

hanadev:~> date

Fri Oct 24 18:09:07 UTC 2014

hanadev:~> date

Best regards