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

HQ Server Upgrade (Oracle11g backend): java.sql.SQLException: ORA-30649: missing DIRECTORY keyword while upgrading from 4.5 to 4.6

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Critical Critical
  • Resolution: Fixed
  • Affects Version/s: 4.x Sprint 13
  • Fix Version/s: 4.6, 4.x Sprint 14
  • Component/s: Deprecated: Server
  • Environment:
    x86-linux, Oracle 11g backend, 4.6.0.BUILD-20110406.093634-155-x86-linux
  • Case Links:
    none
  • HQ Fix Version:
    4.6
  • Regression:
    No

Description

Steps to reproduce:
1) Import 4.5 dump file into oracle DB
2) Perform 4.5 to 4.6 upgrade with the latest 4.6 build

Following error is thrown:

[exec] Taskdefs loaded
[exec] --------------------------------------------------------------------------------
[exec] An ERROR occurred, the installation cannot continue.
[exec] FATAL EXCEPTION at /automation/upgradetest/upgrade-install/HQ-server-4.6.0-EE/20110406/hyperic-hqee-installer-4.6.0.BUILD-SNAPSHOT/installer/data/setup.xml:493: : The following error occurred while executing this line:
[exec] /automation/upgradetest/upgrade-install/HQ-server-4.6.0-EE/20110406/hyperic-hqee-installer-4.6.0.BUILD-SNAPSHOT/installer/data/setup.xml:502: The following error occurred while executing this line:
[exec] /automation/upgradetest/upgrade-install/HQ-server-4.6.0-EE/20110406/hyperic-hqee-installer-4.6.0.BUILD-SNAPSHOT/installer/data/setup.xml:683: The following error occurred while executing this line:
[exec] /automation/upgradetest/upgrade-install/HQ-server-4.6.0-EE/20110406/hyperic-hqee-installer-4.6.0.BUILD-SNAPSHOT/installer/data/setup-db-Oracle10g.xml:22: The following error occurred while executing this line:
[exec] /automation/upgradetest/upgrade-install/HQ-server-4.6.0-EE/20110406/hyperic-hqee-installer-4.6.0.BUILD-SNAPSHOT/installer/data/setup-db-common.xml:75: The following error occurred while executing this line:
[exec] /automation/upgradetest/upgrade-install/HQ-server-4.6.0-EE/20110406/hyperic-hqee-installer-4.6.0.BUILD-SNAPSHOT/installer/data/db-upgrade.xml:43: DBUpgrader: Error running SchemaSpec: 3.202: Error running SchemaSpecTask: org.hyperic.tools.ant.dbupgrade.SST_DirectSQL: Error executing statement desc=[null] SQL=[
[exec] alter table EAM_PLUGIN add DISABLED number(1) not null default 0
[exec] ] java.sql.SQLException: ORA-30649: missing DIRECTORY keyword
[exec] --------------------------------------------------------------------------------
[exec] Deleting temporary JRE
[exec] reset: standard error: Invalid argument
[exec]

Activity

Hide
Ilayaperumal Gopinathan added a comment -

Looks good with the fix.

Verified in 4.6.0.BUILD-20110608.111806-209.

Thanks!

Show
Ilayaperumal Gopinathan added a comment - Looks good with the fix. Verified in 4.6.0.BUILD-20110608.111806-209. Thanks!

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
    Last comment:
    2 years, 45 weeks, 6 days ago