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>.
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
The following steps resolved the problem:
Now the latest version has a harversiondata record and can be checked out
As always, please contact CA Technologies support for CA Harvest Software Change Manager if you have further questions.