RHN Satellite: cannot remove more than 1000 errata from a given channel
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.