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

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