#4137 [HHQ-3826] tc Server plugin deployment fails after upgrade d

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-3826
The tc Server plugin has removed server type "SpringSource tc Server" and replaced with "SpringSource tc Runtime". After an upgrade, plugin deployment is failing when trying to remove the old server type due to the Exception below. Looks like this is related to the fact that they also changed their UI plugins to use the new "SpringSource tc Runtime" as an attach point? I'm guessing since product plugin deployment occurs first, the old ui plugin attach points are still present?

See https://issuetracker.springsource.com/browse/TCSRV-1267, specifically the server.log (agent.log stack trace in tkt looks to just be a symptom of this problem)

2010-03-23 08:23:51,793 ERROR [main] [org.hibernate.util.JDBCExceptionReporter@78] Cannot delete or update a parent row: a foreign key constraint fails (HQ/EAM_UI_ATTACH_RSRC, CONSTRAINT FKD9F7A78FFC176AE FOREIGN KEY (RESOURCE_ID) REFERENCES EAM_RESOURCE (ID))


2010-03-23 08:23:51,797 ERROR [main] [org.hibernate.event.def.AbstractFlushingEventListener@301] Could not synchronize database state with session


org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update


at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)


at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)


at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)


at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)


at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)


at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)


at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)


at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)


at org.hyperic.hq.authz.server.session.ResourceDAO.createPrivate(ResourceDAO.java:83)


at org.hyperic.hq.authz.server.session.ResourceDAO.create(ResourceDAO.java:59)


at org.hyperic.hq.authz.server.session.ResourceManagerEJBImpl.createResource(ResourceManagerEJBImpl.java:151)


at sun.reflect.GeneratedMethodAccessor436.invoke(Unknown Source)


at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)


at java.lang.reflect.Method.invoke(Method.java:597)


at org.jboss.invocation.Invocation.performCall(Invocation.java:359)


at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)


at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)


at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)


at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)


at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:572)


at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:647)


at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)


at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)


at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)


at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:572)


at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:647)


at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)


at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)


at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)


at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)


at org.jboss.ejb.Container.invoke(Container.java:960)


at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)


at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)


at $Proxy346.createResource(Unknown Source)


at org.hyperic.hq.appdef.server.session.AppdefSessionEJB.createAuthzResource(AppdefSessionEJB.java:158)


at org.hyperic.hq.appdef.server.session.AppdefSessionEJB.createAuthzResource(AppdefSessionEJB.java:139)


at org.hyperic.hq.appdef.server.session.ServerManagerEJBImpl.updateServerTypes(ServerManagerEJBImpl.java:1429)