Unsolved

Restore Time is before Off Time in Dispatcher for all outages

Comments: 1 - Last Comment by dcbennet on Nov 16, 2016   Comment Filter:
Posted on Nov 14, 2016
 
 

When our serviceman are completing an outage on MobileTC in the field, the information shows up correctly in the Database.  When the restore time and off time get to IDispatcher however, the restore time happens before the off time by an hour. Has anyone seen this before?

We are thinking Daylight savings maybe?

Is there a spot in CADDBM to check this or a command to run to make sure everything is synced up?

Thanks,

Joel Getz

 

Point your RSS reader here for a feed of the latest messages in this topic
RE: Restore Time is before Off Time in Dispatcher for all outages
Posted on Nov 16, 2016 in response to: Joel Getz
 
   
 

The time_zone_info table holds that kind of info:  time_zone, universal time, daylight savings, etc.  It used to be a database table, but I think now it is a View that gets populated from a bunch of other database objects/procedures/functions/stuff.  So it takes a bit to drill down and actually modify something, but it's doable [with something like Toad or SQLDeveloper or similar].  Check your settings in there, and see if that sheds any light ...


Add a Comment

Please sign in on the right menu to comment.  If you do not have an account, please Join now.