# Cant Delete database connection **URL:** \ **Category:** Ignition\ **Created:** [June 25, 2012, 9:02pm UTC](https://forum.inductiveautomation.com/t/cant-delete-database-connection/4702 "2012-06-25T21:02:41Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![AndyK76](https://avatars.discourse-cdn.com/v4/letter/a/edb3f5/32.png) [@AndyK76](https://forum.inductiveautomation.com/u/AndyK76)\ **Post date:** [June 25, 2012, 9:02pm UTC](https://forum.inductiveautomation.com/t/cant-delete-database-connection/4702/1 "2012-06-25T21:02:41Z")
When I try and delete a database connection in the Configure tab, I am getting a red error box that says: Cannot delete database connection “DatabaseTest”, the following objects depend on it: ProductionSettings: “null” Where do I go to remove this dependency so I can delete this database connection? I am running Ignition 7.5.0 (b1079) 32 bit on Windows 7. Thanks! ---
**Author:** ![James.Lorenz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/james.lorenz/32/3290_2.png) [@James.Lorenz](https://forum.inductiveautomation.com/u/James.Lorenz)\ **Post date:** [June 25, 2012, 9:30pm UTC](https://forum.inductiveautomation.com/t/cant-delete-database-connection/4702/2 "2012-06-25T21:30:23Z")
Can you post the full stack trace for that error? ---
**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:** [June 25, 2012, 11:37pm UTC](https://forum.inductiveautomation.com/t/cant-delete-database-connection/4702/3 "2012-06-25T23:37:31Z")
You’ve got an MES/OEE module installed that is depending on this DB connection it seems… ---
**Author:** ![AndyK76](https://avatars.discourse-cdn.com/v4/letter/a/edb3f5/32.png) [@AndyK76](https://forum.inductiveautomation.com/u/AndyK76)\ **Post date:** [June 26, 2012, 12:03pm UTC](https://forum.inductiveautomation.com/t/cant-delete-database-connection/4702/4 "2012-06-26T12:03:53Z")
[b]Ok. The problem is that I do not have any OEE/MES modules installed anymore (I did about a year ago, but they are not installed now). This is the message in the Console Log:[/b] com.inductiveautomation.ignition.gateway.web.components.actions.DeleteRecordAction Error deleting Database Connection “LakewoodDatabaseTest” simpleorm.utils.SException$Jdbc: Executing DELETE FROM DATASOURCES WHERE DATASOURCES\_ID = ? for [DatasourceRecord 0 Deleted Dirty0] 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 com.inductiveautomation.ignition.gateway.redundancy.RedundantPersistenceInterfaceImpl$RedundantSession.doCommit(RedundantPersistenceInterfaceImpl.java:168) at com.inductiveautomation.ignition.gateway.redundancy.RedundantPersistenceInterfaceImpl$RedundantSession.commitAndDetachDataSet(RedundantPersistenceInterfaceImpl.java:155) at com.inductiveautomation.ignition.gateway.web.components.actions.DeleteRecordAction.doDelete(DeleteRecordAction.java:69) at com.inductiveautomation.ignition.gateway.web.components.actions.DeleteRecordAction.execute(DeleteRecordAction.java:148) at com.inductiveautomation.ignition.gateway.web.components.ConfirmationPanel$1.onClick(ConfirmationPanel.java:42) at org.apache.wicket.markup.html.link.Link.onLinkClicked(Link.java:224) at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:182) at org.apache.wicket.request.target.component.listener.ListenerInterfaceRequestTarget.processEvents(ListenerInterfaceRequestTarget.java:73) at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92) at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1250) at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329) at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1428) at org.apache.wicket.RequestCycle.request(RequestCycle.java:545) at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:479) at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:312) 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:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; FK\_PRODUCTIONSETTINGS\_LOCALDATASOURCE table: PRODUCTIONSETTINGS at org.hsqldb.jdbc.Util.sqlException(Util.java:298) at org.hsqldb.jdbc.Util.sqlException(Util.java:227) at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStatement.java:4638) at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(JDBCPreparedStatement.java:309) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at com.inductiveautomation.ignition.gateway.localdb.hsql.DelegatingDataSource$DelegatingConnection$DelegatingPreparedStatement.executeUpdate(DelegatingDataSource.java:548) at simpleorm.sessionjdbc.SSessionJdbcHelper.flushExecuteUpdate(SSessionJdbcHelper.java:407) … 33 more Caused by: org.hsqldb.HsqlException: integrity constraint violation: foreign key no action; FK\_PRODUCTIONSETTINGS\_LOCALDATASOURCE table: PRODUCTIONSETTINGS at org.hsqldb.error.Error.error(Error.java:134) at org.hsqldb.StatementDML.performReferentialActions(StatementDML.java:1477) at org.hsqldb.StatementDML.delete(StatementDML.java:1148) at org.hsqldb.StatementDML.executeDeleteStatement(StatementDML.java:1095) at org.hsqldb.StatementDML.getResult(StatementDML.java:207) at org.hsqldb.StatementDMQL.execute(StatementDMQL.java:190) at org.hsqldb.Session.executeCompiledStatement(Session.java:1339) at org.hsqldb.Session.execute(Session.java:986) at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStatement.java:4630) … 37 more ---
**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:** [June 26, 2012, 6:30pm UTC](https://forum.inductiveautomation.com/t/cant-delete-database-connection/4702/5 "2012-06-26T18:30:13Z")
The important part of that trace is this line:`Caused by: org.hsqldb.HsqlException: integrity constraint violation: foreign key no action; FK_PRODUCTIONSETTINGS_LOCALDATASOURCE table: PRODUCTIONSETTINGS`This means that there is something left over from the OEE module. If you can get an internet connection for gotomeeting and give support a call, we can look into the raw settings and help you fix this. ---
**Author:** ![durgesh](https://avatars.discourse-cdn.com/v4/letter/d/eb9ed0/32.png) [@durgesh](https://forum.inductiveautomation.com/u/durgesh)\ **Post date:** [October 22, 2018, 11:13am UTC](https://forum.inductiveautomation.com/t/cant-delete-database-connection/4702/6 "2018-10-22T11:13:46Z")
Go to -\> configure -\> MES modules -\> Settings -\> set runtime DB and analysis DB name to none. No try to delete the DB it works.