| Summary: | RuntimeException upgrading existing 4.1 repository with 4.1 build from 6/23 | ||
|---|---|---|---|
| Product: | [Other] RHQ Project | Reporter: | Mike Foley <mfoley> |
| Component: | Database | Assignee: | RHQ Project Maintainer <rhq-maint> |
| Status: | CLOSED NOTABUG | QA Contact: | Mike Foley <mfoley> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 4.1 | CC: | hrupp |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2011-10-07 18:57:12 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
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