[
https://issues.apache.org/jira/browse/OFBIZ-12424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17451630#comment-17451630
]
Jacques Le Roux commented on OFBIZ-12424:
-----------------------------------------
Hi Rohit,
After applyting locally and a cleanData loadAll this is what I get:
{noformat}
2021-12-01 09:56:29,754 |jsse-nio-8443-exec-3 |ControlServlet
|T| [[[partymgr::setPartyLink (Domain:https://localhost)] Request Begun,
encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2021-12-01 09:56:29,760 |delegator-startup-9 |DelegatorFactoryImpl
|I| Creating new delegator [default-no-eca] (delegator-startup-9)
2021-12-01 09:56:29,760 |delegator-startup-9 |GenericDelegator
|I| Doing entity definition check...
2021-12-01 09:56:29,760 |delegator-startup-9 |ModelEntityChecker
|I| [initReservedWords] array length = 1025
2021-12-01 09:56:29,787 |OFBiz-batch-5 |GenericDelegator
|I| Delegator "default-no-eca" initializing helper "localderbyolap" for entity
group "org.apache.ofbiz.olap".
2021-12-01 09:56:29,787 |OFBiz-batch-5 |GenericDelegator
|I| Doing database check as requested in entityengine.xml with addMissing=true
2021-12-01 09:56:29,788 |OFBiz-batch-6 |GenericDelegator
|I| Delegator "default-no-eca" initializing helper "localderby" for entity
group "org.apache.ofbiz".
2021-12-01 09:56:29,788 |OFBiz-batch-6 |GenericDelegator
|I| Doing database check as requested in entityengine.xml with addMissing=true
2021-12-01 09:56:29,789 |OFBiz-batch-6 |DatabaseUtil
|I| Database Product Name is Apache Derby
2021-12-01 09:56:29,789 |OFBiz-batch-6 |DatabaseUtil
|I| Database Product Version is 10.14.2.0 - (1828579)
2021-12-01 09:56:29,789 |OFBiz-batch-6 |DatabaseUtil
|I| Database Driver Name is Apache Derby Embedded JDBC Driver
2021-12-01 09:56:29,789 |OFBiz-batch-6 |DatabaseUtil
|I| Database Driver Version is 10.14.2.0 - (1828579)
2021-12-01 09:56:29,789 |OFBiz-batch-6 |DatabaseUtil
|I| Database Driver JDBC Version is 4.2
2021-12-01 09:56:29,789 |OFBiz-batch-6 |DatabaseUtil
|I| Database Setting/Support Information (those with a * should be true):
2021-12-01 09:56:29,789 |OFBiz-batch-6 |DatabaseUtil
|I| - supports transactions [true]*
2021-12-01 09:56:29,789 |OFBiz-batch-6 |DatabaseUtil
|I| - isolation None [false]
2021-12-01 09:56:29,789 |OFBiz-batch-6 |DatabaseUtil
|I| - isolation ReadCommitted [true]
2021-12-01 09:56:29,789 |OFBiz-batch-6 |DatabaseUtil
|I| - isolation ReadUncommitted [true]
2021-12-01 09:56:29,789 |OFBiz-batch-6 |DatabaseUtil
|I| - isolation RepeatableRead [true]
2021-12-01 09:56:29,789 |OFBiz-batch-6 |DatabaseUtil
|I| - isolation Serializable [true]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - forward only type [true]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - scroll sensitive type [false]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - scroll insensitive type [true]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - is case sensitive [false]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - stores LowerCase [false]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - stores MixedCase [false]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - stores UpperCase [true]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - max table name length [128]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - max column name length [128]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - concurrent connections [0]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - concurrent statements [0]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - ANSI SQL92 Entry [true]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - ANSI SQL92 Intermediate [false]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - ANSI SQL92 Full [false]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - ODBC SQL Grammar Core [false]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - ODBC SQL Grammar Extended [false]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - ODBC SQL Grammar Minimum [true]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - outer joins [true]*
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - limited outer joins [true]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - full outer joins [false]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - group by [true]*
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - group by not in select [true]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - column aliasing [true]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - order by not in select [false]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - alter table add column [true]*
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - non-nullable column [true]*
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - default fetchsize [1]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| - named parameters [ SKIPPED ]
2021-12-01 09:56:29,790 |OFBiz-batch-6 |DatabaseUtil
|I| Getting Table Info From Database
2021-12-01 09:56:29,795 |OFBiz-batch-7 |GenericDelegator
|I| Delegator "default-no-eca" initializing helper "localderbytenant" for
entity group "org.apache.ofbiz.tenant".
2021-12-01 09:56:29,795 |OFBiz-batch-7 |GenericDelegator
|I| Doing database check as requested in entityengine.xml with addMissing=true
2021-12-01 09:56:29,796 |OFBiz-batch-5 |DatabaseUtil
|I| Database Product Name is Apache Derby
2021-12-01 09:56:29,796 |OFBiz-batch-5 |DatabaseUtil
|I| Database Product Version is 10.14.2.0 - (1828579)
2021-12-01 09:56:29,796 |OFBiz-batch-5 |DatabaseUtil
|I| Database Driver Name is Apache Derby Embedded JDBC Driver
2021-12-01 09:56:29,796 |OFBiz-batch-5 |DatabaseUtil
|I| Database Driver Version is 10.14.2.0 - (1828579)
2021-12-01 09:56:29,796 |OFBiz-batch-5 |DatabaseUtil
|I| Database Driver JDBC Version is 4.2
2021-12-01 09:56:29,796 |OFBiz-batch-5 |DatabaseUtil
|I| Database Setting/Support Information (those with a * should be true):
2021-12-01 09:56:29,796 |OFBiz-batch-5 |DatabaseUtil
|I| - supports transactions [true]*
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - isolation None [false]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - isolation ReadCommitted [true]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - isolation ReadUncommitted [true]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - isolation RepeatableRead [true]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - isolation Serializable [true]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - forward only type [true]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - scroll sensitive type [false]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - scroll insensitive type [true]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - is case sensitive [false]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - stores LowerCase [false]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - stores MixedCase [false]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - stores UpperCase [true]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - max table name length [128]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - max column name length [128]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - concurrent connections [0]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - concurrent statements [0]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - ANSI SQL92 Entry [true]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - ANSI SQL92 Intermediate [false]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - ANSI SQL92 Full [false]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - ODBC SQL Grammar Core [false]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - ODBC SQL Grammar Extended [false]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - ODBC SQL Grammar Minimum [true]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - outer joins [true]*
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - limited outer joins [true]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - full outer joins [false]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - group by [true]*
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - group by not in select [true]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - column aliasing [true]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - order by not in select [false]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - alter table add column [true]*
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - non-nullable column [true]*
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - default fetchsize [1]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| - named parameters [ SKIPPED ]
2021-12-01 09:56:29,798 |OFBiz-batch-5 |DatabaseUtil
|I| Getting Table Info From Database
2021-12-01 09:56:29,796 |OFBiz-batch-7 |DatabaseUtil
|I| Database Product Name is Apache Derby
2021-12-01 09:56:29,799 |OFBiz-batch-7 |DatabaseUtil
|I| Database Product Version is 10.14.2.0 - (1828579)
2021-12-01 09:56:29,799 |OFBiz-batch-7 |DatabaseUtil
|I| Database Driver Name is Apache Derby Embedded JDBC Driver
2021-12-01 09:56:29,799 |OFBiz-batch-7 |DatabaseUtil
|I| Database Driver Version is 10.14.2.0 - (1828579)
2021-12-01 09:56:29,799 |OFBiz-batch-7 |DatabaseUtil
|I| Database Driver JDBC Version is 4.2
2021-12-01 09:56:29,799 |OFBiz-batch-7 |DatabaseUtil
|I| Database Setting/Support Information (those with a * should be true):
2021-12-01 09:56:29,799 |OFBiz-batch-7 |DatabaseUtil
|I| - supports transactions [true]*
2021-12-01 09:56:29,803 |OFBiz-batch-7 |DatabaseUtil
|I| - isolation None [false]
2021-12-01 09:56:29,803 |OFBiz-batch-7 |DatabaseUtil
|I| - isolation ReadCommitted [true]
2021-12-01 09:56:29,803 |OFBiz-batch-7 |DatabaseUtil
|I| - isolation ReadUncommitted [true]
2021-12-01 09:56:29,803 |OFBiz-batch-7 |DatabaseUtil
|I| - isolation RepeatableRead [true]
2021-12-01 09:56:29,803 |OFBiz-batch-7 |DatabaseUtil
|I| - isolation Serializable [true]
2021-12-01 09:56:29,803 |OFBiz-batch-7 |DatabaseUtil
|I| - forward only type [true]
2021-12-01 09:56:29,803 |OFBiz-batch-7 |DatabaseUtil
|I| - scroll sensitive type [false]
2021-12-01 09:56:29,803 |OFBiz-batch-7 |DatabaseUtil
|I| - scroll insensitive type [true]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - is case sensitive [false]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - stores LowerCase [false]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - stores MixedCase [false]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - stores UpperCase [true]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - max table name length [128]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - max column name length [128]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - concurrent connections [0]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - concurrent statements [0]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - ANSI SQL92 Entry [true]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - ANSI SQL92 Intermediate [false]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - ANSI SQL92 Full [false]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - ODBC SQL Grammar Core [false]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - ODBC SQL Grammar Extended [false]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - ODBC SQL Grammar Minimum [true]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - outer joins [true]*
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - limited outer joins [true]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - full outer joins [false]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - group by [true]*
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - group by not in select [true]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - column aliasing [true]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - order by not in select [false]
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - alter table add column [true]*
2021-12-01 09:56:29,805 |OFBiz-batch-7 |DatabaseUtil
|I| - non-nullable column [true]*
2021-12-01 09:56:29,818 |OFBiz-batch-7 |DatabaseUtil
|I| - default fetchsize [1]
2021-12-01 09:56:29,818 |OFBiz-batch-7 |DatabaseUtil
|I| - named parameters [ SKIPPED ]
2021-12-01 09:56:29,818 |OFBiz-batch-7 |DatabaseUtil
|I| Getting Table Info From Database
2021-12-01 09:56:29,840 |OFBiz-batch-5 |DatabaseUtil
|I| Getting Column Info From Database
2021-12-01 09:56:29,856 |OFBiz-batch-6 |DatabaseUtil
|I| Getting Column Info From Database
2021-12-01 09:56:29,884 |OFBiz-batch-5 |DatabaseUtil
|I| Error getting primary key info from database with null tableName, will try
other means: java.sql.SQLException: Table name can not be null
2021-12-01 09:56:29,884 |OFBiz-batch-5 |DatabaseUtil
|I| Searching in 7 tables for primary key fields ...
2021-12-01 09:56:29,889 |OFBiz-batch-5 |DatabaseUtil
|I| Reviewed 9 primary key fields from database.
2021-12-01 09:56:29,897 |OFBiz-batch-7 |DatabaseUtil
|I| Getting Column Info From Database
2021-12-01 09:56:29,901 |OFBiz-batch-7 |DatabaseUtil
|I| Error getting primary key info from database with null tableName, will try
other means: java.sql.SQLException: Table name can not be null
2021-12-01 09:56:29,902 |OFBiz-batch-7 |DatabaseUtil
|I| Searching in 6 tables for primary key fields ...
2021-12-01 09:56:29,907 |OFBiz-batch-7 |DatabaseUtil
|I| Reviewed 8 primary key fields from database.
2021-12-01 09:56:30,067 |OFBiz-batch-6 |DatabaseUtil
|I| Error getting primary key info from database with null tableName, will try
other means: java.sql.SQLException: Table name can not be null
2021-12-01 09:56:30,068 |OFBiz-batch-6 |DatabaseUtil
|I| Searching in 866 tables for primary key fields ...
2021-12-01 09:56:30,305 |OFBiz-batch-6 |DatabaseUtil
|I| Reviewed 1689 primary key fields from database.
2021-12-01 09:56:30,321 |OFBiz-batch-6 |GenericDelegator
|I| Entity ECA Handler disabled for delegator [default-no-eca]
2021-12-01 09:56:30,775 |jsse-nio-8443-exec-3 |TransactionUtil
|W| Calling transaction setRollbackOnly; this stack trace shows where this is
happening:
java.lang.Exception: rollback called in Entity Engine SQLProcessor
at
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_202]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_202]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]
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.http11.Http11Processor.service(Http11Processor.java:382)
[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_202]
2021-12-01 09:56:30,776 |jsse-nio-8443-exec-3 |GenericDelegator
|E| Failure in removeByCondition operation for entity [PartyRole]:
org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
occurred in dele
teByCondition (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 'PART
Y_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_202]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_202]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]
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.http11.Http11Processor.service(Http11Processor.java:382)
[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_202]
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 more
Caused 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 more
Caused 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 more
2021-12-01 09:56:30,785 |jsse-nio-8443-exec-3 |TransactionUtil
|I| Transaction rolled back
2021-12-01 09:56:30,785 |jsse-nio-8443-exec-3 |PartyServices
|W| null
org.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' ca
used 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 (DEL
ETE 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_202]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_202]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]
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.http11.Http11Processor.service(Http11Processor.java:382)
[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_202]
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
const
raint '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 more
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/:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:189)
~[main/:?]
at
org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1150)
~[main/:?]
... 50 more
Caused 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 more
Caused 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 more
2021-12-01 09:56:30,843 |jsse-nio-8443-exec-3 |ServiceDispatcher
|T| Sync service [partymgr/linkPartyRecord] finished in [1085] milliseconds
2021-12-01 09:56:30,843 |jsse-nio-8443-exec-3 |RequestHandler
|I| Ran Event [service:#linkPartyRecord] from [request], result is [success]
2021-12-01 09:56:30,848 |jsse-nio-8443-exec-3 |RequestHandler
|I| Sending redirect to:
[https://localhost:8443/partymgr/control/viewprofile?partyId=DemoLead2].
Hidden sessionId by default.
2021-12-01 09:56:30,865 |jsse-nio-8443-exec-3 |ServerHitBin
|I| Visit delegatorName=default, ServerHitBin delegatorName=default
2021-12-01 09:56:30,892 |jsse-nio-8443-exec-3 |ControlServlet
|T| [[[partymgr::setPartyLink (Domain:https://localhost)] Request Done-
total:1.138,since last([partymgr::setPar...):1.138]]
{noformat}
I did not really review yet, but tt seems we are back to the PartyRole story. I
have to move, I'll be back...
> 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
>
> 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)
