ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Upgrade on SQL Server 2014 SP3+, error on check-db-version.xml

book

Article ID: 130215

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

You are on SQL Server 2014 SP3, and trying to upgrade Clarity 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.

Environment

Release:15.5.1,15.6.0

Resolution

This is DE48408, fixed in 15.6.1

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