com.microsoft.sqlserver.jdbc.SQLServerException

The DELETE statement conflicted with the REFERENCE constraint "xccntextdpudpnstanceid". The conflict occurred in database "uv", table "dbo.exec_context_dpu", column 'dpu_instance_id'.


Solutions on the web1275

Solution icon of github
via GitHub by tomas-knap
, 7 months ago
The DELETE statement conflicted with the REFERENCE constraint "xccntextdpudpnstanceid". The conflict occurred in database "uv", table "dbo.exec_context_dpu", column 'dpu_instance_id'.

Solution icon of googlegroups
via Google Groups by Masimo, 1 month ago
The DELETE statement conflicted with the REFERENCE constraint "repository_object_object_permission". The conflict occurred in database "PARS_METADATA", table "repository.object_permission", column 'object_id'.

Solution icon of sourceforge
The DELETE statement conflicted with the REFERENCE constraint "FK__duplicate__finge__0F975522". The conflict occurred in database "dump3", table "dbo.duplicate", column 'fingerprintid1'.

Solution icon of stackoverflow
The DELETE statement conflicted with the REFERENCE constraint "FK_ItemContainer_Item". The conflict occurred in database "MyDatabase2", table "dbo.ItemContainer", column 'itemId'.

Solution icon of web
The DELETE statement conflicted with the REFERENCE constraint "CLLNAVAILIABLEPRDUCTid". The conflict occurred in database "ecommerce", table "dbo.CALLONAVAILIABLE", column 'PRODUCT_id'.

Solution icon of atlassian
via Atlassian JIRA by Bryan Turner, 1 year ago
The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "fk_sta_comment_parent". The conflict occurred in database "stashlhr10", table "dbo.sta_comment", column 'parent_id'.

Solution icon of atlassian
via Atlassian JIRA by Bryan Turner, 1 year ago
The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "fk_sta_comment_parent". The conflict occurred in database "stashlhr10", table "dbo.sta_comment", column 'parent_id'.

Solution icon of web
The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "fk_sta_comment_parent". The conflict occurred in database "stashlhr10", table "dbo.sta_comment", column 'parent_id'.

Solution icon of web
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_CFG_SET_ORG_ID". The conflict occurred in database "HOMEPAGE", table "HOMEPAGE.MT_ORGANIZATION", column 'ORGANIZATION_ID'.

Solution icon of stackoverflow
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_CHILDREN_REFERENCE_PARENT". The conflict occurred in database "db", table "dbo.PARENT", column 'ID'.

