| Summary: | RHQ3 ---> RHQ4 Upgrade error with Oracle | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Other] RHQ Project | Reporter: | Mike Foley <mfoley> | ||||
| Component: | Database | Assignee: | Jay Shaughnessy <jshaughn> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Mike Foley <mfoley> | ||||
| Severity: | medium | Docs Contact: | |||||
| Priority: | medium | ||||||
| Version: | 4.0.0.Beta2 | CC: | hrupp, jshaughn | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | All | ||||||
| OS: | All | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | 4.0.0 | Doc Type: | Bug Fix | ||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2013-09-02 07:20:19 UTC | Type: | --- | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Bug Depends On: | |||||||
| Bug Blocks: | 585306 | ||||||
| Attachments: |
|
||||||
The problem is in the static sql queries in the upgrade task. Oracle does not allow for the ';' termination character in the query. Removing these should do the trick. I'll check this into the ie-fragment branch, which should eventually get merged into both the rhq4 release and master branches. There were more issues with the upgrade. All fixes pushed to master, release-4.0.0 and ie-fragment-fix branches. verified by performing RHQ3 --> RHQ4 migration. inventoried resources appeared in RHQ4 as expected. review of server logs (both rhq-server-log4j.log and rhqinstaller-dbupgrade.log) manifested no errors. Bulk closing of issues that were VERIFIED, had no target release and where the status changed more than a year ago. |
Created attachment 495811 [details] rhq-installer-dbupgrade.log Description of problem: RHQ3 ---> RHQ4 Upgrade error with Oracle Version-Release number of selected component (if applicable): How reproducible: 100% Steps to Reproduce: 1. RHQ3 install, add resources 2. RHQ4 upgrade 3. Actual results: 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-RELEASE2/rhq-server-4.0.0.TEST/logs/db-upgrade.xml]. Cause: /root/rhq/rhq-server-RELEASE2/rhq-server-4.0.0.TEST/logs/db-upgrade.xml:27: Failed to upgrade - error in spec version [2.102]. Cause: Error executing the task [org.rhq.core.db.ant.dbupgrade.SST_JavaTask] in schema spec version [2.102]. Cause: Java Task Error: class=[java.sql.SQLException: ORA-00911: invalid character ] -> org.apache.tools.ant.BuildException:Failed to upgrade - error in spec version [2.102]. Cause: Error executing the task [org.rhq.core.db.ant.dbupgrade.SST_JavaTask] in schema spec version [2.102]. Cause: Java Task Error: class=[java.sql.SQLException: ORA-00911: invalid character ] -> org.apache.tools.ant.BuildException:Failed to upgrade - error in spec version [2.102]. Cause: Error executing the task [org.rhq.core.db.ant.dbupgrade.SST_JavaTask] in schema spec version [2.102]. Cause: Java Task Error: class=[java.sql.SQLException: ORA-00911: invalid character ] -> org.apache.tools.ant.BuildException:Error executing the task [org.rhq.core.db.ant.dbupgrade.SST_JavaTask] in schema spec version [2.102]. Cause: Java Task Error: class=[java.sql.SQLException: ORA-00911: invalid character ] -> org.apache.tools.ant.BuildException:Java Task Error: class=[java.sql.SQLException: ORA-00911: invalid character ] -> java.sql.SQLException:ORA-00911: invalid character [SQLException=ORA-00911: invalid character ] Expected results: Additional info: see attached log files