The pop-up window showing group metrics graph for a compatible resource group displays an error
Issue
- The pop-up window showing group metrics graph for a compatible resource group displays an error
- javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.SQLGrammarException: could not execute query The page requested cannot be displayed due to some error shown when trying to see group metrics graph for a compatible resource group;
- When clicking on any of the activity group metrics link I always get:
javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.SQLGrammarException: could not execute query The page requested cannot be displayed due to some error. You can view the stack trace return to the previous page, Dashboard, or Browse Resources page.
- A pop-up window that is opened when trying to see group metrics graph for a compatible group shows an error and rhq-server-log4j.log file contains ERROR message
ORA-01795: maximum number of expressions in a list is 1000
Environment
- Red Hat JBoss Operations Network (JON) 3.1.2
- Created a compatible recursive resource group with a big number of child resources (more then 1000);
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
