Harvest File Version Missing After Upgrade

Products

• CA Harvest Software Change Manager

Issue/Introduction

After Migrating from 13.0.4 to a 14.0.0 Server, it was noticed that Version 6 of a particular file in my project was missing.

 

Environment

Release : 13.0.3 and newer

Resolution

Here is a SQL query (a version for Oracle and for SQL Server) that can let us know what happened to version 6 of the file.  You will need to provide the file name, view path, and project name in the where clause as indicated.

For Oracle:

SELECT
    harenvironment.environmentname,
    pkgstate.statename AS "PKGSTATENAME",
    harpackage.packagename,
    harpathfullname.pathfullname,
    haritemname.itemname,
    harversions.mappedversion,
    harversions.itemtype,
    harversions.versionstatus,
    viewstate.statename AS "VIEWSTATENAME",
    harversions.itemobjid,
    harversions.versionobjid,
    harversions.parentversionid,
    harversions.mergedversionid,
    harversions.inbranch,
    harversions.ancestorversionid,
    harversions.pathversionid,
    harversions.refactor,
    harversions.refactor_by,
    TO_CHAR(harversions.creationtime, 'DD-MON-YYYY HH24:MI:SS') AS CREATIONTIME,
    TO_CHAR(harversions.modifiedtime, 'DD-MON-YYYY HH24:MI:SS') AS MODIFIEDTIME
FROM
    harversions
    INNER JOIN haritemname ON haritemname.nameobjid = harversions.itemnameid
    INNER JOIN harpathfullname ON harversions.pathversionid = harpathfullname.versionobjid
    INNER JOIN harpackage ON harpackage.packageobjid = harversions.packageobjid
    LEFT JOIN harversioninview ON harversions.versionobjid = harversioninview.versionobjid
    INNER JOIN harenvironment ON harpackage.envobjid = harenvironment.envobjid
    LEFT JOIN harstate viewstate ON harversioninview.viewobjid = viewstate.viewobjid
    INNER JOIN harstate pkgstate ON harpackage.stateobjid = pkgstate.stateobjid
WHERE
    harversions.itemobjid IN (
        SELECT UNIQUE
            v1.itemobjid
        FROM
            harversions v1
            INNER JOIN haritemname     n1 ON n1.nameobjid = v1.itemnameid
            INNER JOIN harpathfullname p1 ON v1.pathversionid = p1.versionobjid
        WHERE
            upper(n1.itemname) = upper('README.TXT')                 /* <--- file name */
            AND upper(p1.pathfullname) = upper('\SampleRepository\DOCS') /* <--- view path name */
    )
    AND harenvironment.environmentname = 'SampleProject'   /* <--- project name */
ORDER BY
    harversions.mappedversion

For SQL Server:

SELECT
    harenvironment.environmentname,
    pkgstate.statename AS "PKGSTATENAME",
    harpackage.packagename,
    harpathfullname.pathfullname,
    haritemname.itemname,
    harversions.mappedversion,
    harversions.itemtype,
    harversions.versionstatus,
    viewstate.statename AS "VIEWSTATENAME",
    harversions.itemobjid,
    harversions.versionobjid,
    harversions.parentversionid,
    harversions.mergedversionid,
    harversions.inbranch,
    harversions.ancestorversionid,
    harversions.pathversionid,
    harversions.refactor,
    harversions.refactor_by,
    harversions.creationtime,
    harversions.modifiedtime
FROM
    harversions
    INNER JOIN haritemname ON haritemname.nameobjid = harversions.itemnameid
    INNER JOIN harpathfullname ON harversions.pathversionid = harpathfullname.versionobjid
    INNER JOIN harpackage ON harpackage.packageobjid = harversions.packageobjid
    LEFT JOIN harversioninview ON harversions.versionobjid = harversioninview.versionobjid
    INNER JOIN harenvironment ON harpackage.envobjid = harenvironment.envobjid
    LEFT JOIN harstate viewstate ON harversioninview.viewobjid = viewstate.viewobjid
    INNER JOIN harstate pkgstate ON harpackage.stateobjid = pkgstate.stateobjid
WHERE
    harversions.itemobjid IN (
        SELECT DISTINCT
            v1.itemobjid
        FROM
            harversions v1
            INNER JOIN haritemname     n1 ON n1.nameobjid = v1.itemnameid
            INNER JOIN harpathfullname p1 ON v1.pathversionid = p1.versionobjid
        WHERE
            upper(n1.itemname) = upper('README.TXT')                 /* <--- file name */
            AND upper(p1.pathfullname) = upper('\SampleRepository\DOCS') /* <--- view path name */
    )
    AND harenvironment.environmentname = 'SampleProject'   /* <--- project name */
ORDER BY
    harversions.mappedversion