|
From: Ryan M. (JIRA) <ji...@hy...> - 2007-03-28 19:23:42
|
Upgrade to 3.0.3 and 3.1 fail on Oracle
---------------------------------------
Key: HHQ-789
URL: http://jira.hyperic.com/browse/HHQ-789
Project: Hyperic HQ
Type: Bug
Components: Installer
Versions: 3.0.0, 3.0.1, 3.0.2
Environment: HQ 3.1.0 Oracle 10g, upgrade from 3.0.2.
Reporter: Ryan Morgan
Assigned to: Jon Travis
Priority: Blocker
Fix For: 3.0.3, 3.1.0
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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.hyperic.com/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
|