Error on Linux deleting device v5580

Error on Linux deleting device v5580

I started it up. Installed it... added a single device. did a config backup via ssh real quick... then i wanted to delete it. Errors out says it failed to delete. Generates this in the ncm0.txt .. and yes I've restarted the service... still same error.

[23:08:22:259]|[09-14-2011]|[com.adventnet.ncm.client.inventory.NCMResourceAction]|[SEVERE]|[18]|: Exception while updating Resource|com.adventnet.persistence.DataAccessException: Exception occured while executing SQL to delete rows
        at com.adventnet.persistence.DeleteUtil.executeDelete(DeleteUtil.java:406)
        at com.adventnet.persistence.DeleteUtil.delete(DeleteUtil.java:162)
        at com.adventnet.persistence.DataAccess.delete(DataAccess.java:931)
        at com.adventnet.persistence.DataAccess.delete(DataAccess.java:924)
        at com.adventnet.persistence.interceptor.CorePersistenceInterceptor.process(CorePersistenceInterceptor.java:76)
        at com.adventnet.authorization.interceptor.AuthorizationInterceptor.process(AuthorizationInterceptor.java:65)
        at com.adventnet.persistence.PersistenceBean.process(PersistenceBean.java:553)
        at com.adventnet.persistence.PersistenceBean.delete(PersistenceBean.java:429)
        at com.adventnet.persistence.PersistenceBean.delete(PersistenceBean.java:109)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.adventnet.mfw.bean.BeanProxy.invoke(BeanProxy.java:69)
        at $Proxy1.delete(Unknown Source)
        at com.adventnet.ncm.client.inventory.NCMResourceAction.executeInTxn(NCMResourceAction.java:141)
        at com.adventnet.ncm.client.action.TxnAction.execute(TxnAction.java:36)
        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
        at com.adventnet.client.action.web.MenuActionProcessorSevlet.includeAction(MenuActionProcessorSevlet.java:113)
        at com.adventnet.client.action.web.MenuActionProcessorSevlet.service(MenuActionProcessorSevlet.java:67)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
        at com.adventnet.client.view.web.StateFilter.doFilter(StateFilter.java:46)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.adventnet.ncm.importusers.NTLMV2CredentialAssociationFilter.doFilter(NTLMV2CredentialAssociationFilter.java:34)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.adventnet.ncm.importusers.NTLMV2Filter.doFilter(NTLMV2Filter.java:96)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.adventnet.authentication.filter.AssociateCredential.doFilter(AssociateCredential.java:100)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
        at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:421)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Cannot delete or update a parent row: a foreign key constraint fails (`deviceexpert/SnmpV3ConnectionSpec`, CONSTRAINT `SNMPSECURITYPARAMS_FK` FOREIGN KEY (`SSParamsID`) REFERENCES `SnmpSecurityModelParams` (`SSParamsID`))
        at com.adventnet.db.adapter.Jdbc20DBAdapter.handleSQLException(Jdbc20DBAdapter.java:1096)
        at com.adventnet.db.adapter.Jdbc20DBAdapter.execute(Jdbc20DBAdapter.java:318)
        at com.adventnet.db.api.RelationalAPI.execute(RelationalAPI.java:734)
        at com.adventnet.persistence.DeleteUtil.executeDelete(DeleteUtil.java:391)
        ... 62 more
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`deviceexpert/SnmpV3ConnectionSpec`, CONSTRAINT `SNMPSECURITYPARAMS_FK` FOREIGN KEY (`SSParamsID`) REFERENCES `SnmpSecurityModelParams` (`SSParamsID`))
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:925)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2864)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1567)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1659)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3112)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3041)
        at com.mysql.jdbc.Statement.execute(Statement.java:686)
        at org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:104)
        at com.adventnet.db.adapter.Jdbc20DBAdapter.execute(Jdbc20DBAdapter.java:309)
        ... 64 more






















































































                  New to ADSelfService Plus?