Patch 15.9.1.1 patch intall fails

Products

• Clarity PPM On Premise

Issue/Introduction

Trying to patch 15.9 with patch 1 and experiencing issues. Tried jdk 11.0.10 and jdk 11.0.9 and database connectivity is good and tried with fresh installer.

Install log

5/20/21 12:46 PM (ExecTask) Current database version is database_20210123_1319
5/20/21 12:46 PM (ExecTask) Note: Foreign Keys have been disabled
5/20/21 12:46 PM (ExecTask) java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]The index 'Z_NDX_INV_INVESTMENTS_01' is dependent on column 'NAME'.

Environment

Clarity 15.9.1 

 

Cause

The index was a custom one and blocking the SQL scripts fired from the patch installer.

Resolution

Custom index dropped and re-ran the patch install.