# Error deleting OPC Server **URL:** \ **Category:** Ignition\ **Created:** [December 12, 2013, 3:42pm UTC](https://forum.inductiveautomation.com/t/error-deleting-opc-server/7698 "2013-12-12T15:42:50Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![2Gi\_Technologie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/2gi_technologie/32/3307_2.png) [@2Gi\_Technologie](https://forum.inductiveautomation.com/u/2Gi_Technologie)\ **Post date:** [December 12, 2013, 3:42pm UTC](https://forum.inductiveautomation.com/t/error-deleting-opc-server/7698/1 "2013-12-12T15:42:50Z")
Hello, I can’t delete a OPC Server… Ignition 7.6.4 [code]16:36:42 ConfirmationPanel$1 java.lang.Exception: Error deleting OPC Server Connection “SOFREL” java.lang.Exception: Error deleting OPC Server Connection “SOFREL” at com.inductiveautomation.ignition.gateway.web.components.actions.DeleteRecordAction.doDelete(DeleteRecordAction.java:80) at com.inductiveautomation.ignition.gateway.web.components.actions.DeleteRecordAction.execute(DeleteRecordAction.java:146) at com.inductiveautomation.ignition.gateway.web.components.ConfirmationPanel$1.onClick(ConfirmationPanel.java:42) at org.apache.wicket.markup.html.link.Link.onLinkClicked(Link.java:189) at sun.reflect.GeneratedMethodAccessor327.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:258) at org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:216) at org.apache.wicket.core.request.handler.ListenerInterfaceRequestHandler.invokeListener(ListenerInterfaceRequestHandler.java:240) at org.apache.wicket.core.request.handler.ListenerInterfaceRequestHandler.respond(ListenerInterfaceRequestHandler.java:226) at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:814) at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:64) at org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:253) at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:210) at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:281) at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:188) at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:245) 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.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Unknown Source) Caused by: simpleorm.utils.SException$Jdbc: Executing DELETE FROM OPCServers WHERE OPCServers\_ID = ? for [OPCServerSettingsRecord 1 Deleted Dirty1] at simpleorm.sessionjdbc.SSessionJdbcHelper.flushExecuteUpdate(SSessionJdbcHelper.java:409) at simpleorm.sessionjdbc.SSessionJdbcHelper.flush(SSessionJdbcHelper.java:376) at simpleorm.sessionjdbc.SSessionJdbc.flush(SSessionJdbc.java:425) at simpleorm.sessionjdbc.SSessionJdbc.flush(SSessionJdbc.java:410) at simpleorm.sessionjdbc.SSessionJdbc.commitAndDetachDataSet(SSessionJdbc.java:351) at com.inductiveautomation.ignition.gateway.web.components.actions.DeleteRecordAction.doDelete(DeleteRecordAction.java:69) … 29 more Caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; FK\_UACONNECTIONSETTINGS\_SERVERSETTINGS table: UACONNECTIONSETTINGS at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at com.inductiveautomation.ignition.gateway.localdb.hsql.DelegatingDataSource$DelegatingConnection$DelegatingPreparedStatement.executeUpdate(DelegatingDataSource.java:584) at simpleorm.sessionjdbc.SSessionJdbcHelper.flushExecuteUpdate(SSessionJdbcHelper.java:407) … 34 more Caused by: org.hsqldb.HsqlException: integrity constraint violation: foreign key no action; FK\_UACONNECTIONSETTINGS\_SERVERSETTINGS table: UACONNECTIONSETTINGS at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.StatementDML.performReferentialActions(Unknown Source) at org.hsqldb.StatementDML.delete(Unknown Source) at org.hsqldb.StatementDML.executeDeleteStatement(Unknown Source) at org.hsqldb.StatementDML.getResult(Unknown Source) at org.hsqldb.StatementDMQL.execute(Unknown Source) at org.hsqldb.Session.executeCompiledStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) … 39 more[/code] ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [December 12, 2013, 4:15pm UTC](https://forum.inductiveautomation.com/t/error-deleting-opc-server/7698/2 "2013-12-12T16:15:38Z")
Can you delete it if you restart the gateway? ---
**Author:** ![2Gi\_Technologie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/2gi_technologie/32/3307_2.png) [@2Gi\_Technologie](https://forum.inductiveautomation.com/u/2Gi_Technologie)\ **Post date:** [December 12, 2013, 4:57pm UTC](https://forum.inductiveautomation.com/t/error-deleting-opc-server/7698/3 "2013-12-12T16:57:39Z")
After restart Gateway, i have the same problem. ---
**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\ **Post date:** [December 27, 2013, 11:06pm UTC](https://forum.inductiveautomation.com/t/error-deleting-opc-server/7698/4 "2013-12-27T23:06:31Z")
This sounds like something happened and the OPC Server will need to be manually removed from your server, you should call into our tech support (800-266-7798) for help removing the entries. ---
**Author:** ![2Gi\_Technologie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/2gi_technologie/32/3307_2.png) [@2Gi\_Technologie](https://forum.inductiveautomation.com/u/2Gi_Technologie)\ **Post date:** [January 9, 2014, 3:34pm UTC](https://forum.inductiveautomation.com/t/error-deleting-opc-server/7698/5 "2014-01-09T15:34:22Z")
Hi and happy new year ! 😃 you can not send me a procedure ? Thanks ---
**Author:** ![dave.fogle](https://avatars.discourse-cdn.com/v4/letter/d/43a26b/32.png) [@dave.fogle](https://forum.inductiveautomation.com/u/dave.fogle)\ **Post date:** [January 9, 2014, 7:36pm UTC](https://forum.inductiveautomation.com/t/error-deleting-opc-server/7698/6 "2014-01-09T19:36:23Z")
Unfortunately I'm not sure how many different tables need to be cleaned up. The process requires going into the internal database and manually running some delete queries. The easiest solution would to be to call into the support line. Is there some reason that this option does not work for you?