#1228 [HHQ-1764] ORA-02429 SQL Exception while upgrading HQ server

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-1764


While upgrading the HQ Oracle 10g database from 3.2.1 schema to 4.0.0, following error occured:

An ERROR occurred, the installation cannot continue.


FATAL EXCEPTION at C:\work\Installer\4.0-642\hyperic-hq-installer\installer-4.0.0-EE\data\setup.xml:400: : The following error occurred while executing this line:


C:\work\Installer\4.0-642\hyperic-hq-installer\installer-4.0.0-EE\data\setup.xml:406: The following error occurred while executing this line:


C:\work\Installer\4.0-642\hyperic-hq-installer\installer-4.0.0-EE\data\setup.xml:525: The following error occurred while executing this line:


C:\work\Installer\4.0-642\hyperic-hq-installer\installer-4.0.0-EE\data\setup-db-Oracle9i.xml:21: The following error occurred while executing this line:


C:\work\Installer\4.0-642\hyperic-hq-installer\installer-4.0.0-EE\data\setup-db-common.xml:95: The following error occurred while executing this line:


C:\work\Installer\4.0-642\hyperic-hq-installer\installer-4.0.0-EE\data\db-upgrade.xml:28: DBUpgrader: Error running SchemaSpec: 3.101: Error running SchemaSpecTask: org.hyperic.tools.ant.dbupgrade.SST_DirectSQL: Error executing statement desc=[Drop discriminator column on EAM_MEASUREMENT] SQL=


            ALTER TABLE EAM_MEASUREMENT DROP COLUMN measurement_class


         java.sql.SQLException: ORA-02429: cannot drop index used for enforcement of unique/primary key