Inconsistency in UTC time for operating system and SAP found

[Former Member]

Hi expert,

I constructed ERP on HANA by using DMO of SUM.

Now , my system is SAP ERP 6.0 EHP 7. And my DB is SAP HANA SP7 rev70 .

When I executed Tr-CD:ST03N , the below message was appeared :

Inconsistency in UTC time for operating system and SAP found. See SAP Note 926290.

So I saw SAP Note 926290 and I checked system time zone for both OS and SAP system(R/3 level) .

Then I changed system time for SAP system by using Tr-CD:STZAC to djust time zone for OS.

After that , I used report "TZCUSTHELP" to check whether different time zones are used at OS level and R/3 level .

There is no error massege .

But the message "Inconsistency in UTC time for operating system and SAP found. See SAP Note 926290." is appeared yet .

I guess I have to check system time zone for SAP HANA .

But I don't know the way how to check  system time zone for SAP HANA and change that.

Please tell me the way how to check  system time zone for SAP HANA and change that.

Thanks in advance .

Kazuki.

[Former Member · Accepted solution]

SSH to the OS and run command: date

This will tell you the current date and time.

You can update the time and date with this command, but it is best to sync HANA to an NTP server at the OS level.

[Former Member · Accepted solution]

Hi Jack,

Thank you for reply.

I checked the current date and time that HANA DB's OS  by using command : date.

The below massege was appeared :

Wed Feb 12 12:13:18 JST 2014

JST is UCT + 9H . And R/3 system's timezone is JAPAN(UCT + 9H) , AP server's timezone(R/3's OS)  is JAPAN(UCT + 9H).

So both R/3 system and DB server and AP server have same time zone .

Do I have to check timezone in not HANA DB server(OS) but HANA DB itself ?

Thanks in advance .

Kazuki.

[Former Member · Accepted solution]

Kazuki,

Run report RSDBTIME. This will show DB, kernel and ABAP time and where the inconsistencies may be.

What does this show?

-Jake

[Former Member · Accepted solution]

Hi Jake,

Thank you for reply.

I ran report RSDBTIME. Then the below massege was appeared :

--------------------------------------------------------------------------------------------------------------------------------------

Warning : Time Different detected !

Typical error reasons:

- different timezone setup for database and R/3 instances

- wrong UTC plus wrong timezone resulting in correct local time

  (utc in all hosts over the world has to be the same time)

GET RUN TIME time measurement accuracy ok !

--------------------------------------------------------------------------------------------------------------------------------------

Time zone for DB and R/3 are different still ...

[former_member182657]

Hi Ohya,

You can also refer SAP Note   1149740 - ST03N - Error when checking UTC timer

and i also suggest as Jake suggested you to use date command to verify current date & time on system and use like date +%Y%m%d -s "20081128"  or  date +%T -s "10:13:13"

Thanks,

Gaurav

[Former Member]

Hi Gaurav,

Thank you for reply.

I refered SAP Note:1149740 .

But my SAP system has SAP_BASIS 740 SP04 . And that SAP Note is Excluded.

And HANA DB server's time zone is consistent with R/3's timezone and AP server's timezone .

Are there any ways that check HANA DB itself's time zone like as Tr-CD:STZAC?

Thanks in advance .

Kazuki.

[Sriram2009]

Hi Ohya

1. Is this any time zone difference are there in ERP & HANA system at OS level?

2. What is the kernel version ?

3. Could you share the OS details in ERP?

Regards

Ram

[Former Member]

Hi Ram,

Thank you for reply.

1. Both the timezones for ERP and HANA system at OS level are Japan (UCT + 9H) .

2. Kernel version is 740 rev.27.

3. Windows Server 2008 R2 version 6.1

Thanks in advance .

Kazuki.

[Sriram2009]

Hi

Could you check the Windows 2008 R2 OS level time Zone?(Not on SAP system) because when you are install the Windows 2008 by default the time Zone will be -9, once again make sure that its there right one?

Regards