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 a number of files (especially pdf) and while checking out it is taking atleast 10-15 minutes to find a file for checkout, and this behavior started happening after the upgrade. It is happening for bunch of users who access the files from that project only.

Environment

Release : 14.0

Cause

We increased logging level to 5 and reproduced the problem.

The top 2 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 be happening 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 user added "-vcoptflag11" to the HServer.arg file