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