Description of problem: Adding an alert notification fails with ORA-01400 when working on an upgraded database schema. Doesn't appear on fresh installed schema. Version-Release number of selected component (if applicable): 3.0.0B06 How reproducible: Install RHQ Server 3.0.0B06 on an existing, older schema and let install procedure upgrade it. Try to create a alert notification. After choosing alert sender type, click OK. ORA-01400 for RHQ_ALERT_NOTIFICATION.NOTIFICATION_TYPE appears. Steps to Reproduce: 1. 2. 3. Actual results: ORA-01400 Expected results: Alert notification would be added. Additional info: Seems to be caused by columns not been dropped during schema upgrade. RHQ_ALERT_NOTIFICATION has following columns on fresh install: ID ALERT_DEFINITION_ID SENDER_CONFIG_ID SENDER_NAME and this columns after upgrade from an older version: ID NOTIFICATION_TYPE ALERT_DEFINITION_ID NOTIF_TEMPLATE_ID ALERT_CONFIG_ID ALERT_SENDER_NAME ALERT_ORDER NAME SENDER_CONFIG_ID SENDER_NAME Should be save to drop the additional columns.
Thilo Solbrig, thank you for catching this. There were indeed some minor bugs in the upgrade functionality which have now been resolved. When 3.0.0 is released within the next week or so, the upgrade should work from any previous GA version.