Stack trace

  • com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "xccntextdpudpnstanceid". The conflict occurred in database "uv", table "dbo.exec_context_dpu", column 'dpu_instance_id'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)[sqljdbc4.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)[sqljdbc4.jar:na] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)[commons-dbcp-1.4.jar:1.4] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:890)[classes/:na] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962)[classes/:na] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:631)[classes/:na] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)[classes/:na] at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)[classes/:na] at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298)[classes/:na] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)[classes/:na] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)[classes/:na] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.deleteObject(DatasourceCallQueryMechanism.java:210)[classes/:na] at org.eclipse.persistence.internal.queries.StatementQueryMechanism.deleteObject(StatementQueryMechanism.java:104)[classes/:na] at org.eclipse.persistence.queries.DeleteObjectQuery.executeDatabaseQuery(DeleteObjectQuery.java:218)[classes/:na] at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)[classes/:na] at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:798)[classes/:na] at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)[classes/:na] at org.eclipse.persistence.queries.DeleteObjectQuery.executeInUnitOfWorkObjectLevelModifyQuery(DeleteObjectQuery.java:119)[classes/:na] at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)[classes/:na] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)[classes/:na] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)[classes/:na] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)[classes/:na] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1737)[classes/:na] at org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:336)[classes/:na] at org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:290)[classes/:na] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1444)[classes/:na] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1531)[classes/:na] at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:277)[classes/:na] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1169)[classes/:na] at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:132)[org.eclipse.persistence.jpa-2.5.2.jar:na] at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:512)[spring-orm-3.1.4.RELEASE.jar:3.1.4.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)[spring-tx-3.1.4.RELEASE.jar:3.1.4.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)[spring-tx-3.1.4.RELEASE.jar:3.1.4.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:387)[spring-tx-3.1.4.RELEASE.jar:3.1.4.RELEASE] at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$afterReturning$org_springframework_transaction_aspectj_AbstractTransactionAspect$3$2a73e96c(AbstractTransactionAspect.aj:78)[spring-aspects-3.1.4.RELEASE.jar:3.1.4.RELEASE] at cz.cuni.mff.xrg.odcs.commons.app.facade.DPUFacadeImpl.delete(DPUFacadeImpl.java:252)[classes/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_21] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_21] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_21] at java.lang.reflect.Method.invoke(Method.java:601)[na:1.7.0_21] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)[spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)[spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE] at com.sun.proxy.$Proxy44.delete(Unknown Source)[$Proxy44.class:na] at cz.cuni.mff.xrg.odcs.frontend.gui.components.pipelinecanvas.PipelineCanvas.afterSaveCleanUp(PipelineCanvas.java:225)[classes/:na] at cz.cuni.mff.xrg.odcs.frontend.gui.views.PipelineEdit.finishSavePipeline(PipelineEdit.java:1373)[classes/:na] at cz.cuni.mff.xrg.odcs.frontend.gui.views.PipelineEdit.savePipeline(PipelineEdit.java:1348)[classes/:na] at cz.cuni.mff.xrg.odcs.frontend.gui.views.PipelineEdit$18.buttonClick(PipelineEdit.java:652)[classes/:na] at sun.reflect.GeneratedMethodAccessor133.invoke(Unknown Source)[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_21] at java.lang.reflect.Method.invoke(Method.java:601)[na:1.7.0_21] at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:508)[vaadin-server-7.3.7.jar:7.3.7] at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:198)[vaadin-server-7.3.7.jar:7.3.7] at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:161)[vaadin-server-7.3.7.jar:7.3.7] at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:979)[vaadin-server-7.3.7.jar:7.3.7] at com.vaadin.ui.Button.fireClick(Button.java:393)[vaadin-server-7.3.7.jar:7.3.7] at com.vaadin.ui.Button$1.click(Button.java:57)[vaadin-server-7.3.7.jar:7.3.7] at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source)[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_21] at java.lang.reflect.Method.invoke(Method.java:601)[na:1.7.0_21] at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:168)[vaadin-server-7.3.7.jar:7.3.7] at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:118)[vaadin-server-7.3.7.jar:7.3.7] at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:287)[vaadin-server-7.3.7.jar:7.3.7] at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:180)[vaadin-server-7.3.7.jar:7.3.7] at com.vaadin.server.communication.UidlRequestHandler.synchronizedHandleRequest(UidlRequestHandler.java:93)[vaadin-server-7.3.7.jar:7.3.7] at com.vaadin.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:41)[vaadin-server-7.3.7.jar:7.3.7] at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1406)[vaadin-server-7.3.7.jar:7.3.7] at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:305)[vaadin-server-7.3.7.jar:7.3.7] at cz.cuni.mff.xrg.odcs.frontend.ODCSApplicationServlet.service(ODCSApplicationServlet.java:98)[classes/:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)[servlet-api.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)[catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)[catalina.jar:7.0.39] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)[catalina.jar:7.0.39] at org.apache.catalina.core.StandardContextValve.__invoke(StandardContextValve.java:123)[catalina.jar:7.0.39] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java)[catalina.jar:7.0.39] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)[catalina.jar:7.0.39] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)[catalina.jar:7.0.39] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)[catalina.jar:7.0.39] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:947)[catalina.jar:7.0.39] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)[catalina.jar:7.0.39] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)[catalina.jar:7.0.39] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1009)[tomcat-coyote.jar:7.0.39] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)[tomcat-coyote.jar:7.0.39] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)[tomcat-coyote.jar:7.0.39] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)[na:1.7.0_21] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[na:1.7.0_21] at java.lang.Thread.run(Thread.java:722)[na:1.7.0_21]

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

2667 times, 11 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
14 times, 3 weeks ago
83 more bugmates