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!
Can you post the full stack trace for that error?
You’ve got an MES/OEE module installed that is depending on this DB connection it seems…
[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
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: PRODUCTIONSETTINGSThis 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.
Go to -> configure -> MES modules -> Settings -> set runtime DB and analysis DB name to none.
No try to delete the DB it works.