Skip to Content
Actions

DUMP ZDATE_LARGE_TIME_DIFF in Hana Database

October 1, 2013 | 160 Views |
Follow

Hi All,

After installing EHP6 for SAP ERP 6.0 on HANA , when we try to login – we might end up with dump error DUMP ZDATE_LARGE_TIME_DIFF in Installation Error category. Because of time difference between the Application server and Hana Database. You can try the below solutions.

1. You can adjust the time zone using YAST – NTP configuration to syn the time zone between the DB and application server.

2. While adding additional systems using HANA config tool – in the properties screen you will be providing the SID, Instance number, FQDN, Password, Installation path, Data and Log volumes which are the mandatory fields have to filled before proceeding further, but same screen at last you can find the time zone filed which is not marked as mandatory but keep in practice that you have maintained the time zone to avoid the dump DUMP ZDATE_LARGE_TIME_DIFF.

3. Loin to hana server using sidadm user and stop the database and application server using Management console. Change the directory to /usr/share/zoneinfo and use tzselect to maintain the location and time zone.

You have make the changes permanent for yourself by appending the line

TZ=’Australia/Sydney’; export TZ

to the file ‘.profile’ in your home directory then log out and log in again.

.profile can be found /usr/sap/SID/home/.profile

Make changes in .sapenv.sh and .sapenv.csh as well.

Please post your suggestions and comments or any corrections.

Regards

kartik

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

    1. Mukund Nikam

      Thanks Kartik for sharing valuable informations, but there is small correction at last point.

      after changing the value with tzselect, you have to adjust the timezhon in .sapenv.sh and .sapenv.csh for the permanant change.

      (0) 
      2. Arun Chanda

        i just edited exactly as described in this article to change the HANA DB time zone  from UTC to EST. I just edited the ‘.profile‘ file and restarted the OS and DB, the change did not take place. After i edit the ‘.sapenv.sh‘ & ‘.sapenv.csh‘ and restarted OS and DB which then reflected with the new changes. Thanks for sharing this article with screen shots. @Mukund Nikam You are absolutely true that we need to edit the files.

        Thanks

        Arun

        (0) 
  2. Joel Mwangi

    Hello TEAM,

    i have been trying to update the info above as my time is bhind with 3 hours.  I have first part successful as in the step above and its successful . however, i cannot locate home /. profile and the sapenv.sh to make those changes permanent. Kindly help.

    (0) 
    1. Arun Chanda

      Hi Joel

      After logging with your <SID>adm account, just execute the following exactly, you should be able to find it.

      hana:DB:<sid>adm / 1004> $HOME

      /usr/sap/<sid>/home: Permission denied.

      hana:DB:<sid>adm / 1005> cd /usr/sap/<sid>/home

      Directory: /usr/sap/<sid>/home

      hana:DB:<sid>adm ~ 1006> ls -a

      .                        .esd_auth        logclean.log         .sdb

      ..                       .fontconfig      log_clean.sh         .skel

      backup               .fonts           mbox                 startsap_DB00.log

      backup.sh          .gconf           .mozilla             startsap_.log

      backup.sh.old    .gconfd          .muttrc              stopsap_DB00.log

      .bash_history    .gnome2          .nautilus            temp

      .bashrc             .gnome2_private  old_logs.txt         .viminfo

      bin                   .gnu-emacs       .profile             .vimrc

      .config             .gstreamer-0.10  .pulse               .xim.template

      .cshrc              .gvfs            .pulse-cookie        .xinitrc.template

      .dbus                .DB             .recently-used.xbel  .xsession-errors

      Desktop           .history         .sapenv.csh          .xsession-errors.old

      .dmrc               .ICEauthority    .sapenv.sh

      Documents      .inputrc         .sapsrc.csh

      .emacs             .local           .sapsrc.sh

      (0) 

Leave a Reply