Bug 216044 - 500 error on Active Users page when you have more than 1000 users.
Summary: 500 error on Active Users page when you have more than 1000 users.
Status: CLOSED DUPLICATE of bug 645385
Alias: None
Product: Red Hat Network
Classification: Red Hat
Component: RHN/Web Site
Version: rhn500
Hardware: All
OS: Linux
Target Milestone: ---
Assignee: Mike McCune
QA Contact: Brandon Perkins
Depends On:
Blocks: 145467
TreeView+ depends on / blocked
Reported: 2006-11-16 22:18 UTC by Ken Ganong
Modified: 2010-11-19 20:12 UTC (History)
2 users (show)

Clone Of:
Last Closed: 2010-11-19 20:12:28 UTC

Attachments (Terms of Use)

Description Ken Ganong 2006-11-16 22:18:08 UTC
Create 1001 users.
Go to Users tab.

The reason this is happening has 2 parts:
1. The data for the new list tag on that page is elaborated all at once.
2. The way we elaborate data is by putting it all into a single query with a
list of ids.....   oracle doesn't allow that list to exceed 1000 items ( The IN

We can't just cause the list to page correctly, becuase the list has sortable
columns. Those need to access every member of the list at once.

Comment 1 Red Hat Bugzilla 2007-04-12 01:45:47 UTC
User bnackash@redhat.com's account has been closed

Comment 2 Grant Gainey 2010-11-19 20:12:28 UTC
Work was done as part of 645385

*** This bug has been marked as a duplicate of bug 645385 ***

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