The pre-check installation returns the error: Unable to retrieve DB Timezone, refer to checkinstall.log for details when upgrading.

Article Id: 4847
Status: Published
Updated On: 14-02-2018 08:19
Legacy Id: TEC1818633
Products:
CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM
Issue/Introduction:

The pre-check installation returns the error: Unable to retrieve DB Timezone, refer to checkinstall.log for details when upgrading to v14.2 to 15.1

This will happen with customers that are in the GMT timezone. It does not happen when the timezone is changed to any other time zone apart from GMT

 

Steps to Reproduce:

  1. On the CA PPM server set the timezone to (UTC) Dublin, Edinburgh, Lisbon, London 
  2. On the MS SQL Database server set the timezone to (UTC) Dublin, Edinburgh, Lisbon, London
  3. Set the clock to a GMT date for both CA PPM & Database server
  4. Extract the install.jar from the CA PPM 15.1 installation media 
  5. Run the Install.bat/.sh

Cause:

This is identified as but CLRT-81590 and its in review with our engineering team

Environment:

CA PPM 14.2, 14.3,14.4,15.1

Resolution:

To adjust the DB & CA PPM server timezones to non-GMT timezones then continue the upgrade. Changed back to the GMT Timezone after the upgrade has been  successful.

Or 

  1. Navigate to the <Install Media>\checkinstall\ folder
  2. Modify .\checkinstall\checkinstall-config.xml to comment out this line as shown below:
    <!-- <checkscript filename="check-timezones.xml" operations="UPGRADE" environments="OP" phases="BEFORE" bypass="false"/> -->
  3. Run the install.bat/.sh to proceed with the upgrade.