Skip to navigation

JON upgrade fails due to dbupgrade task failing with ORA-01408: such column list already indexed

Updated 2012-03-26T16:09:29+00:00

Issue

  • Failing to upgrade from JON 2.4.1
  • Server environment upgrade from 2.4.1 to 3.0 fails
  • Upgrade fails due to:

        [upgrade] [dbupgrade] 
        /opt/jboss/jon-server/logs/db-upgrade.xml:27: Failed to upgrade - error in spec version [2.102]. Cause: Error executing the task [org.rhq.core.db.ant.dbupgrade.SST_DirectSQL] in schema spec version [2.102]. Cause: The schema spec task [DirectSQL] has encountered an error. Cause: java.sql.SQLException: ORA-01408: such column list already indexed
    
  • Database schema upgrade fails due to duplicate index

Environment

  • JBoss Operations Network (JON) 3.0.0
  • Upgrading from a previous version of JON
  • Oracle 10g, 11g

Subscriber content preview. For full access to the Red Hat Knowledgebase, please log in.

Not a subscriber? Learn more about the benefits of Red Hat Subscriptions.