Error upgrade HDBSetup

Document ID : KB000100640
Last Modified Date : 08/06/2018
Show Technical Document Details
Issue:
When upgrading from Harvest 7.1 to SCM 12.x, we are executing the upgrade repository procedure and are getting error messages:
E03020770: Upgrade error: Table HARVERSIONS Project <--> First pass path versions relationship verification failed . 
E03020770: Upgrade error: ***Please contact CA Technical Support for help resolving this database problem***. .
Environment:
CA Harvest SCM all platforms
Upgrading from Harvest 7.1
Cause:
Part of the database migration program will do an integrity check to make sure ....  In this case, some of the data linking versions in the database to other types of information such as projects, or paths, or packages was found to be incorrect.
.
Resolution:
If you see an error message like this one, you will need to contact the CA Technologies Support Team to help to correct the errors in the database before the upgrade can be successful.
Additional Information:
When doing an upgrade of SCM, it is always advisable to get a copy of your production database and do a "trial upgrade" to ensure fixes are identified for any problems that are found, before your actual production upgrade is scheduled.  This will ensure your production upgrade will go as smoothly as possible.