Red Hat Bugzilla – Bug 598575
ORA-01400 on adding new alter notification
Last modified: 2010-06-23 19:32:24 EDT
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):
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:
Alert notification would be added.
Seems to be caused by columns not been dropped during schema upgrade. RHQ_ALERT_NOTIFICATION has following columns on fresh install:
and this columns after upgrade from an older version:
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.