Hi all, Just wanted to share this with everyone.
I created a ticket with BMC(ISS03869351)for a related issue where in date/time passed in GMT timezone was stored in DB as GMT+1(this was through web-services). Midtier -7.5 ARSever-7.1 BMC told us to do this. "As for your issue you may want to try setting the timezone on your servers using yast timezone. If you can use 'yast timezone' to set the system to a timezone other than EST which should cause some KERNEL reconfiguration and then set it back to EST after that it may resolve the issue. ARS 7.1 used ftime() to set the timezones and this was changed in later version of ARS so you would be running into one of the version change conflicts. " Now, since we are on Redhat, 'yast' didnt work for us...but following steps when executed in sequence resolved the issue. system-config-date - Turn Off "System Clock Set to UTC" hwclock --systohc hwclock --hctosys Hope this helps! Regards, Chintan. ________________________________ From: "Grooms, Frederick W" <frederick.w.gro...@xo.com> To: arslist@ARSLIST.ORG Sent: Thursday, November 17, 2011 6:03 AM Subject: Re: Remedy Web-service Timezone question for date/timestamp fields Chintan, The TimeZone should be located on the Locale tab of the "AR System User Preference" form. If you don't have a record for the login you are using you can create one. Also ... What OS is your Mid-Tier running on? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chintan Shah Sent: Thursday, November 17, 2011 2:56 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Web-service Timezone question for date/timestamp fields ** I already did that. It is set to Pacific Standard Time GMT-8 and hence I was expecting -8 in SOAP too but its not working that way. Btw, I do not see and way to set PDT in user preference form...so its very strange as to where -7 is coming from. Thanks Chintan. -----Original Message----- From: Andrew C Goodall <ago...@jcpenney.com> To: arslist@ARSLIST.ORG Sent: Wednesday, November 16, 2011 12:30 PM Subject: Re: Remedy Web-service Timezone question for date/timestamp fields ** Sean has a good point – also check the user account you are using to authenticate, and check its “AR system User preference” record for timezone setting since this is a client based procedure. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com | 972.431.1518 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Garrison, Sean (Norcross) Sent: Wednesday, November 16, 2011 2:08 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Web-service Timezone question for date/timestamp fields Check the user that you are authenticating with for the web service call (you must pass in a user name and password). My guess is the user’s settings are -7. It should be in the user’s application preferences. Sean -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chintan Shah Sent: Wednesday, November 16, 2011 3:04 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Web-service Timezone question for date/timestamp fields ** Hi Andrew, I am sorry, I should have been more clear. I am consuming a web-service outside of web-service filter action(using a custom java web-service client). Does that make a difference or is it still always server timezone? My issue is both my midtier and ARServer are set to Pacific timezone, which means I should expect -8 and not -7 in SOAP envelope from Nov 6 onwards. My default user for midtier is set to "America/Los_Angeles" timezone. My dilemma is why is it sending me -7 instead of -8. Thanks Chintan. -----Original Message----- From: Andrew C Goodall <ago...@jcpenney.com> To: arslist@ARSLIST.ORG Sent: Wednesday, November 16, 2011 10:50 AM Subject: Re: Remedy Web-service Timezone question for date/timestamp fields ** Comes from the timezone of the ARS server I believe that executes the web service filter action. e.g. try changing your server timezone and see if it changes. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chintan Shah Sent: Wednesday, November 16, 2011 12:09 PM To: arslist@ARSLIST.ORG Subject: Remedy Web-service Timezone question for date/timestamp fields Hello all, I am getting an element back from Web-service which looks like this <ns0:Create_Date>2011-11-09T05:00:00-07:00</ns0:Create_Date> Now, question I have is who sets "-07:00"? Is it hard-coded in midtier code or does mid-tier gets the timezone from preference form for default midtier user? Thanks Chintan. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
