Harvest v14.0 - Few users experiencing slowness in checkout from a particular project

Products

• CA Harvest Software Change Manager

Issue/Introduction

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.

Environment

Release : CA Harvest SCM v14.0 and up

Cause

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.

Resolution

An efix was provided, and the user added "-vcoptflag11" to the HServer.arg file.  If you see a similar problem, please contact support.