My thoughts were from memory and it may have been a result of being on the older servers. What we saw were differences between workflow that was set to fire at specific times vs those that fired on Interval. As I think about it, it was the fall where we saw issues and not the spring. It was because the fall sees the 2:00 AM time twice resulting in double escalations for those set to fire at specific times.
Mark noted that the field was set by an escalation. If that escalation fired at Midnight on Sunday morning and the search was performed on Sunday after the time change then it does make sense that it would show up off an hour. Sunday was really a 23 hour day and the app would make adjustments to date/time fields looking back in time to before the time change. Dave ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of David Durling Sent: Monday, March 12, 2012 1:56 PM To: [email protected] Subject: Re: Where does $DATE$ come from? ** Dave, So you've had to restart arsystem server to get things back in sync? I had an issue this morning where one escalation ("A") scheduled for 8:00 went off at 9:00, yet another escalation ("B") scheduled for 8:05 went off at the correct time. Differences I could think of: escalation A came from workflow originally built on a 6.0 server (and it's set to run on specific weekdays) , and B was built on our current 7.5 server (and it's set to run every day). David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Shellman, David Sent: Monday, March 12, 2012 1:13 PM To: [email protected] Subject: Re: Where does $DATE$ come from? ** Mark, Remember that most of the US changed time yesterday. We have seen some issues with things being off an hour after a time change until we cycle services. That's mostly dealing with escalations. Dave ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 12:37 PM To: [email protected]<mailto:[email protected]> Subject: Re: Where does $DATE$ come from? ** Depending on what is used to set it.. Is it an Active Link? Or a Filter/Escalation? In case of an Active Link, the $DATE$ would taken from the client. In case of server side workflow objects, Filters or Escalations, they are set from the AR System application server (not the database application server). Joe From: Brittain, Mark<mailto:[email protected]> Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: [email protected]<mailto:[email protected]> Subject: Where does $DATE$ come from? ** Hi All, Where does the $DATE$ function get the date/time information, the OS server or the database server. This may seem like a strange question but yesterday I had a case where $TIMESTAMP$ was work correctly and diary field entries were correct but the $DATE$ was on hour behind as 3/10/2012 23:00:00 PM. Strangely today, it working correctly as 3/12/2012 00:00:00 AM ARS 6.3 patch 20 SunOS 5.9 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company [email protected]<mailto:[email protected]> Office: 315-453-2912 x5335 Mobile: 315-317-2897 _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.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"

