Bug 818433

Summary:	[installer-war] two tests in DBInstallationTest are failing with "ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Integer" errors when run against Oracle
Product:	[Other] RHQ Project	Reporter:	Ian Springer <ian.springer>
Component:	Database	Assignee:	Lukas Krejci <lkrejci>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Mike Foley <mfoley>
Severity:	high	Docs Contact:
Priority:	urgent
Version:	4.3	CC:	ccrouch, fbrychta, hrupp, vnguyen
Target Milestone:	---
Target Release:	JON 3.1.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:	Oracle DB
Last Closed:	2013-09-03 15:03:50 UTC	Type:	Bug
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:	620931

Description Ian Springer 2012-05-03 05:29:18 UTC

The following tests started failing in the rhq-master-ora Jenkins job after the password obfuscation changes got committed:

 org.rhq.enterprise.installer.DBInstallationTest.upgradeJON240Schema 	
 org.rhq.enterprise.installer.DBInstallationTest.upgradeJON300Schema 

Here's the exception:

java.lang.RuntimeException: Cannot run ANT on script [/tmp/db-upgrade.xml]. Cause: /tmp/db-upgrade.xml:27: Failed to upgrade - error in spec version [2.121]. Cause: Error executing the task [org.rhq.core.db.ant.dbupgrade.SST_JavaTask] in schema spec version [2.121]. Cause: Java Task Error: class=[java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Integer]
	at org.rhq.enterprise.installer.ServerInformation.startAnt(ServerInformation.java:769)
	at org.rhq.enterprise.installer.ServerInformation.upgradeExistingDatabaseSchema(ServerInformation.java:283)
	at org.rhq.enterprise.installer.DBInstallationTest.upgradeJON300Schema(DBInstallationTest.java:102)


This issue should be fixed asap so we can get the Jenkins green again, since we are getting close to the 4.4 release.

Comment 1 Lukas Krejci 2012-05-03 08:52:30 UTC

commit 501fe6e4677485c6a24527bda6f39ecec5bb1191
Author: Lukas Krejci <lkrejci>
Date:   Thu May 3 10:48:25 2012 +0200

    [BZ 818433] - Another batch of fixes for the obfuscation upgrade task to be Oracle compatible.

Comment 2 Viet Nguyen 2012-05-29 16:48:25 UTC

tested oracle upgrade with 3.1 ER6

Comment 4 Heiko W. Rupp 2013-09-03 15:03:50 UTC

Bulk closing of old issues in VERIFIED state.