| Author |
Message
|
| pingwf |
 Posted: Tue Dec 10, 2002 1:40 am Post subject: MQ Workflow time stamp problem |
 |
|
Novice
Joined: 09 Dec 2002
Posts: 23
|
Hi All,
We are running MQ Workflow 3.3.2 SERVER on AIX 4.3.3 and MQ Workflow Runtime Client on Windows 2000; the issue is related to time stamp. All the objects (like workitem, process instance, process template) creation time, updation time and other time what ever shown from client is One hour less than the current IST time.
We have checked the system time Client PC and time zone its properly set to IST. Also the AIX server Time Zone and time is properly set to IST. Still the client of MQWorkflow shows 1hour late times.
The TZ variable value in AIX is IST-5:30,,
Thanks in advance .....
Deepak |
|
| Back to top |
|
 |
| vennela |
| Posted: Tue Dec 10, 2002 5:14 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
What is the TZ variable on your Windows machine. Check if it's other than what it should be for IST.
Use the command prompt and issue SET to see the TZ env variable. I guess there is something wrong with the client side settings. The server settings should be fine.
It's all beacuse of the Day light savings I guess. |
|
| Back to top |
|
|
| ichandra |
| Posted: Tue Dec 10, 2002 5:51 am Post subject: Time Stamp in Workflow |
|
|
Newbie
Joined: 07 Apr 2002
Posts: 1
|
For the past few days we are facing problem in MQ Workflow Time stamp. It is showing 1 hour behind our normal IST Time. Does anybody have come across such problem. Do we need to change any settings. I have been come across this problem after the change in Day Light settings.
Your replies are highly appreciated...
Thanks in Advance |
|
| Back to top |
|
|
| vennela |
| Posted: Tue Dec 10, 2002 6:26 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
This is what I found on a search for AIX+Time+Zone:
On AIX the default is to enable the DayLight savings. Since we(IST) don't have any day light savings we need to trun off this feature at the OS level I guess.
Turning DST on
use smit chtz
Answer "1 yes" to "Use Daylight Savings Time?"
smit chtz
Answer "2 no" to "Use Daylight Savings Time?"
Hope this helps.
I also figured that the client side settings has got nothing to do with the timestamp (and it makes a real lot sense too)
---
Venny |
|
| Back to top |
|
|
| pingwf |
| Posted: Tue Dec 10, 2002 8:31 pm Post subject: |
|
|
Novice
Joined: 09 Dec 2002
Posts: 23
|
The Day light feature is turned off in our AIX.
Following is the screen of AIX TZ settings pls have a look
Change Time Zone
Type or select values in entry fields.
Press Enter AFTER making all desired changes.
[Entry Fields]
* Standard Time ID(only alpahabets) [IST]
* Standard Time Offset from CUT([+|-]HH:MM:SS) [-5:30]
Day Light Savings Time ID(only alpahabets) []
Day Light Savings Time Offset from CUT([+|-]HH:MM: []
SS)
Start Daylight Savings Day([Mmm.ww.dd|Jn]) []
Start Daylight Savings Time(HH:MM:SS) []
Stop Daylight Savings Day([Mmm.ww.dd|Jn]) []
Stop Daylight Savings Time(HH:MM:SS) []
-----
I think our problem is not related to daylight savings (as we are not enabling it) . Can somebody pls confirm whether -5.30 offset from CUT setting in above is right for India. ( Pakistan has a +5.00 setting by default from AIX).
rgds
Deepak |
|
| Back to top |
|
|
| pingwf |
| Posted: Wed Dec 11, 2002 6:52 am Post subject: |
|
|
Novice
Joined: 09 Dec 2002
Posts: 23
|
I found additional information regarding time stamp.
1. I changed the status of some workitems and checked LAST_MODIFIED time stamp in work_item table of FMCDB database of workflow server (on AIX ) which shows the correct time in GMT format. So its confirmed that workflow server is keeping the correct time stamp.
2.The Time Zone setup in my RTC on windows2000 is set to GMT+5:30. Logically the RTC should interprete the GMT format time which it gets from Workflow server and show the time depending on the TimeZone of the client PC. But I am not getting why its showing 1hour difference.
3.When I changed the Time Zone of Client PC from GMT+5:30 to GMT then the RTC showed the exact time stamp which is present in work_item table of Runtime Database.
I think some timezone setup issue at client PC ...
Please through some ideas into this issue.. |
|
| Back to top |
|
|
|
|
