UTC Converter Issues

  • Updated

There are two major issues with the UTC converter.

  1. In older versions of 9.2 the UTC Converter will timeout and it gives the error "UTC Conversion Failed." 
  2. In all 9.2 versions the UTC Converter will incorrectly update the web calendar event table. This table did not require updates because it stored UTC time in prior versions.

Here are the steps to resolve both of those issues.

Resolution

Option #1

Upgrade to 9.2SP2 and run that UTC converter. 

Option #2 (for 9.2SP1 and earlier)

If you are running UTC conversion for the first time. This will correctly run UTC conversion without incorrectly updating the web calendar events table. 

  1. Back up the database before proceeding.
  2. Locate the following path on the Ektron Server “C:\Program Files (x86)\Ektron\CMS400v92\Utilities\UTCConversion\UTCConverter” (on win x86 - C:\Program Files\Ektron\CMS400v92\Utilities\UTCConversion\UTCConverter)
  3. DELETE the UTCConverter.exe file on this folder. Make sure it is deleted before continuing to step 4.
  4. Download UTCConverter.zip to the CMS server.
  5. Unzip UTCConverter.zip file to that path (override all existing files if conflicts are found). Ensure the UTCConverter.exe is marked run as administrator by going to Properties > Compatibility tab and check off “Run this program as administrator”.
  6. Rerun the base installer and go through the normal upgrade which should start the UTC Conversion automatically. If it does not open automatically, open it manually at “C:\Program Files (x86)\Ektron\CMS400v92\Utilities\UTCConversion\UTCConverter\UTCConverter.exe”. The app closes automatically when it completes.
  • If you have previously run UTC conversion and have web calendars with incorrect dates(usually off by several hours). This will fix the issue of incorrect web calendar event dates but will not change other tables. 
  1. Back up the database before proceeding.
  2. Locate the following path on the Ektron Server “C:\Program Files (x86)\Ektron\CMS400v92\Utilities\UTCConversion\UTCConverter” (on win x86 - C:\Program Files\Ektron\CMS400v92\Utilities\UTCConversion\UTCConverter)
  3. Download UTCReverter.zip to the CMS server.
  4. Unzip UTCReverter.zip file to that path (override all existing files if conflicts are found). Ensure the UTCReverter.exe is marked run as administrator by going to Properties > Compatibility tab and check off “Run this program as administrator”.
  5. Manually run “C:\Program Files (x86)\Ektron\CMS400v92\Utilities\UTCConversion\UTCConverter\UTCReverter.exe”. The app closes automatically when it completes.