Receiving "Failed to uninventory the selected resources" message trying to un-inventory platform in JBoss ON

Solution Verified - Updated -

Issue

  • I have been trying to uninventory a few platforms that we have decommissioned. Unfortunately when I click the "uninventory" button, I get an error message "Failed to uninventory the selected resources"
  • Attempt to remove platform from inventory fails with the following messages:
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/0.0.0.0:7080-9) Batch entry 0 delete from RHQ_AGENT where ID=10111 was aborted.  Call getNextException to see the cause.
09:04:15,471 
WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/0.0.0.0:7080-9) SQL Error: 0, SQLState: 23503
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/0.0.0.0:7080-9) ERROR: update or delete on table "rhq_agent" violates foreign key constraint "rhq_resource_agent_id_fkey" on table "rhq_resource"
  Detail: Key (id)=(10111) is still referenced from table "rhq_resource".
ERROR [org.hibernate.engine.jdbc.batch.internal.BatchingBatch] (http-/0.0.0.0:7080-9) HHH000315: Exception executing batch [could not perform addBatch]
ERROR [org.jboss.as.ejb3.invocation] (http-/0.0.0.0:7080-9) JBAS014134: EJB Invocation failed on component ResourceManagerBean for method public abstract java.util.List org.rhq.enterprise.server.resource.ResourceManagerLocal.uninventoryResourceInNewTransaction(int): javax.ejb.EJBException: java.lang.IllegalStateException: Failed to uninventory platform. This can happen if new resources were actively being imported. Please wait and try again shortly.
  • I try to remove platform from inventory, but it fails with the following error:
ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-02292: integrity constraint (OEJD.SYS_C006547) violated - child record found

Environment

  • Red Hat JBoss Operations Network (JON)
    • 3.1.2
    • 3.2

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.