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
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.