Bug 570453

Summary:	table column too wide for Oracle in B03
Product:	[Other] RHQ Project	Reporter:	Heiko W. Rupp <hrupp>
Component:	Alerts	Assignee:	RHQ Project Maintainer <rhq-maint>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Sudhir D <sdharane>
Severity:	medium	Docs Contact:
Priority:	low
Version:	3.0.0	CC:	rtimaniy
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
URL:	http://community.jboss.org/message/529884#529884
Whiteboard:
Fixed In Version:	2.4	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-08-12 16:53:23 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:	580042
Bug Blocks:

Description Heiko W. Rupp 2010-03-04 11:35:59 UTC

Description of problem:


Failed to save properties and fully deploy - RHQ Server will not function properly Cause: java.sql.SQLException:Failed to create table [RHQ_ALERT_NOTIF_LOG] [ErrorCode=[910]; SQLState=[42000]; Message=[ORA-00910: specified length too long for its datatype ]

Version-Release number of selected component (if applicable):

3.0.0.B03

How reproducible:

Install B03 on Oracle

Comment 1 Heiko W. Rupp 2010-03-04 11:49:35 UTC

Fixed in b9e910b

Comment 2 Steve Salevan 2010-03-09 18:12:46 UTC

QA is uncertain regarding the reproducer for this bug...  Heiko, could you clarify?

Comment 3 Heiko W. Rupp 2010-03-09 19:58:20 UTC

The table definition for alert_notification_log contained 2 columns that were defined as varchar2(4096), but Oracle only groks 4000 bytes. So server startup after install of/upgrade to 3.0.0.B03 on oracle failed.

QA needs to make sure the 3.0.0.b04 build can successfully be deployed against oracle (and Postgres of course)

Comment 4 Heiko W. Rupp 2010-03-09 19:58:50 UTC

The table definition for alert_notification_log contained 2 columns that were defined as varchar2(4096), but Oracle only groks 4000 bytes. So server startup after install of/upgrade to 3.0.0.B03 on oracle failed.

QA needs to make sure the 3.0.0.b04 build can successfully be deployed against oracle (and Postgres of course)

Also have a look at http://community.jboss.org/message/529884#529884 for the original issue.

Comment 5 Corey Welton 2010-03-24 02:55:52 UTC

qa -> sdharane

Comment 6 Sudhir D 2010-04-07 11:43:45 UTC

blocked by https://bugzilla.redhat.com/show_bug.cgi?id=580042

Comment 7 Rajan Timaniya 2010-04-19 10:26:18 UTC

Verified on JON build #88 - Revision: 10607

RHQ Server installed on Oracle 10g and 11g without java.sql.SQLException

Comment 8 Corey Welton 2010-08-12 16:53:23 UTC

Mass-closure of verified bugs against JON.