[ https://issues.apache.org/jira/browse/OFBIZ-12424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17451757#comment-17451757 ]
Rohit Koushal edited comment on OFBIZ-12424 at 12/1/21, 12:10 PM: ------------------------------------------------------------------ I just give it a try [trunk instance|https://demo-trunk.ofbiz.apache.org/] and I am seeing the same problem that you report for the user with partyId {*}DemoLead1{*}. Please refer to the below screenshot for your easy reference. !image-2021-12-01-17-18-37-279.png|width=625,height=185! !image-2021-12-01-17-20-21-196.png|width=624,height=287! +_*complete log*_+ {code:java} 2021-12-01 11:38:55,666 |27.0.0.1-8009-exec-2 |ControlServlet |T| [[[partymgr::setPartyLink (Domain:https://demo-trunk.ofbiz.apache.org)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]2021-12-01 11:38:55,720 |27.0.0.1-8009-exec-2 |ConfigXMLReader |I| controller loaded: 0.0s, 0 requests, 0 views in file:/home/ofbizDemo/trunk/framework/common/webcommon/WEB-INF/handlers-controller.xml2021-12-01 11:38:55,720 |27.0.0.1-8009-exec-2 |ConfigXMLReader |I| controller loaded: 0.025s, 52 requests, 21 views in file:/home/ofbizDemo/trunk/framework/common/webcommon/WEB-INF/common-controller.xml2021-12-01 11:38:55,733 |27.0.0.1-8009-exec-2 |ConfigXMLReader |I| controller loaded: 0.0s, 30 requests, 13 views in file:/home/ofbizDemo/trunk/framework/common/webcommon/WEB-INF/security-controller.xml2021-12-01 11:38:55,746 |27.0.0.1-8009-exec-2 |ConfigXMLReader |I| controller loaded: 0.0s, 4 requests, 0 views in file:/home/ofbizDemo/trunk/applications/commonext/webapp/WEB-INF/controller.xml2021-12-01 11:38:55,765 |27.0.0.1-8009-exec-2 |ConfigXMLReader |I| controller loaded: 0.003s, 347 requests, 133 views in file:/home/ofbizDemo/trunk/applications/content/webapp/content/WEB-INF/controller.xml2021-12-01 11:38:55,768 |27.0.0.1-8009-exec-2 |ConfigXMLReader |I| controller loaded: 0.086s, 268 requests, 110 views in file:/home/ofbizDemo/trunk/applications/party/webapp/partymgr/WEB-INF/controller.xml2021-12-01 11:38:55,884 |27.0.0.1-8009-exec-2 |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:java.lang.Exception: rollback called in Entity Engine SQLProcessorat org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:372) [main/:?]at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:198) [main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1347) [main/:?]at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189) [main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150) [main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1115) [main/:?]at org.apache.ofbiz.party.party.PartyServices.linkParty(PartyServices.java:2131) [main/:?]at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292]at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_292]at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292]at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) [main/:?]at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [main/:?]at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:424) [main/:?]at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) [main/:?]at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:93) [main/:?]at org.apache.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:253) [main/:?]at org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:1026) [main/:?]at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:677) [main/:?]at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:231) [main/:?]at org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:81) [main/:?]at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.41.jar:9.0.41]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) [main/:?]at javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:57) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.14.1.jar:2.14.1]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.54.jar:9.0.54]at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]2021-12-01 11:38:55,885 |27.0.0.1-8009-exec-2 |GenericDelegator |E| Failure in removeByCondition operation for entity [PartyRole]: org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.)). Rolling back transaction.org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.))at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1348) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189) ~[main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150) [main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1115) [main/:?]at org.apache.ofbiz.party.party.PartyServices.linkParty(PartyServices.java:2131) [main/:?]at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292]at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_292]at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292]at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) [main/:?]at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [main/:?]at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:424) [main/:?]at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) [main/:?]at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:93) [main/:?]at org.apache.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:253) [main/:?]at org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:1026) [main/:?]at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:677) [main/:?]at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:231) [main/:?]at org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:81) [main/:?]at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.41.jar:9.0.41]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) [main/:?]at javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:57) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.14.1.jar:2.14.1]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.54.jar:9.0.54]at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.)at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:443) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1377) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1345) ~[main/:?]... 52 moreCaused by: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:438) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1377) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1345) ~[main/:?]... 52 moreCaused by: org.apache.derby.iapi.error.StandardException: DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.ReferencedKeyRIChecker.doCheck(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.RISetChecker.doPKCheck(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.DeleteResultSet.open(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:438) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1377) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1345) ~[main/:?]... 52 more2021-12-01 11:38:55,889 |27.0.0.1-8009-exec-2 |TransactionUtil |I| Transaction rolled back2021-12-01 11:38:55,889 |27.0.0.1-8009-exec-2 |PartyServices |W| nullorg.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.)) (Generic Entity Exception occurred in deleteByCondition (SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.)))at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1167) ~[main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1115) ~[main/:?]at org.apache.ofbiz.party.party.PartyServices.linkParty(PartyServices.java:2131) [main/:?]at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292]at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_292]at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292]at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) [main/:?]at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [main/:?]at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:424) [main/:?]at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) [main/:?]at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:93) [main/:?]at org.apache.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:253) [main/:?]at org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:1026) [main/:?]at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:677) [main/:?]at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:231) [main/:?]at org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:81) [main/:?]at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.41.jar:9.0.41]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) [main/:?]at javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:57) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.14.1.jar:2.14.1]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.54.jar:9.0.54]at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]Caused by: org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.))at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1348) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189) ~[main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150) ~[main/:?]... 50 moreCaused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.)at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:443) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1377) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1345) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189) ~[main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150) ~[main/:?]... 50 moreCaused by: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:438) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1377) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1345) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189) ~[main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150) ~[main/:?]... 50 moreCaused by: org.apache.derby.iapi.error.StandardException: DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.ReferencedKeyRIChecker.doCheck(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.RISetChecker.doPKCheck(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.DeleteResultSet.open(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:438) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1377) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1345) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189) ~[main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150) ~[main/:?]... 50 more2021-12-01 11:38:55,912 |27.0.0.1-8009-exec-2 |ServiceDispatcher |T| Sync service [partymgr/linkPartyRecord] finished in [140] milliseconds2021-12-01 11:38:55,912 |27.0.0.1-8009-exec-2 |RequestHandler |I| Ran Event [service:#linkPartyRecord] from [request], result is [success]2021-12-01 11:38:55,914 |27.0.0.1-8009-exec-2 |RequestHandler |I| Sending redirect to: [https://demo-trunk.ofbiz.apache.org:443/partymgr/control/viewprofile?partyId=DemoLead2]. Hidden sessionId by default.2021-12-01 11:38:55,916 |27.0.0.1-8009-exec-2 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default{code} was (Author: rohit.koushal): I just give it a try [trunk instance|https://demo-trunk.ofbiz.apache.org/] and I am seeing the same problem that you report for the user with partyId {*}DemoLead1{*}. Please refer to the below screenshot for your easy reference. !image-2021-12-01-17-18-37-279.png|width=625,height=185! !image-2021-12-01-17-20-21-196.png|width=624,height=287! +_*complete log*_+ {code:java} 2021-12-01 11:38:55,666 |27.0.0.1-8009-exec-2 |ControlServlet |T| [[[partymgr::setPartyLink (Domain:https://demo-trunk.ofbiz.apache.org)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]2021-12-01 11:38:55,720 |27.0.0.1-8009-exec-2 |ConfigXMLReader |I| controller loaded: 0.0s, 0 requests, 0 views in file:/home/ofbizDemo/trunk/framework/common/webcommon/WEB-INF/handlers-controller.xml2021-12-01 11:38:55,720 |27.0.0.1-8009-exec-2 |ConfigXMLReader |I| controller loaded: 0.025s, 52 requests, 21 views in file:/home/ofbizDemo/trunk/framework/common/webcommon/WEB-INF/common-controller.xml2021-12-01 11:38:55,733 |27.0.0.1-8009-exec-2 |ConfigXMLReader |I| controller loaded: 0.0s, 30 requests, 13 views in file:/home/ofbizDemo/trunk/framework/common/webcommon/WEB-INF/security-controller.xml2021-12-01 11:38:55,746 |27.0.0.1-8009-exec-2 |ConfigXMLReader |I| controller loaded: 0.0s, 4 requests, 0 views in file:/home/ofbizDemo/trunk/applications/commonext/webapp/WEB-INF/controller.xml2021-12-01 11:38:55,765 |27.0.0.1-8009-exec-2 |ConfigXMLReader |I| controller loaded: 0.003s, 347 requests, 133 views in file:/home/ofbizDemo/trunk/applications/content/webapp/content/WEB-INF/controller.xml2021-12-01 11:38:55,768 |27.0.0.1-8009-exec-2 |ConfigXMLReader |I| controller loaded: 0.086s, 268 requests, 110 views in file:/home/ofbizDemo/trunk/applications/party/webapp/partymgr/WEB-INF/controller.xml2021-12-01 11:38:55,884 |27.0.0.1-8009-exec-2 |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:java.lang.Exception: rollback called in Entity Engine SQLProcessorat org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:372) [main/:?]at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:198) [main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1347) [main/:?]at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189) [main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150) [main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1115) [main/:?]at org.apache.ofbiz.party.party.PartyServices.linkParty(PartyServices.java:2131) [main/:?]at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292]at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_292]at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292]at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) [main/:?]at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [main/:?]at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:424) [main/:?]at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) [main/:?]at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:93) [main/:?]at org.apache.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:253) [main/:?]at org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:1026) [main/:?]at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:677) [main/:?]at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:231) [main/:?]at org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:81) [main/:?]at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.41.jar:9.0.41]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) [main/:?]at javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:57) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.14.1.jar:2.14.1]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.54.jar:9.0.54]at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]2021-12-01 11:38:55,885 |27.0.0.1-8009-exec-2 |GenericDelegator |E| Failure in removeByCondition operation for entity [PartyRole]: org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.)). Rolling back transaction.org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.))at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1348) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189) ~[main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150) [main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1115) [main/:?]at org.apache.ofbiz.party.party.PartyServices.linkParty(PartyServices.java:2131) [main/:?]at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292]at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_292]at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292]at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) [main/:?]at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [main/:?]at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:424) [main/:?]at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) [main/:?]at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:93) [main/:?]at org.apache.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:253) [main/:?]at org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:1026) [main/:?]at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:677) [main/:?]at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:231) [main/:?]at org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:81) [main/:?]at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.41.jar:9.0.41]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) [main/:?]at javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:57) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.14.1.jar:2.14.1]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.54.jar:9.0.54]at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.)at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:443) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1377) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1345) ~[main/:?]... 52 moreCaused by: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:438) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1377) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1345) ~[main/:?]... 52 moreCaused by: org.apache.derby.iapi.error.StandardException: DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.ReferencedKeyRIChecker.doCheck(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.RISetChecker.doPKCheck(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.DeleteResultSet.open(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:438) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1377) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1345) ~[main/:?]... 52 more2021-12-01 11:38:55,889 |27.0.0.1-8009-exec-2 |TransactionUtil |I| Transaction rolled back2021-12-01 11:38:55,889 |27.0.0.1-8009-exec-2 |PartyServices |W| nullorg.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.)) (Generic Entity Exception occurred in deleteByCondition (SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.)))at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1167) ~[main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1115) ~[main/:?]at org.apache.ofbiz.party.party.PartyServices.linkParty(PartyServices.java:2131) [main/:?]at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292]at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_292]at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292]at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) [main/:?]at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [main/:?]at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:424) [main/:?]at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240) [main/:?]at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:93) [main/:?]at org.apache.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:253) [main/:?]at org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:1026) [main/:?]at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:677) [main/:?]at org.apache.ofbiz.webapp.control.ControlServlet.handle(ControlServlet.java:231) [main/:?]at org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:81) [main/:?]at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.41.jar:9.0.41]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:185) [main/:?]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) [main/:?]at javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:57) [tomcat-servlet-api-9.0.54.jar:4.0.FR]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.14.1.jar:2.14.1]at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat-catalina-9.0.54.jar:9.0.54]at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util-9.0.54.jar:9.0.54]at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.54.jar:9.0.54]at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]Caused by: org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.))at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1348) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189) ~[main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150) ~[main/:?]... 50 moreCaused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:null (DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.)at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:443) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1377) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1345) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189) ~[main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150) ~[main/:?]... 50 moreCaused by: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:438) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1377) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1345) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189) ~[main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150) ~[main/:?]... 50 moreCaused by: org.apache.derby.iapi.error.StandardException: DELETE on table 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_REL_TPROLE' for key (DemoLead1,LEAD). The statement has been rolled back.at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.ReferencedKeyRIChecker.doCheck(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.RISetChecker.doPKCheck(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.execute.DeleteResultSet.open(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.9.0.jar:2.9.0]at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:438) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1377) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1345) ~[main/:?]at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189) ~[main/:?]at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150) ~[main/:?]... 50 more2021-12-01 11:38:55,912 |27.0.0.1-8009-exec-2 |ServiceDispatcher |T| Sync service [partymgr/linkPartyRecord] finished in [140] milliseconds2021-12-01 11:38:55,912 |27.0.0.1-8009-exec-2 |RequestHandler |I| Ran Event [service:#linkPartyRecord] from [request], result is [success]2021-12-01 11:38:55,914 |27.0.0.1-8009-exec-2 |RequestHandler |I| Sending redirect to: [https://demo-trunk.ofbiz.apache.org:443/partymgr/control/viewprofile?partyId=DemoLead2]. Hidden sessionId by default.2021-12-01 11:38:55,916 |27.0.0.1-8009-exec-2 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default {code} > Link Party feature stop the EECA rules globally > ----------------------------------------------- > > Key: OFBIZ-12424 > URL: https://issues.apache.org/jira/browse/OFBIZ-12424 > Project: OFBiz > Issue Type: Bug > Affects Versions: Release Branch 18.12, Release Branch 17.12, Trunk > Reporter: Rohit Koushal > Assignee: Rohit Koushal > Priority: Major > Attachments: image-2021-12-01-17-18-37-279.png, > image-2021-12-01-17-20-21-196.png > > > In the Link Party Feature({_}*partymgr > profile > Link Party*{_}) there is a > code that stops EECA rules globally in the system and as a result it caused > major issues in the process which are driven from EECA's. > > *PartyServices.java* > {code:java} > public static Map<String, Object> linkParty(DispatchContext dctx, Map<String, > ? extends Object> context) { > Delegator delegator = dctx.getDelegator(); > Locale locale = (Locale) context.get("locale"); > delegator.setEntityEcaHandler(null); > . > . > . > } {code} > > In the above code you can see that we are updating EntityEcaHandler on > delegator object to null. > > *GenericDelegator.java* > {code:java} > protected void evalRules(String event, String currentOperation, GenericEntity > value, boolean isError) throws GenericEntityException { > if (entityEcaHandler == null) { > return; > } > entityEcaHandler.evalRules(currentOperation, eventMap, event, value, > isError); > } {code} > On any DB operation(find, create and store) using delegator above method run > and due to null EntityEcaHandler object it won't execute any EECA's globally > in the system > > > -- This message was sent by Atlassian Jira (v8.20.1#820001)