#4328 [HHQ-4011] Exception when starting the server after upgrade

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-4011
I was running through an upgrade scenario and came across the error below.

This upgrade was originally from AMS -> tc Server HQ 4.2.0.7-EE -- everything worked fine


Then I upgraded from 4.2.0.7-EE -> 4.3.0-EE

When trying to start the server I received the error. I believe I saw it in the hq-install-verbose.log too. I will attach it along with server.log.

user@user-desktop-vm:/opt/HQ/4.3$ ./server-4.3.0-EE/bin/hq-server.sh start


Starting HQ server...


Initializing HQ server configuration...


Checking jboss jndi port...


Checking jboss mbean port...


Starting HQ built-in database...


HQ built-in database started.


Verify HQ database schema...


Unable to locate tools.jar. Expected to find it in /opt/HQ/4.3/server-4.3.0-EE/lib/tools.jar


Loading taskdefs...


Taskdefs loaded

---

An ERROR occurred, the installation cannot continue.


FATAL EXCEPTION at /opt/HQ/4.3/server-4.3.0-EE/data/db-upgrade.xml:42: : DBUpgrader: Error running SchemaSpec: 3.196: Error running SchemaSpecTask: org.hyperic.tools.ant.dbupgrade.SST_DirectSQL: Error executing statement desc=[Adding virtual resource relation...] SQL=


           INSERT INTO EAM_RESOURCE_RELATION(ID, NAME, IS_HIER) VALUES (3, 'virtual', 1)


       org.postgresql.util.PSQLException: ERROR: column "is_hier" is of type boolean but expression is of type integer at character 57

---

Booting the HQ server (Using JAVA_OPTS=-XX:MaxPermSize=192m -Xmx512m -Xms64m)...


HQ server booted.


Login to HQ at: http://127.0.0.1:7080/