When checking out getting an error message

Document ID : KB000005466
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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

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.