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.
- Change the UTC.
| Server time | Do this | Example |
|---|
| GMT | Switch 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. |
| +GMT | Wait 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. |
- 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.