On a harvest project, we have several files (especially pdf), and while checking out it takes at least 10-15 minutes to find a file for checkout. This behavior started happening after the upgrade. It is happening for a bunch of users who access the files from that project only.
Release : CA Harvest SCM v14.0 and up
We increased the logging level to 5 and reproduced the problem.
In the HServer log files, the 2 longest-running SQL statements were both the same statement:
INSERT INTO VCTEMP2
SELECT DISTINCT I.ITEMOBJID, MAX(I.VERSIONOBJID) AS VERSIONOBJID
FROM VCTEMP1 I, harItems I1
WHERE I.ITEMOBJID = I1.ITEMOBJID
AND I.ITEMOBJID IN (SELECT USRGRPOBJID
FROM HARUSRGRPTEMP)GROUP BY I.ITEMOBJID
In both of these cases, the number of rows updated was 10488.
This appears to happen only with one project where the number of items being checked out is over 10,000. All other examples of this query in the log files run within a second or two and return only 30 or fewer rows.
An efix was provided, and the user added "-vcoptflag11" to the HServer.arg file. If you see a similar problem, please contact support.