Bug 1004319 - rhqctl upgrade on windows/oacle failed while dbUpgrade
Summary: rhqctl upgrade on windows/oacle failed while dbUpgrade
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: RHQ Project
Classification: Other
Component: Installer
Version: 4.9
Hardware: x86_64
OS: Windows
unspecified
urgent
Target Milestone: ---
: RHQ 4.9
Assignee: John Sanda
QA Contact: Mike Foley
URL:
Whiteboard:
Depends On:
Blocks: 951619
TreeView+ depends on / blocked
 
Reported: 2013-09-04 12:07 UTC by Armine Hovsepyan
Modified: 2015-09-03 00:01 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-09-24 19:08:28 UTC
Embargoed:

Attachments (Terms of Use)

Description Armine Hovsepyan 2013-09-04 12:07:25 UTC 
Description of problem:
rhqctl upgrade on windows/oacle failed while dbUpgrade

Version-Release number of selected component (if applicable):
4.5.1. -> 4.9 281e8e2

How reproducible:
2 out of 2

Steps to Reproduce:
1. install and start rhq 4.5.1 
2. install and start agent 
3. run rhqctl.bat upgrade  --from-server-dir C:\rhq-server-4.5.1

Actual results:
faild on dbUpgrade -> ORA-00984: column not allowed here


Expected results:
rhq upgrades to 4.9


Additional info:
full db upgrade log -> http://d.pr/f/pg8E
OS: windows 2008
DB: oracle  11g  xe
java:  oracle jre 1.6
Comment 2 John Sanda 2013-09-04 13:27:12 UTC 
This is my error. I will go ahead and make the fix asap. I will also see if the jenkins upgrade testing job did catch this.
Comment 3 John Sanda 2013-09-04 13:37:38 UTC 
Fix pushed to master.

commit hash: 7147aa05e60cb

The dbupgrade jenkins job has not run since July 26. The offending change to the dbupgrade script was made on 8/31. We will have to investigate why the jenkins job has not run.
Comment 4 Armine Hovsepyan 2013-09-05 11:24:03 UTC 
verified - dbUpgrade goes forward without exceptions - leading to server upgrade (even though not started correctly --  see #1004731)
Comment 6 Heiko W. Rupp 2013-09-24 19:08:28 UTC 
Bulk closing of RHQ 4.9 verified items
Note You need to log in before you can comment on or make changes to this bug.