When checking out getting an error message

Products

• CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

After upgrading Harvest from a previous version, we found that there were a few specific files that would not check out.  Error message is:

E03020180: No version data found for version of item <path and file name>;<version>.

Cause

We ran SQL and found that the record associated with this versionobjid was missing from the HARVERSIONDATA table.  This was on a database that had been in existence for several years and had been upgraded multiple times.  When or how this happened is not known.  This is a SQL query you can run on your database to determine how many versions exist in the database with this problem:

SELECT HARENVIRONMENT.ENVIRONMENTNAME,
HARPACKAGE.PACKAGENAME,
HARPATHFULLNAME.PATHFULLNAME,
HARITEMNAME.ITEMNAME,
HARVERSIONS.MAPPEDVERSION,
HARVERSIONS.VERSIONSTATUS,
HARVERSIONS.VERSIONOBJID
FROM HARENVIRONMENT
INNER JOIN HARPACKAGE
ON HARENVIRONMENT.ENVOBJID = HARPACKAGE.ENVOBJID
INNER JOIN HARVERSIONS
ON HARPACKAGE.PACKAGEOBJID = HARVERSIONS.PACKAGEOBJID
INNER JOIN HARPATHFULLNAME
ON HARVERSIONS.PATHVERSIONID = HARPATHFULLNAME.VERSIONOBJID
INNER JOIN HARITEMNAME
ON HARITEMNAME.NAMEOBJID = HARVERSIONS.ITEMNAMEID
WHERE HARVERSIONS.VERSIONDATAOBJID NOT IN (SELECT VERSIONDATAOBJID FROM HARVERSIONDATA)
ORDER BY 1, 2, 3, 4, 7

Environment

Release: SCMNCR99000-12.5-Harvest-Software Change Manager-Named User-Competitive Replacem
Component:

Resolution

The following steps resolved the problem:

1. Create a new package
2. Check out for Browse the "latest-1" version of the file
3. Right click on the latest version of the file and perform "Remove Item"
4. Check in the file checked out in step 2 as a new version

Now the latest version has a harversiondata record and can be checked out

Additional Information

As always, please contact CA Technologies support for CA Harvest Software Change Manager if you have further questions.