Re: Where does $DATE$ come from?
How many of us are waiting for someone to say... $DATE$ come from $PALMTREE$ (Due to recent time zone changes it is now Friday!) I couldn't resist, sorry. Doug -- Doug Blair Sent from my iPhone4, typographic errors likely +1-224-558-5462 On Mar 12, 2012, at 11:28 AM, Brittain, Mark mbritt...@navisite.com wrote: ** 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 mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _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
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 mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
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 Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG 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 mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Where does $DATE$ come from?
And…being yesterday was daylight savings day….are the client/server in the same tz, do they both honor dst same? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 10:37 AM To: arslist@ARSLIST.ORG 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:mbritt...@navisite.com Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG 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 mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 _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
Re: Where does $DATE$ come from?
Yes, this is an escalation that does the set field. Both server and client are in the Eastern Time Zone, so very strange. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, March 12, 2012 1:04 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** And…being yesterday was daylight savings day….are the client/server in the same tz, do they both honor dst same? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 10:37 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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, Markmailto:mbritt...@navisite.com Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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 mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Where does $DATE$ come from?
I was wondering the same thing when I was writing this response too. Maybe BMC engineering would be in a better position to answer that. I had seen a patch in one of the recent versions when the DST was revised. That patch was supposed to make the AR System compliant to the latest revision. So to answer your question, my guess would be yes. It would consider that. Its probably a question for engineering considering most of us may not be at the liberty to simulate it by adjusting the server times on our dev or test boxes.. Joe From: LJ LongWing Sent: Monday, March 12, 2012 1:04 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** And…being yesterday was daylight savings day….are the client/server in the same tz, do they both honor dst same? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 10:37 AM To: arslist@ARSLIST.ORG 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 Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG 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 mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
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:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 12:37 PM To: arslist@ARSLIST.ORG 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, Markmailto:mbritt...@navisite.com Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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 mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 _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
Re: Where does $DATE$ come from?
Hi, If you are on the same timezone as the server, and your clock is accurate, you should see the same thing regardless of where the $DATE$ was called (server or client). If you are on a different timezone, the date-time returned by $DATE$ will vary. If the server sets $DATE$ to 2012-03-31 it will add 00:00:00 as time giving us 2012-03-31 00:00:00 from the servers perspective. Depending on if you are before or behind the serer from a timezone-perspective, you might see: 2012-03-30 22:00:00 2012-03-30 23:00:00 2012-03-31 00:00:00 2012-03-31 01:00:00 2012-03-31 02:00:00 And if it is a field that shows only the date-part and hides the time, you might see the following depending on the client timezone setting: 2012-03-30 2012-03-30 2012-03-31 2012-03-31 2012-03-31 But it will always be the same number of seconds since the birth of Unix (1970-01-01 00:00:00 GMT), which is some comfort as least... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Yes, this is an escalation that does the set field. Both server and client are in the Eastern Time Zone, so very strange. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, March 12, 2012 1:04 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** And…being yesterday was daylight savings day….are the client/server in the same tz, do they both honor dst same? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 10:37 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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, Markmailto:mbritt...@navisite.com Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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 mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ 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
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:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, March 12, 2012 1:13 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 12:37 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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, Markmailto:mbritt...@navisite.com Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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 mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://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
Re: Where does $DATE$ come from?
Had A ran since the time change? I believe all escalation next run times are computed when they run (and are in seconds until next run) so if A had not run since the time change it would have been calculated to run x seconds from the last time (and with the time change that would be 1 hour later than you thought) Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 12:56 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, March 12, 2012 1:13 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 12:37 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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, Markmailto:mbritt...@navisite.com Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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 mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Where does $DATE$ come from?
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:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 1:56 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, March 12, 2012 1:13 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 12:37 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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, Markmailto:mbritt...@navisite.com Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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 mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://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
Re: Where does $DATE$ come from?
Fred, This was the first time A ran since the time change, but it's set to run by 'Time', not 'Interval'. But if what you said applies anyway, I should find out tomorrow when it's supposed to run again. Thanks, David David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, March 12, 2012 2:01 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Had A ran since the time change? I believe all escalation next run times are computed when they run (and are in seconds until next run) so if A had not run since the time change it would have been calculated to run x seconds from the last time (and with the time change that would be 1 hour later than you thought) Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 12:56 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, March 12, 2012 1:13 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 12:37 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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, Markmailto:mbritt...@navisite.com Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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 mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 _attend WWRUG12 www.wwrug.comhttp://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
Re: Where does $DATE$ come from?
Why would the version on which it was created make that much of a difference? Either version, time is saved as EPOCH time – and the meta data contents of the the Escalation within the database as far as the time it was created or modified, should not differ. My thoughts are along the lines of when the escalation last fired – was the DST already set at that time? If not when the two escalations last ran, one of them may have ran before the DST change occurred, and the other after. Its during the last run that the next run time is already calculated.. That would be my guess as to why they ran at seemingly different times.. Joe From: David Durling Sent: Monday, March 12, 2012 1:55 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, March 12, 2012 1:13 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 12:37 PM To: arslist@ARSLIST.ORG 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 Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG 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 mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 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
Re: Where does $DATE$ come from?
Yup that’s exactly how I think it happens too.. Joe From: Grooms, Frederick W Sent: Monday, March 12, 2012 2:00 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Had “A” ran since the time change? I believe all escalation next run times are computed when they run (and are in seconds until next run) so if “A” had not run since the time change it would have been calculated to run x seconds from the last time (and with the time change that would be 1 hour later than you thought) Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 12:56 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, March 12, 2012 1:13 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 12:37 PM To: arslist@ARSLIST.ORG 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 Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG 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 mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Where does $DATE$ come from?
Even by time it is calculated when it runs. (You can tell by watching the Escalation Log and seeing that each escalation states) (enabled) : going to fire in seconds It would only be able to do that if it is calculated at the time of the last run (to know how many seconds until the next run). Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 1:20 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Fred, This was the first time A ran since the time change, but it's set to run by 'Time', not 'Interval'. But if what you said applies anyway, I should find out tomorrow when it's supposed to run again. Thanks, David David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, March 12, 2012 2:01 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Had A ran since the time change? I believe all escalation next run times are computed when they run (and are in seconds until next run) so if A had not run since the time change it would have been calculated to run x seconds from the last time (and with the time change that would be 1 hour later than you thought) Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 12:56 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, March 12, 2012 1:13 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 12:37 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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, Markmailto:mbritt...@navisite.com Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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 mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Where does $DATE$ come from?
I’m pretty sure that even if it is set at a specific time, the escalation server calculates the next time duration when it will fire next. So technically if your escalation “A” last ran before the DST change, it calculated 9:00 AM as being 8:00 AM (which could be reported as a bug if that’s the case, as it could impact certain business processes). It should have calculated the offset in my opinion if that’s what is happening.. Joe From: David Durling Sent: Monday, March 12, 2012 2:19 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Fred, This was the first time “A” ran since the time change, but it’s set to run by ‘Time’, not ‘Interval’. But if what you said applies anyway, I should find out tomorrow when it’s supposed to run again. Thanks, David David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, March 12, 2012 2:01 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Had “A” ran since the time change? I believe all escalation next run times are computed when they run (and are in seconds until next run) so if “A” had not run since the time change it would have been calculated to run x seconds from the last time (and with the time change that would be 1 hour later than you thought) Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 12:56 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, March 12, 2012 1:13 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 12:37 PM To: arslist@ARSLIST.ORG 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 Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG 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 mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Where does $DATE$ come from?
Fred is on the right track with his answers. The way escalations work is to calculate when things should NEXT fire and that is what is keyed off of. The calculation is not considering that DST change may be crossed for the next fire time (a fair question is why not and that is something that could be submitted as a bug, but the escalation does run and for one time, it is 1 hour off so is it a critical issue? but, definitely feel free to submit the bug). You should find all back on track after the first firing. Now, the comment about restarting the server. Why does that fix things? Well, when you restart the server, we have to calculate all the next fire times so the restart after the change in DST will calculate the fire times correctly even for the first firing interval. It isn't that a restart is required, it is just that the restart causes a recalculation of the firing times. NOTE however that any interval fired operation would not have any issue with the one hour off and a restart of the system will reset the interval counter so the current interval will get longer for the interval based escalations - however long it has been since the last run plus the interval for the first interval. I just wanted to explain what effect the restart had on the issue and why it seemed to fix a problem. Again, the answer was already there, I just wanted to confirm it and offer a bit more information about the affect on interval escalations. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, March 12, 2012 11:29 AM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Even by time it is calculated when it runs. (You can tell by watching the Escalation Log and seeing that each escalation states) (enabled) : going to fire in seconds It would only be able to do that if it is calculated at the time of the last run (to know how many seconds until the next run). Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 1:20 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Fred, This was the first time A ran since the time change, but it's set to run by 'Time', not 'Interval'. But if what you said applies anyway, I should find out tomorrow when it's supposed to run again. Thanks, David David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, March 12, 2012 2:01 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Had A ran since the time change? I believe all escalation next run times are computed when they run (and are in seconds until next run) so if A had not run since the time change it would have been calculated to run x seconds from the last time (and with the time change that would be 1 hour later than you thought) Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 12:56 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, March 12, 2012 1:13 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 12:37 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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, Markmailto:mbritt
Re: Where does $DATE$ come from?
Its not a critical issue for most cases where Escalation run times are often arbitrarily selected at the least active times. But if a slight miss does get noticed, it could mean that something that was fairly important, may have not been triggered at that expected time which could possibly be David’s case.. Most of us (including me) never even noticed that until David pointed it out.. We may have possibly gone through the rest of our merry ARS lives not worrying about it.. Joe From: Mueller, Doug Sent: Monday, March 12, 2012 2:35 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Fred is on the right track with his answers. The way escalations work is to calculate when things should NEXT fire and that is what is keyed off of. The calculation is not considering that DST change may be crossed for the next fire time (a fair question is why not and that is something that could be submitted as a bug, but the escalation does run and for one time, it is 1 hour off so is it a critical issue? but, definitely feel free to submit the bug). You should find all back on track after the first firing. Now, the comment about restarting the server. Why does that fix things? Well, when you restart the server, we have to calculate all the next fire times so the restart after the change in DST will calculate the fire times correctly even for the first firing interval. It isn't that a restart is required, it is just that the restart causes a recalculation of the firing times. NOTE however that any interval fired operation would not have any issue with the one hour off and a restart of the system will reset the interval counter so the current interval will get longer for the interval based escalations – however long it has been since the last run plus the interval for the first interval. I just wanted to explain what effect the restart had on the issue and why it seemed to fix a problem. Again, the answer was already there, I just wanted to confirm it and offer a bit more information about the affect on interval escalations. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, March 12, 2012 11:29 AM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Even by time it is calculated when it runs. (You can tell by watching the Escalation Log and seeing that each escalation states) (enabled) : going to fire in seconds It would only be able to do that if it is calculated at the time of the last run (to know how many seconds until the next run). Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 1:20 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Fred, This was the first time “A” ran since the time change, but it’s set to run by ‘Time’, not ‘Interval’. But if what you said applies anyway, I should find out tomorrow when it’s supposed to run again. Thanks, David David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, March 12, 2012 2:01 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Had “A” ran since the time change? I believe all escalation next run times are computed when they run (and are in seconds until next run) so if “A” had not run since the time change it would have been calculated to run x seconds from the last time (and with the time change that would be 1 hour later than you thought) Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 12:56 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, March 12, 2012 1:13 PM To: arslist@ARSLIST.ORG 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
Re: Where does $DATE$ come from?
In my case the escalation was running every hour as expected against a form called Schedule. The qualification on the escalation is set field if Schedule Date = $DATE$. The escalation set field would start a filter push field. This did not work after DST because the Schedule Date was 3/11/2012 00:00:00 and the $DATE$ value used was 3/10/2012 23:00:00 On Sunday the set field/push field worked fine at 1AM and then did not work at 2AM/3AM or after. Then sometime this morning it started working because the $DATE$ value is 3/12/2012 00:00:00. FYI Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 2:52 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Its not a critical issue for most cases where Escalation run times are often arbitrarily selected at the least active times. But if a slight miss does get noticed, it could mean that something that was fairly important, may have not been triggered at that expected time which could possibly be David’s case.. Most of us (including me) never even noticed that until David pointed it out.. We may have possibly gone through the rest of our merry ARS lives not worrying about it.. Joe From: Mueller, Dougmailto:doug_muel...@bmc.com Sent: Monday, March 12, 2012 2:35 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Fred is on the right track with his answers. The way escalations work is to calculate when things should NEXT fire and that is what is keyed off of. The calculation is not considering that DST change may be crossed for the next fire time (a fair question is why not and that is something that could be submitted as a bug, but the escalation does run and for one time, it is 1 hour off so is it a critical issue? but, definitely feel free to submit the bug). You should find all back on track after the first firing. Now, the comment about restarting the server. Why does that fix things? Well, when you restart the server, we have to calculate all the next fire times so the restart after the change in DST will calculate the fire times correctly even for the first firing interval. It isn't that a restart is required, it is just that the restart causes a recalculation of the firing times. NOTE however that any interval fired operation would not have any issue with the one hour off and a restart of the system will reset the interval counter so the current interval will get longer for the interval based escalations – however long it has been since the last run plus the interval for the first interval. I just wanted to explain what effect the restart had on the issue and why it seemed to fix a problem. Again, the answer was already there, I just wanted to confirm it and offer a bit more information about the affect on interval escalations. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, March 12, 2012 11:29 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Even by time it is calculated when it runs. (You can tell by watching the Escalation Log and seeing that each escalation states) (enabled) : going to fire in seconds It would only be able to do that if it is calculated at the time of the last run (to know how many seconds until the next run). Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 1:20 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Fred, This was the first time “A” ran since the time change, but it’s set to run by ‘Time’, not ‘Interval’. But if what you said applies anyway, I should find out tomorrow when it’s supposed to run again. Thanks, David David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Monday, March 12, 2012 2:01 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Had “A” ran since the time change? I believe all escalation next run times are computed when they run (and are in seconds until next run) so if “A” had not run since the time change it would have been calculated to run x seconds from the last time (and with the time change that would be 1 hour later than you thought) Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 12:56 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** Dave, So you’ve had to restart arsystem server to get things back in sync
Re: Slightly OT: Where does $DATE$ come from?
Yeah. I have a script running robocopy.exe to sync my laptop files with an external usb drive and it always ends up recopying everything after the DST change instead of just the files that had changed since the last backup. I'll be putting of my backup now for a few days since I know its going to take at least 5 hours for it to run :( Ken. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 1:49 PM To: arslist@ARSLIST.ORG Subject: Slightly OT: Where does $DATE$ come from? I wonder if this is explainable.. It’s the Date Modified attribute of a file on disk - which when copied to a flash drive, the value is the same, until the day the time changes.. ((See attached image)) Notice that the last file that I copied today has the exact same time while the files that were copied before today *HAD* the exact same time until Saturday night.. Where they all fell an hour behind on the flash drive.. I thought it was interesting.. And I found an interesting and plausible explanation to it.. http://ask-leo.com/why_do_file_timestamps_compare_differently_every_time_change.html Joe -Original Message- From: Misi Mladoniczky Sent: Monday, March 12, 2012 1:23 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? Hi, If you are on the same timezone as the server, and your clock is accurate, you should see the same thing regardless of where the $DATE$ was called (server or client). If you are on a different timezone, the date-time returned by $DATE$ will vary. If the server sets $DATE$ to 2012-03-31 it will add 00:00:00 as time giving us 2012-03-31 00:00:00 from the servers perspective. Depending on if you are before or behind the serer from a timezone-perspective, you might see: 2012-03-30 22:00:00 2012-03-30 23:00:00 2012-03-31 00:00:00 2012-03-31 01:00:00 2012-03-31 02:00:00 And if it is a field that shows only the date-part and hides the time, you might see the following depending on the client timezone setting: 2012-03-30 2012-03-30 2012-03-31 2012-03-31 2012-03-31 But it will always be the same number of seconds since the birth of Unix (1970-01-01 00:00:00 GMT), which is some comfort as least... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Yes, this is an escalation that does the set field. Both server and client are in the Eastern Time Zone, so very strange. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, March 12, 2012 1:04 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** And…being yesterday was daylight savings day….are the client/server in the same tz, do they both honor dst same? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 10:37 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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, Markmailto:mbritt...@navisite.com Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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 mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are *** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity
Re: Slightly OT: Where does $DATE$ come from?
You would think manufacturers would have sorted an issue like this out as it obviously would impact a scripted backup of disk content.. Your workaround (which in your case would be expensive both in terms of time and disc storage space) would be to have a staging type of a local directory to copy your backup to. And then copy that staging directory to the backup drive.. The next time you want to backup your script compares the contents of the staging directory on your local drive, and copies the delta and changes, and then move that to the backup drive.. Like I said more time consuming and more expensive.. Joe -Original Message- From: Cecil, Ken Sent: Monday, March 12, 2012 4:10 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Where does $DATE$ come from? Yeah. I have a script running robocopy.exe to sync my laptop files with an external usb drive and it always ends up recopying everything after the DST change instead of just the files that had changed since the last backup. I'll be putting of my backup now for a few days since I know its going to take at least 5 hours for it to run :( Ken. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 1:49 PM To: arslist@ARSLIST.ORG Subject: Slightly OT: Where does $DATE$ come from? I wonder if this is explainable.. It’s the Date Modified attribute of a file on disk - which when copied to a flash drive, the value is the same, until the day the time changes.. ((See attached image)) Notice that the last file that I copied today has the exact same time while the files that were copied before today *HAD* the exact same time until Saturday night.. Where they all fell an hour behind on the flash drive.. I thought it was interesting.. And I found an interesting and plausible explanation to it.. http://ask-leo.com/why_do_file_timestamps_compare_differently_every_time_change.html Joe -Original Message- From: Misi Mladoniczky Sent: Monday, March 12, 2012 1:23 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? Hi, If you are on the same timezone as the server, and your clock is accurate, you should see the same thing regardless of where the $DATE$ was called (server or client). If you are on a different timezone, the date-time returned by $DATE$ will vary. If the server sets $DATE$ to 2012-03-31 it will add 00:00:00 as time giving us 2012-03-31 00:00:00 from the servers perspective. Depending on if you are before or behind the serer from a timezone-perspective, you might see: 2012-03-30 22:00:00 2012-03-30 23:00:00 2012-03-31 00:00:00 2012-03-31 01:00:00 2012-03-31 02:00:00 And if it is a field that shows only the date-part and hides the time, you might see the following depending on the client timezone setting: 2012-03-30 2012-03-30 2012-03-31 2012-03-31 2012-03-31 But it will always be the same number of seconds since the birth of Unix (1970-01-01 00:00:00 GMT), which is some comfort as least... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Yes, this is an escalation that does the set field. Both server and client are in the Eastern Time Zone, so very strange. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, March 12, 2012 1:04 PM To: arslist@ARSLIST.ORG Subject: Re: Where does $DATE$ come from? ** And…being yesterday was daylight savings day….are the client/server in the same tz, do they both honor dst same? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 10:37 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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, Markmailto:mbritt...@navisite.com Sent: Monday, March 12, 2012 12:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 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
