While attempting to upgrade Harvest 12.1.3 to 12.6, the database upgrade crashed with the following error:
-- BindString 1: HARPEERCOMMENT_VOBJID_IND
CREATE INDEX HARPEERCOMMENT_VOBJID_IND ON HARPEERREVIEWCOMMENT ( VERSIONOBJID ) TABLESPACE HARVESTINDEX
[Oracle][ODBC][Ora]ORA-01408: such column list already indexed
2015/10/31 15:04:15 E03020003: Database error [Oracle][ODBC][Ora]ORA-01408: such column list already indexed
HServer | 20151031 15:04:15 | is shutting down <upgrade complete> ****
Harvest SCM Server on either Unix or Windows OS. Oracle database.
In Harvest 12.1.3, the Harvest Administrator created the "HARPEERCOMMENT_VOBJID_IND" index to improve the database performance as directed by CA Technical Support. This fix was subsequently incorporated in the 12.6 release of Harvest. However the upgrade process did not take into consideration that the HARPEERCOMMENT_VOBJID_IND index was already created. An error resulted.
1. Step One: Drop the HARPEERCOMMENT_VOBJID_IND index from the Oracle database.
2. Step Two: run hdbsetup option UR again.