The pop-up window showing group metrics graph for a compatible resource group displays an error

Solution Unverified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.