Bug 739090 - plugin config for a group w/ 1000+ members fails to load due to "ORA-01795: maximum number of expressions in a list is 1000" error
plugin config for a group w/ 1000+ members fails to load due to "ORA-01795: m...
Product: RHQ Project
Classification: Other
Component: Core UI (Show other bugs)
Unspecified Unspecified
medium Severity medium (vote)
: ---
: ---
Assigned To: RHQ Project Maintainer
Mike Foley
Depends On:
Blocks: rhq-ora-in-clause jon3 jon30-perf
  Show dependency treegraph
Reported: 2011-09-16 10:43 EDT by Ian Springer
Modified: 2013-08-05 20:40 EDT (History)
3 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2012-02-07 14:25:37 EST
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Ian Springer 2011-09-16 10:43:46 EDT
This is all that's logged to the Server log (no stack trace):

10:37:40,012 WARN  [JDBCExceptionReporter] SQL Error: 1795, SQLState: 42000
10:37:40,012 ERROR [JDBCExceptionReporter] ORA-01795: maximum number of expressions in a list is 1000

There is no error displayed in the GUI, but the config editor never loads. The only content for the subtab remains a button bar with a grayed out Save button.
Comment 1 John Mazzitelli 2011-09-30 15:27:56 EDT
I'm not seeing this and I have a compat group of 1020 members. However, this does cause timeouts as per bug #737196 and I will try to work on speeding that up.
Comment 2 John Mazzitelli 2011-09-30 15:30:16 EDT
lowering this to medium because I am not seeing this, however, I am going to leave it open. Once the issues are done with the plugin config views and we are sure this issue doesn't appear or re-appear, we can close it.
Comment 3 John Mazzitelli 2011-10-06 09:50:27 EDT
I have a unit test that tests for this - see bug #737196. This should no longer be a problem.
Comment 4 Mike Foley 2011-10-06 13:49:27 EDT
performed additional functional regression testing around groups.
Comment 5 Mike Foley 2012-02-07 14:25:37 EST
changing status of VERIFIED BZs for JON 2.4.2 and JON 3.0 to CLOSED/CURRENTRELEASE

Note You need to log in before you can comment on or make changes to this bug.