Receiving "Failed to uninventory the selected resources" message trying to un-inventory platform in JBoss ON
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.