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, 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