Checking the dependency setting on promote and demote processes

Products

• CA Harvest Software Change Manager
• CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

Is there a recursive setting in Harvest that would allow us to set dependency checking for all promote and demote processes across all projects?

Environment

Harvest Software Change Manager all versions
Valid for both Oracle and SQL Server environments

Resolution

Harvest does not have any feature that will accomplish this.  However, what I can offer is some SQL that will look at all the promote processes in your Harvest database and let you know which ones have the box checked, and which ones don't:

(The following queries have been tested with both Oracle and SQL Server)

SELECT HE.ENVIRONMENTNAME,
  HS.STATENAME,
  HSP.PROCESSNAME,
  HSP.PROCESSTYPE,
  HPP.CHECKDEPENDENCIES
FROM HARPROMOTEPROC HPP
  INNER JOIN HARSTATEPROCESS HSP ON HSP.PROCESSOBJID = HPP.PROCESSOBJID
    AND HSP.STATEOBJID = HPP.STATEOBJID
  INNER JOIN HARSTATE HS ON HS.STATEOBJID = HSP.STATEOBJID
  INNER JOIN HARENVIRONMENT HE ON HE.ENVOBJID = HS.ENVOBJID

And for the demote processes:

SELECT HE.ENVIRONMENTNAME,
  HS.STATENAME,
  HSP.PROCESSNAME,
  HSP.PROCESSTYPE,
  HDP.CHECKDEPENDENCIES
FROM HARDEMOTEPROC HDP
  INNER JOIN HARSTATEPROCESS HSP ON HSP.PROCESSOBJID = HDP.PROCESSOBJID
    AND HSP.STATEOBJID = HDP.STATEOBJID
  INNER JOIN HARSTATE HS ON HS.STATEOBJID = HSP.STATEOBJID
  INNER JOIN HARENVIRONMENT HE ON HE.ENVOBJID = HS.ENVOBJID

This will at least help you to more easily locate which ones need to be updated.

Additional Information

More information on the Promote and Demote processes can be found here:

Define Lifecycle Processes - Define a Promote Process
Define Lifecycle Processes - Define a Demote Process