DUMP ZDATE_LARGE_TIME_DIFF in Hana Database
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.