History | Log In     View a printable version of the current page.  
HQ 4.0 EE Release is Now Available | HQ 3.2.5-EE Maintenance Release is Now Available
Issue Details (XML | Word | Printable)

Key: HHQ-789
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Blocker Blocker
Assignee: Jon Travis
Reporter: Ryan Morgan
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Hyperic HQ

Upgrade to 3.0.3 and 3.1 fail on Oracle

Created: 28/Mar/07 09:22 AM   Updated: 30/Jul/07 12:12 PM
Component/s: Installer
Affects Version/s: 3.0.0, 3.0.1, 3.0.2
Fix Version/s: 3.0.3, 3.1.0

Environment: HQ 3.1.0 Oracle 10g, upgrade from 3.0.2.

Last comment: 68 weeks, 3 days ago
Resolution Date: 02/Apr/07 03:25 PM


 Description  « Hide

In 3.0.3 we have changed the measurement tables on Oracle back from double precision to NUMBER(24,5).

It's also likely we'll have issues with Postgres.

An ERROR occurred, the installation cannot continue.
FATAL EXCEPTION at /home/hyperic/hyperic-hq-installer/installer-3.1.0-EE/data/setup.xml:435: : The following error occurred while exe cuting this line:
/home/hyperic/hyperic-hq-installer/installer-3.1.0-EE/data/setup.xml:449: The following error occurred while executing this line:
/home/hyperic/hyperic-hq-installer/installer-3.1.0-EE/data/setup.xml:553: The following error occurred while executing this line:
/home/hyperic/hyperic-hq-installer/installer-3.1.0-EE/data/setup-db-Oracle9i.xml:21: The following error occurred while executing thi s line:
/home/hyperic/hyperic-hq-installer/installer-3.1.0-EE/data/setup-db-common.xml:95: The following error occurred while executing this line:
/home/hyperic/hyperic-hq-installer/installer-3.1.0-EE/data/db-upgrade.xml:28: DBUpgrader: Error running SchemaSpec: 3.22: Error running SchemaSpecTask: org.hyperic.tools.ant.dbupgrade.SST_DirectSQL: Error executing statement desc=[null] SQL=[
alter table eam_measurement_data modify (
value NUMERIC(24,5)
)
] java.sql.SQLException: ORA-01440: column to be modified must be empty to decrease precision or scale
--------------------------------------------------------------------------------
Deleting temporary JRE


 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
Nipuna Bhayani - 30/Jul/07 12:12 PM
Works fine in Release 3.1.0-433