The online Purge generates the following error in the purge log file:

Exception handled at CStOnlinePurgeManager::PurgeArchives: Class = StHiveException, Code = 6(0x00000006)
Msg = Could not locate a hive with a hive ID of 0

This can occur when files in the purged_archives table have unknown Hive Ids. The most likely cause is that these entries are orphaned files from earlier incomplete purge runs.

Make sure there is a current backup for the StarTeam database, then run the following query against the starteam database:

SELECT
   ID,REVISIONNUMBER ,TYPE,PROCFLAG,HIVEID,MD5,COMPRESSION,ARCHIVEFORMAT 
FROM
   purged_archives pa
WHERE
   procflag = 'N' and hiveid = 0   

If the query returns references to Hive 0 run the code below:

UPDATE
   purged_archives
SET
   procflag = 'Y'
WHERE
   procflag = 'N' and hiveid = 0;
COMMIT;  

After successfully executing the query, restart the online purge.

Reference id #2669343