Unable to upgrade Clarity when on SQL Server 2014 SP3+, checkinstall fails on check-db-version.xml

Article Id: 130215

Status: Published

Updated On: 15-04-2019 07:52

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise

Issue/Introduction:

I am on SQL Server 2014 SP3, and trying to upgrade to 15.5.1 or 15.6 ( which is supported as per the Release Notes)

Expected Results: To be able to upgrade successfully
Actual Results: Upgrade fails on Checkinstall stage with error similar to:

The database version could not be validated as a member of the supported versions. Current database info: Microsoft SQL Server 2014 (SP3-CU1) (KB4470220) - 12.0.6205.1 (X64) Nov 30 2018 02:59:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor) . Check the checkinstall.log for connection errors. Refer to the Product Architecture Stack (PAS) for supported database versions.

Cause:

Caused by DE48408, fixed in 15.6.1

Environment:

Release: CODFSS99000-15.5-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution:

Workaround: Use the attached check-db-version.xml file where the script is corrected to accept MSSQL 2014 SP3.
1. Go to your install folder where the install.jar is extracted
2. Go to /checkinstall/scripts
3. Replace the script check-db-version.xml with the one attached
4. Now run the upgrade again