Time on Computer Differs From Server

You log into Theatre Manager and you get the following message:

Your computer date/time (MMDDYYYY 00:00:00) differs from the date on the database server (MMDDYYYY 00:00:00) by more than 30 seconds.

This error is one generated by Theatre Manager. Theatre Manager checks the time between the application and the Postgres Database Server as time is important in journalizing accounting.

If only one workstation is affected, it is ok to proceed with work but you should address the time discrepancy as soon as possible. Check the workstation clock

If all workstations are getting the error, stop work, and resolve the issue as it may have a bigger impact on when transactions are posted. Check the time or timezone on the database server.

Why does the time deviate?

It is a well established fact that computers don't keep time very well. They do a darn good job, but the time is generally based on the oscillation of crystals which are based on the frequency in the line voltage. If line voltage frequency varies from the normal +/- 60 cycles per second, it means clocks don't run true and they will never match the accuracy of an atomic clock.

Computer time can change on a particular machine for a number of reasons:

  • sometimes it is the battery, or
  • in older machines, it is not calculating the daylight savings time changes properly.
  • Or your computer is in a different timezone than the database and needs an explicit offset

microsoft even states in this article that they expect the clock on the CPU to vary a minute a day up to an hour. yes, the article states that your computer clock may lose an hour a day.

Time differs by a few minutes

If the time is off by a few minutes, it is more likely to be the workstations. In that case:
  1. Update the workstation clock and timezone to match the Server.
  2. In Theatre Manager you can check time zone setting in Setup >> Company Prefs >> Reports/Misc tab
  3. Set up time synchronization on your computer and server.

Time differs by an hourly increment.

If the time on your computer differs from the server by what appears to be a relatively even multiple of an hour (eg +/-1, 2, 3 or so hours)
  1. Verify that the server time and timezone is correct
  2. Verify that the timezone setting in the postgresql.conf file is correct.
  3. Verify that the workstation clock time and timezone match the Server. If they do not, you have two options:
    • If the workstation should be in the same timezone, fix the timezone in the clock preferences
    • If the office is in a different timezone than the server, you can set the workstation timezone in the Theatre Manager Preferences file for that workstation
  4. If it still persists, check that the postgresql.conf has the correct 'Log_timezone' setting and "timezone" setting for the local area and match the timezone on the server. There are instructions for editing on an OSX or Windows Server
  5. Typical values are:
    • US/Eastern, US/Central, US/Mountain, US/Pacific, US/Alaska, US/Hawaii, US/Michigan, US/East-Indiana, US/Indiana-Starke
    • Canada/Newfoundland, Canada/Atlantic, Canada/Eastern, Canada/Eastern, Canada/Saskatchewan, Canada/East-Saskatchewan, Canada/Central, Canada/Mountain, Canada/Yukon or Canada/Pacific
    • The valid timezone list can be found in Setup >> Company Prefs >> Reports/Misc tab

Using Computer Time Synchronization

To set up time synchronization, please check your computer's built in help to help you determine how to do this as it varies from operating system to operating system. Generally: