Support Migration Notice: To update migrated JIRA cases click here to open a new case use www.vmware.com/go/sr | vFabric Hyperic 5.7.0 is Now Available

Hyperic HQ

Oracle upgrade from 4.5.0 to 4.6.0 is failing on running SchemaSpec: 3.207

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Blocker Blocker
  • Resolution: Fixed
  • Affects Version/s: 4.6
  • Fix Version/s: 4.6, 4.x Sprint 27
  • Component/s: Deprecated: Server
  • Environment:
    Oracle upgrade from 4.5.0 to 4.6.0
  • Case Links:
    none
  • Regression:
    No
  • Story Points:
    1
  • Tags:

Description

Steps to Reproduce

Oracle upgrade from 4.5.0 to 4.6.0 fails

Taskdefs loaded
--------------------------------------------------------------------------------
An ERROR occurred, the installation cannot continue.
FATAL EXCEPTION at /home/hyperic/HQ/4.6.0-EE-0718-241-upgr450ora/hyperic-hqee-installer-4.6.0.BUILD-SNAPSHOT/installer/data/setup.xml:502: : The following error occurred while executing this line:
/home/hyperic/HQ/4.6.0-EE-0718-241-upgr450ora/hyperic-hqee-installer-4.6.0.BUILD-SNAPSHOT/installer/data/setup.xml:511: The following error occurred while executing this line:
/home/hyperic/HQ/4.6.0-EE-0718-241-upgr450ora/hyperic-hqee-installer-4.6.0.BUILD-SNAPSHOT/installer/data/setup.xml:700: The following error occurred while executing this line:
/home/hyperic/HQ/4.6.0-EE-0718-241-upgr450ora/hyperic-hqee-installer-4.6.0.BUILD-SNAPSHOT/installer/data/setup-db-Oracle9i.xml:22: The following error occurred while executing this line:
/home/hyperic/HQ/4.6.0-EE-0718-241-upgr450ora/hyperic-hqee-installer-4.6.0.BUILD-SNAPSHOT/installer/data/setup-db-common.xml:75: The following error occurred while executing this line:
/home/hyperic/HQ/4.6.0-EE-0718-241-upgr450ora/hyperic-hqee-installer-4.6.0.BUILD-SNAPSHOT/installer/data/db-upgrade.xml:43: DBUpgrader: Error running SchemaSpec: 3.207: Error running SchemaSpecTask: org.hyperic.tools.ant.dbupgrade.SST_DirectSQL: Error executing statement desc=[null] SQL=[
alter table EAM_AGENT_PLUGIN_STATUS modify varchar2(100) null
] java.sql.SQLException: ORA-00904: : invalid identifier
--------------------------------------------------------------------------------
Deleting temporary JRE

Activity

Hide
Scott Feldstein added a comment -

corrected sql, should be fine now

Show
Scott Feldstein added a comment - corrected sql, should be fine now

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
    Last comment:
    2 years, 39 weeks, 3 days ago