12.6 Database Upgrade Failed

Article Id: 37672

Status: Published

Updated On: 14-02-2018 07:35

Legacy Id: TEC1263655

Products:

CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction:

Problem:

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

SQLSTATE=42S11
2015/10/31 15:04:15 E03020003: Database error [Oracle][ODBC][Ora]ORA-01408: such column list already indexed

SQLSTATE=42S11 .
HServer | 20151031 15:04:15 | is shutting down <upgrade complete> ****

Environment:

Harvest SCM Server on either Unix or Windows OS. Oracle database.

Cause:

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.

Resolution:

1. Step One: Drop the HARPEERCOMMENT_VOBJID_IND index from the Oracle database.

2. Step Two: run hdbsetup option UR again.

Environment:

Release: SCMNCR99000-12.6-Harvest-Software Change Manager-Named User-Competitive Replacem
Component: