Created attachment 521765 [details]
RHQ Server log of upgrade failure
Description of problem: JOPR 2.3.1 upgrade to RHQ 4.1.1 fails (oracle as repo)
Version-Release number of selected component (if applicable):
JOPR 2.3.1 final to RHQ 4.1.1
Steps to Reproduce:
1. install JOPR 2.3.1. use oracle repo.
2. upgrade to RHQ 4.1
3. observe failure (see attachments)
Created attachment 521766 [details]
image of error
Created attachment 521767 [details]
this BZ was invalid, based on pilot error. improper cleaning of the database. the (incorrect) assumption was that a SQL script used to drop all tables with cascade constraints cleaned the database. this assumption proved invalid because sequences were not deleted. the existing sequence is in the logs attached to this BZ. schema changes are covered by the existing jenkins job ... https://hudson.qa.jboss.com/hudson/view/RHQ%20Core/job/rhq-master-ora-dbupgrade/
...which is passing now, and was passing at the time this BZ was logged on 9/6.