E03020180: No version data found for version of item

Products

• CA Harvest Software Change Manager - OpenMake Meister
• CA Harvest Software Change Manager
• 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>.

Environment

Harvest-Software Change Manager all versions

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

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