#1523 [HHQ-2079] Deleting Platform/Server/Services and possibly Ap

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-2079
While deleting the platform/server/services from the ResourceHub, Hibernate object not mapped exception is thrown.

Steps to reproduce:


1) Go to ResourceHub page


2) Remove the eam_event_log table entries for the selected platform/server/service (This step is an workaround to get through HHQ-1753).


3) Stop the agent to avoid further updates into eam_event_log table.


4) Delete the Platform or Server or Service.

Possible reason for this issue:


I see that the SVN revision on HQ - 9363 has some modifications related to having GroupMember object for EAM_RES_GRP_RES_MAP.


But, the ResourceDAO.deleteByInstances(AppdefEntityID[] ids) method still has the reference to ResGrpResMap (which was removed as part of rev. 9363)


as, deleteResourceObject(ids, "ResGrpResMap", "id.resource.id");

The full exception stack trace is:

org.jboss.tm.JBossTransactionRolledbackException: ResGrpResMap is not mapped [delete ResGrpResMap where id.resource.id in (select r.id from org.hyperic.hq.authz.server.session.Resource r, org.hyperic.hq.authz.server.session.ResourceType rt where r.resourceType.id=rt.id and rt.name = :rtname0 and r.instanceId in (:list0) ) ]; CausedByException is: ResGrpResMap is not mapped [delete ResGrpResMap where id.resource.id in (select r.id from org.hyperic.hq.authz.server.session.Resource r, org.hyperic.hq.authz.server.session.ResourceType rt where r.resourceType.id=rt.id and rt.name = :rtname0 and r.instanceId in (:list0) ) ]; nested exception is: org.hibernate.hql.ast.QuerySyntaxException: ResGrpResMap is not mapped [delete ResGrpResMap where id.resource.id in (select r.id from org.hyperic.hq.authz.server.session.Resource r, org.hyperic.hq.authz.server.session.ResourceType rt where r.resourceType.id=rt.id and rt.name = :rtname0 and r.instanceId in (:list0) ) ]; - nested throwable: (org.hibernate.hql.ast.QuerySyntaxException: ResGrpResMap is not mapped [delete ResGrpResMap where id.resource.id in (select r.id from org.hyperic.hq.authz.server.session.Resource r, org.hyperic.hq.authz.server.session.ResourceType rt where r.resourceType.id=rt.id and rt.name = :rtname0 and r.instanceId in (:list0) ) ]) at org.jboss.ejb.plugins.LogInterceptor.handleException(LogInterceptor.java:267) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:196) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624) at org.jboss.ejb.Container.invoke(Container.java:873) at sun.reflect.GeneratedMethodAccessor488.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644) at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155) at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104) at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:179) at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:165) at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:511) at org.hyperic.hq.application.HQApp$Snatcher.invokeProxyNext(HQApp.java:562) at org.hyperic.txsnatch.ProxySnatch.invoke(ProxySnatch.java:37) at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46) at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:511) at org.hyperic.hq.application.HQApp$Snatcher.invokeProxyNext(HQApp.java:562) at org.hyperic.txsnatch.ProxySnatch.invoke(ProxySnatch.java:37) at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55) at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97) at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86) at $Proxy243.removeService(Unknown Source) at org.hyperic.hq.ui.action.resource.hub.RemoveResourceAction.removeResources(RemoveResourceAction.java:138) at org.hyperic.hq.ui.action.resource.hub.RemoveResourceAction.execute(RemoveResourceAction.java:85) at org.hyperic.hq.ui.action.BaseRequestProcessor.processActionPerform(BaseRequestProcessor.java:63) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.hyperic.hq.ui.AuthenticationFilter.doFilter(AuthenticationFilter.java:143) at


...