RHN Satellite: cannot remove more than 1000 errata from a given channel

Solution Verified - Updated -

Issue

  • Cannot remove more than 1000 errata from a given channel
  • Internal Server Error on Web UI: "The server experienced a problem which prevented your request from being filled out. It may not be possible to execute this action at this time. Please help us correct this problem by contacting us with details of how you received this message."
  • Tomcat logs in /var/log/tomcat5/catalina.out shows:

2010-05-20 18:21:12,306 [TP-Processor16] ERROR com.redhat.rhn.common.hibernate.HibernateFactory - Query exectued with Collection larger than 1000
2010-05-20 18:21:13,936 [TP-Processor16] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: 1795, SQLState: 42000
2010-05-20 18:21:13,936 [TP-Processor16] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01795: maximum number of expressions in a list is 1000
2010-05-20 18:21:13,970 [TP-Processor16] WARN  org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class org.hibernate.exception.SQLGrammarException
2010-05-20 18:21:13,971 [TP-Processor16] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back
javax.servlet.ServletException: could not execute query
       at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
       at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
       at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
       at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:82)
       at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
       at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)

Environment

  • Red Hat Network (RHN) Satellite 5.3
  • Custom / cloned channels with more than 1000 errata

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content