#1317 [HHQ-1923] 3.2.1 to 4.0 upgrade on mysql fails

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-1923
     [exec] An ERROR occurred, the installation cannot continue.


     [exec] FATAL EXCEPTION at C:\work\qa\trunk\automation\upgrade\SERVER\HQ-MySQL\HQ-upgrade-EE\hyperic-hq-installer\installer-4.0.0-EE\data\setup.xm


l:401: : The following error occurred while executing this line:C:\work\qa\trunk\automation\upgrade\SERVER\HQ-MySQL\HQ-upgrade-EE\hyperic-hq-installer


\installer-4.0.0-EE\data\setup.xml:407: The following error occurred while executing this line:C:\work\qa\trunk\automation\upgrade\SERVER\HQ-MySQL\HQ-


upgrade-EE\hyperic-hq-installer\installer-4.0.0-EE\data\setup.xml:525: The following error occurred while executing this line:C:\work\qa\trunk\automat


ion\upgrade\SERVER\HQ-MySQL\HQ-upgrade-EE\hyperic-hq-installer\installer-4.0.0-EE\data\setup-db-MySQL.xml:21: The following error occurred while execu


ting this line:C:\work\qa\trunk\automation\upgrade\SERVER\HQ-MySQL\HQ-upgrade-EE\hyperic-hq-installer\installer-4.0.0-EE\data\setup-db-common.xml:95:


The following error occurred while executing this line:C:\work\qa\trunk\automation\upgrade\SERVER\HQ-MySQL\HQ-upgrade-EE\hyperic-hq-installer\installe


r-4.0.0-EE\data\db-upgrade.xml:28: DBUpgrader: Error running SchemaSpec: 3.107: Error running SchemaSpecTask: org.hyperic.tools.ant.dbupgrade.SST_Alte


rColumn: Error updating EAM_MEASUREMENT.DSN: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manu


al that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL' at line 1


     [exec] --------------------------------------------------------------------------------