[Hyperic-hq-discuss] [JIRA] Created: (HHQ-789) Upgrade to 3.0.3 and 3.1 fail on Oracle

[Ryan M. (JIRA) <ji...@hy...>]

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