Bug 570453 - table column too wide for Oracle in B03
Summary: table column too wide for Oracle in B03
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: RHQ Project
Classification: Other
Component: Alerts
Version: 3.0.0
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
: ---
Assignee: RHQ Project Maintainer
QA Contact: Sudhir D
URL: http://community.jboss.org/message/52...
Whiteboard:
Depends On: 580042
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-03-04 11:35 UTC by Heiko W. Rupp
Modified: 2010-08-12 16:53 UTC (History)
1 user (show)

Fixed In Version: 2.4
Clone Of:
Environment:
Last Closed: 2010-08-12 16:53:23 UTC
Embargoed:

Attachments (Terms of Use)

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.
Note You need to log in before you can comment on or make changes to this bug.