on 10-30-2009 9:31 AM
Hi,
We are getting ZDATE_LARGE_TIME_DIFF Runtime error.
CI and DB instance are on different host
We have checked the Timezone and Time in CI and DB .There is no difference in TIime or Timezone.
Even though there is no time difference ,we are getting ZDATE_LARGE_TIME_DIFF in our system
Regards,
Kumar
Hi Kumar,
Is this problem solved?
How long have you had this issue? I suspect it may have to do with the different DST rules in the US.
Best Regards,
Matt
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
One more note: The DB time should be based off the OS time, but you should also double check the OS time and OS time zone in case there is a minor inconsistency or OS bug behind this. Also check your <SID>adm user and DB user's env variables: env | grep TZ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try running report RSDBTIME, and also check the time zone in client 000 (STZAC). Also make sure you have the correct daylight savings rules applied per Note 919538 in both clients, and/or import the most current time zone settings per Note 198411, which will update all the rules to the latest. Also try reports TZCUSTHELP and TZONECHECK, TZCUSTDISP in each client and look for any inconsistencies. Hope this helps..
Regards,
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check that they are in the same time zone.
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What is an Os platform i.e unix or windows.
Thanks,
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.