[
https://issues.apache.org/jira/browse/OFBIZ-12424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17451757#comment-17451757
]
Rohit Koushal commented on OFBIZ-12424:
---------------------------------------
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*_+
{noformat}
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 {noformat}
> 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)
