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, tools, and much more.