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

book

Article ID: 130215

calendar_today

Updated On:

Products

Clarity PPM SaaS 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
 

Attachments

1558537154175check-db-version.xml get_app