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)
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
Clarity 15.9.3
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.
Reference for post-install documentation, here:
(On-Premise only) Post-Upgrade: Final Steps to Complete Your Upgrade