JBoss ON server log continuously reports failed to purge resource types if resource type was a target of a group operation in a compatible or auto resource group

Issue

• server.log continues to report integrity constraint violated every few minutes:

  WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-5) SQL Error: 2292, SQLState: 23000
  ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-5) ORA-02292: integrity constraint (RHQADMIN.SYS_C007902) violated - child record found
  ERROR [org.hibernate.engine.jdbc.batch.internal.BatchingBatch] (RHQScheduler_Worker-5) HHH000315: Exception executing batch [could not execute batch]
  ERROR [org.rhq.enterprise.server.scheduler.jobs.AbstractStatefulJob] (RHQScheduler_Worker-5) Failed to execute job [PurgeResourceTypesJob]: javax.ejb.EJBException: java.lang.RuntimeException: Failed to purge resource types
  

• PurgeResourceTypesJob fails due to database integrity or foreign key constraint violation when attempting to remove a resource type's operation definition

  WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-2) SQL Error: 0, SQLState: 23503
  ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-2) Batch entry 0 delete from RHQ_OPERATION_DEF where ID=10582 was aborted.  Call getNextException to see the cause.
  WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-2) SQL Error: 0, SQLState: 23503
  ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-2) ERROR: update or delete on table "rhq_operation_def" violates foreign key constraint "rhq_operation_history_operation_def_id_fkey" on table "rhq_operation_history"
   (id)=(10582) is still referenced from table "rhq_operation_history".