Upgrading Plant Applications to Use UTC

You must manually upgrade your system to use UTC on an existing Plant Applications installation.

Before you begin

Make a copy of your production database. You can use the production database copy as a backup or for reporting.

About this task

Note: These options require advanced knowledge of both SQL Server and Plant Applications. You should test the results of either action before implementing them in a production environment.

Procedure

  • Create a gap in your data, based on your server time.
    1. Change the UTC.
      Server timeDo thisExample
      GMTSwitch to UTC. The gap is created automatically when you switch to UTC time. If you are at GMT -5:00 and your last data was recorded at 14:22, when you switch to UTC (GMT) the data is stored at 19:22, creating a gap in your data of five hours.
      +GMTWait until the UTC time is newer than the last time stamp in the database. This prevents data from being overwritten. If you are at GMT +3:00 and your last data was recorded at 11:00:00, you can shut down the server, wait for four hours and switch to UTC. The system stores your data i at 12:00:00, providing a one-hour gap.
    2. Move the server as described in the Knowledgebase article KB5427 at the Support web site: https://digitalsupport.ge.com.
  • To eliminate the runtime data from the copy of your database, move the server as specified in KB5427 and truncate your runtime data. See the support website https://digitalsupport.ge.com for the additional truncation procedure.