Bug 536012 (RHQ-407) - "ORA-01795: maximum number of expressions in a list is 1000" error on Monitor tab for Compat Group w/ >1,000 members
Summary: "ORA-01795: maximum number of expressions in a list is 1000" error on Monitor...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: RHQ-407
Product: RHQ Project
Classification: Other
Component: Monitoring
Version: 0.1
Hardware: All
OS: All
medium
medium
Target Milestone: ---
: ---
Assignee: Joseph Marques
QA Contact:
URL: http://jira.rhq-project.org/browse/RH...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2008-05-01 16:56 UTC by Ian Springer
Modified: 2013-08-06 00:34 UTC (History)
2 users (show)

Fixed In Version: 1.4
Clone Of:
Environment:
Last Closed: 2010-10-07 03:24:44 UTC
Embargoed:

Attachments (Terms of Use)
Comment (67.44 KB, text/plain)
2008-05-01 16:56 UTC, Ian Springer 		no flags Details
View All

Description Ian Springer 2008-05-01 16:56:00 UTC 
Created attachment 915144 [details]
Comment

(This comment was longer than 65,535 characters and has been moved to an attachment by Red Hat Bugzilla).
Comment 1 Heiko W. Rupp 2008-05-02 08:57:08 UTC 
We have a bunch of those that use IN() clauses which makes the statement fail.
Luckily, as few of those can be rewrtitten to calculate what are the current arguments to IN() by other relational means.
Comment 2 Joseph Marques 2008-07-02 10:36:51 UTC 
this is a nice-to-have, but will only affect people that have rather large inventories who group their compatible resources in a specific way.  pushing to be considered for 2.0 time frame.
Comment 3 Joseph Marques 2009-02-06 16:31:30 UTC 
rev2942 - add methods to calculate alert counts off of autogroups and compatible groups; 
(started this work weeks ago but never finished, wanted to get it off my box considering RHQ-1464 will be incoming soon);
Comment 4 Corey Welton 2009-08-05 18:07:53 UTC 
Push to  1.4
Comment 5 Red Hat Bugzilla 2009-11-10 21:08:39 UTC 
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-407
This bug is related to RHQ-408
Comment 6 wes hayutin 2010-02-16 21:09:31 UTC 
Mass move to component = Monitoring
Comment 7 Corey Welton 2010-10-07 03:24:44 UTC 
closing, fixed long ago.
Note You need to log in before you can comment on or make changes to this bug.