Bug 700868
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: | |||||
Embargoed: | |||||||
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