Possible Dependency error when upgrading CSK

Products

• Clarity PPM On Premise

Issue/Introduction

After upgrading to Clarity 15.9.3 and while attempting to upgrade the CSK (admin content csk), the install fails while capturing the following in admin.log

 Possible Dependency Error - other: POSTUPGRADE_UPDATE_ODMD_RPTING.xml

..(admin) [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid column name 'odmd_rpting'.
..(admin) SQL Text:
..(admin) BEGIN
..(admin) update odf_ca_task
.. (admin) set odmd_rpting = (select CAST(DEFAULT_VALUE as int) 
.. (admin) from ODF_CUSTOM_ATTRIBUTES where object_name='task' 
.. (admin) and INTERNAL_NAME ='odmd_rpting')
.. (admin) where odmd_rpting is null;
.. (admin) update odf_ca_risk
.. (admin) set odmd_rpting = (select CAST(DEFAULT_VALUE as int) 
.. (admin) from ODF_CUSTOM_ATTRIBUTES where object_name='risk' 
.. (admin) and INTERNAL_NAME ='odmd_rpting')
.. (admin) where odmd_rpting is null;
.. (admin) update odf_ca_issue
.. (admin) set odmd_rpting = (select CAST(DEFAULT_VALUE as int) 
.. (admin) from ODF_CUSTOM_ATTRIBUTES where object_name='issue' 
.. (admin) and INTERNAL_NAME ='odmd_rpting')
.. (admin) where odmd_rpting is null;
.. (admin) update odf_ca_change
.. (admin) set odmd_rpting = (select CAST(DEFAULT_VALUE as int) 
.. (admin) from ODF_CUSTOM_ATTRIBUTES where object_name='change' 
.. (admin) and INTERNAL_NAME ='odmd_rpting')
.. (admin) where odmd_rpting is null;
.. (admin) END;

Error executing command: content-deploy csk -Dreports.apply=false -Dforce=false
com.niku.nsa.service.ExecutableException: Content Pack Installation - Database Deploy failed DBDriver failed with dependency errors (1)
 at com.niku.nsa.service.AdminManager.runExecutable(AdminManager.java:2629)
 at com.niku.nsa.service.AdminManager.doProcessDatabaseDriver(AdminManager.java:3861)
 at com.niku.nsa.service.AdminManager.processDatabaseDriver(AdminManager.java:2561)
 at com.niku.nsa.service.AdminManager.installContent(AdminManager.java:2276)
 at com.niku.nsa.service.AdminManager.doContentDeploy(AdminManager.java:1538)
 at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:397)

Cause

It is recommended that CSK and required add-ins are installed at the post-installation stages of Clarity. The CSK installer on version 15.9.3 does not fix the missing/broken dependencies from the source clarity install and should be ideally cleared in the pre-upgrade stages for 15.9.3.

Dependency issues that was not addressed in the previous clarity releases leading up to 15.9.3. The attribute "include in status reporting"  (attribute id = odmd_rpting) was introduced in 15.6.1. So the dependency should have been installed during the earlier upgrade stages. 

Clarity PPM 15.6.1 Changes: New PMO Status Reporting Attribute

Environment

Clarity 15.9.3

Resolution

Reverting back to 15.8.0 and installing the pending CSK add-in installation, followed by an upgrade to 15.9.3 along with another attempt to install current CSK. 

 

 

Additional Information

Reference for post-install documentation, here:

(On-Premise only) Post-Upgrade: Final Steps to Complete Your Upgrade