hmvproj Verification issue for approve history (HARAPPROVEHIST) === Step 43 of 54

Products

• CA Harvest Software Change Manager

Issue/Introduction

Running the hmvproj utility for two Harvest projects, the verification process in the approve history (HARAPPROVEHIST) table reports an issue for STATEOBJID's:

"Unable to resolve STATEOBJID source object id:  11275" and
"Unable to resolve STATEOBJID source object id:  12289"

Checking in the table HARSTATE, the related states for these STATEOBJID's no longer exist. They have been deleted during a project lifecycle review in the Harvest Admin GUI.

Is it possible to perform housekeeping on the history tables for the missing STATEOBJID's to get the verification process to complete successfully?

 

 

Environment

Release : 14.0

Resolution

Yes, you can remove the orphaned records in HARAPPROVEHIST by running this query on SCM database

delete from HARAPPROVEHIST where STATEOBJID NOT IN (select STATEOBJID from HARSTATE)

and then run the hmvproj command again.