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

Upgrade from build 12-20120110 to build 15-20120116 fails "Error creating bean with name 'dbKeystoreManager': Invocation of init method failed;"

Details

  • Type: Developer Developer
  • Status: Closed Closed
  • Priority: Critical Critical
  • Resolution: Fixed
  • Affects Version/s: 4.6.5
  • Fix Version/s: 4.6.5
  • Component/s: Deprecated: Installer
  • Environment:
    upgrade from hyperic-hqee-installer-4.6.5.BUILD-20120110.093953-12-x86-64-linux.tar.gz to hyperic-hqee-installer-4.6.5.BUILD-20120116.100442-15-x86-64-linux.tar.gz DB:Oracle
  • Case Links:
    none
  • Regression:
    No

Description

Steps to reproduce

Upgrade from build 12-20120110 to build 15-20120116
Start the server

Actual Results:

Server log error

Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.ID as ID131_0_, this_.ALIAS_NAME as ALIAS2_131_0_, this_.TYPE as TYPE131_0_, this_.CERT as CERT131_0_, this_.CERT_CHAIN as CERT5_131_0_, this_.FILE as FILE131_0_ from EAM_KEYSTORE this_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

Please see the attached server log for more details

  1. bootstrap.log
    17/Jan/12 3:30 PM
    43 kB
    Nipuna Bhayani
  2. server.log
    17/Jan/12 3:30 PM
    130 kB
    Nipuna Bhayani
  3. wrapper.log
    17/Jan/12 3:30 PM
    5 kB
    Nipuna Bhayani

Activity

Hide
Mayan Weiss added a comment -

i believe this is the same issue specify in the below (sent by mail):

Hi all,
Please ensure to run the following respective scripts on your existing local DB so as to incorporate a column addition to the EAM_KEYSTORE
Postgres
ALTER TABLE EAM_KEYSTORE ADD COLUMN FILE bytea
Mysql
ALTER TABLE EAM_KEYSTORE ADD COLUMN FILE BLOB
Oracle
ALTER TABLE EAM_KEYSTORE ADD COLUMN FILE BLOB

sorry for not sharing with QE earlier

Mayan

if this fixes this please close bug as invalid as we don't need to support upgrades between internal daily versions

Mayan

Show
Mayan Weiss added a comment - i believe this is the same issue specify in the below (sent by mail): Hi all, Please ensure to run the following respective scripts on your existing local DB so as to incorporate a column addition to the EAM_KEYSTORE Postgres ALTER TABLE EAM_KEYSTORE ADD COLUMN FILE bytea Mysql ALTER TABLE EAM_KEYSTORE ADD COLUMN FILE BLOB Oracle ALTER TABLE EAM_KEYSTORE ADD COLUMN FILE BLOB sorry for not sharing with QE earlier Mayan if this fixes this please close bug as invalid as we don't need to support upgrades between internal daily versions Mayan
Hide
Guy Segev added a comment -

Manual Alter table is required as the DDL modification was done in the scope of an existing version and would therefore be skipped by the dbupgrade procedure

Show
Guy Segev added a comment - Manual Alter table is required as the DDL modification was done in the scope of an existing version and would therefore be skipped by the dbupgrade procedure

People

Vote (0)
Watch (0)

Dates

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