hyperic-hq-installer-3.0.0-296-win32.zip
db-upgrade.xml file contains 3 statements with a ';' in it which causes the upgrade to fail as it recognises the ';' as an invalid character. Solution was to remove the ';' from the code.
<statement>
UPDATE eam_metric_prob SET additional = 0 WHERE additional IS NULL;
</statement>
and
<!-- Add the timeestamp column to alert_action_log -->
<schemaSpec version="3.11">
<schema-addColumn table="EAM_ALERT_ACTION_LOG"
column="TIMESTAMP" columnType="LONG">
<initializer>
update eam_alert_action_log
set timestamp = (select ctime from eam_alert a
where a.id = alert_id)
where alert_id is not null;
</initializer>
</schema-addColumn>
<schema-directSQL>
<statement>
update eam_alert_action_log
set timestamp = (select timestamp from eam_galert_logs a
where a.id = galert_id)
where galert_id is not null;
</statement>
</schema-directSQL>
<schema-alterColumn table="EAM_ALERT_ACTION_LOG"
column="TIMESTAMP" nullable="NOT NULL"/>
</schemaSpec>