[
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:29 PM:
------------------------------------------------------------------
Thanks [~jleroux] for you quick reply
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}
Let me repeat here once again. The above error is only because in the Link
Party Feature code is removing PartyRole without remove PartyRelationship.
Might be you did with some other user who does not have PartyRelationship
records corresponding to PartyRole and maybe because of that you didn't see any
errors.
was (Author: rohit.koushal):
Thanks [~jleroux] for you quick reply
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}
Let me repeat here once again. The above error is only because in the Link
Party Feature the code is removing PartyRole without remove PartyRelationship.
Might be you did with some other user which does not have PartyRelationship
records corresponding to PartyRole and may be because of that you didn't see
any errors.
> 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)
