Description of problem:  RuntimeException upgrading existing 4.1 repository with 4.1 build from 6/23


Version-Release number of selected component (if applicable):  4.1 6/23 build ... updating an existing Oracle repository from RHQ 4.1 6/?? build.


How reproducible:
100%

Steps to Reproduce:
1.  install 6/23 and keep existing data from previous rhq repository (oracle)
2.
3.
  
Actual results:


Expected results:


Additional info:
   1.
      Failed to save properties and fully deploy - RHQ Server will not function properly Cause: java.lang.RuntimeException:Cannot run ANT on script [/root/rhq/rhq-server-4.1.0-SNAPSHOT/logs/db-upgrade.xml]. Cause: /root/rhq/rhq-server-4.1.0-SNAPSHOT/logs/db-upgrade.xml:27: Failed to upgrade - error in spec version [2.110]. Cause: Error executing the task [org.rhq.core.db.ant.dbupgrade.SST_AlterColumn] in schema spec version [2.110]. Cause: Failed to alter column. Cause: java.sql.SQLException: ORA-01451: column to be modified to NULL cannot be modified to NULL -> org.apache.tools.ant.BuildException:Failed to upgrade - error in spec version [2.110]. Cause: Error executing the task [org.rhq.core.db.ant.dbupgrade.SST_AlterColumn] in schema spec version [2.110]. Cause: Failed to alter column. Cause: java.sql.SQLException: ORA-01451: column to be modified to NULL cannot be modified to NULL -> org.apache.tools.ant.BuildException:Failed to upgrade - error in spec version [2.110]. Cause: Error executing the task [org.rhq.core.db.ant.dbupgrade.SST_AlterColumn] in schema spec version [2.110]. Cause: Failed to alter column. Cause: java.sql.SQLException: ORA-01451: column to be modified to NULL cannot be modified to NULL -> org.apache.tools.ant.BuildException:Error executing the task [org.rhq.core.db.ant.dbupgrade.SST_AlterColumn] in schema spec version [2.110]. Cause: Failed to alter column. Cause: java.sql.SQLException: ORA-01451: column to be modified to NULL cannot be modified to NULL -> org.apache.tools.ant.BuildException:Failed to alter column. Cause: java.sql.SQLException: ORA-01451: column to be modified to NULL cannot be modified to NULL -> java.sql.SQLException:ORA-01451: column to be modified to NULL cannot be modified to NULL [SQLException=ORA-01451: column to be modified to NULL cannot be modified to NULL ] 


Submit a correction or amend