[ https://issues.apache.org/jira/browse/OFBIZ-12424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17451774#comment-17451774 ]
Jacques Le Roux commented on OFBIZ-12424: ----------------------------------------- Thanks Rohit, As I suspected, the solution seems quite simple: simply make PARTY_REL_TPROLE a one-nofk relation: {code:xml} <relation type="one-nofk" fk-name="PARTY_REL_TPROLE" title="To" rel-entity-name="PartyRole"> <key-map field-name="partyIdTo" rel-field-name="partyId"/> <key-map field-name="roleTypeIdTo" rel-field-name="roleTypeId"/> </relation> {code} Result: {noformat} 2021-12-01 13:26:25,224 |jsse-nio-8443-exec-5 |ControlServlet |T| [[[partymgr::setPartyLink (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2021-12-01 13:26:25,273 |jsse-nio-8443-exec-5 |ConfigXMLReader |I| controller loaded: 0.0s, 0 requests, 0 views in file:/C:/projectsASF/Git/ofbiz-framework/framework/common/webcommon/WEB-INF/handlers-controller.xml 2021-12-01 13:26:25,274 |jsse-nio-8443-exec-5 |ConfigXMLReader |I| controller loaded: 0.023s, 52 requests, 21 views in file:/C:/projectsASF/Git/ofbiz-framework/framework/common/webcommon/WEB-INF/common-controller.xml 2021-12-01 13:26:25,284 |jsse-nio-8443-exec-5 |ConfigXMLReader |I| controller loaded: 0.001s, 30 requests, 13 views in file:/C:/projectsASF/Git/ofbiz-framework/framework/common/webcommon/WEB-INF/security-controller.xml 2021-12-01 13:26:25,293 |jsse-nio-8443-exec-5 |ConfigXMLReader |I| controller loaded: 0.0s, 4 requests, 0 views in file:/C:/projectsASF/Git/ofbiz-framework/applications/commonext/webapp/WEB-INF/controller.xml 2021-12-01 13:26:25,309 |jsse-nio-8443-exec-5 |ConfigXMLReader |I| controller loaded: 0.003s, 347 requests, 133 views in file:/C:/projectsASF/Git/ofbiz-framework/applications/content/webapp/content/WEB-INF/controller.xml 2021-12-01 13:26:25,311 |jsse-nio-8443-exec-5 |ConfigXMLReader |I| controller loaded: 0.072s, 268 requests, 110 views in file:/C:/projectsASF/Git/ofbiz-framework/applications/party/webapp/partymgr/WEB-INF/controller.xml 2021-12-01 13:26:25,322 |delegator-startup-9 |DelegatorFactoryImpl |I| Creating new delegator [default-no-eca] (delegator-startup-9) 2021-12-01 13:26:25,322 |delegator-startup-9 |GenericDelegator |I| Doing entity definition check... 2021-12-01 13:26:25,322 |delegator-startup-9 |ModelEntityChecker |I| [initReservedWords] array length = 1025 2021-12-01 13:26:25,352 |OFBiz-batch-5 |GenericDelegator |I| Delegator "default-no-eca" initializing helper "localderbyolap" for entity group "org.apache.ofbiz.olap". 2021-12-01 13:26:25,352 |OFBiz-batch-5 |GenericDelegator |I| Doing database check as requested in entityengine.xml with addMissing=true 2021-12-01 13:26:25,352 |OFBiz-batch-6 |GenericDelegator |I| Delegator "default-no-eca" initializing helper "localderby" for entity group "org.apache.ofbiz". 2021-12-01 13:26:25,352 |OFBiz-batch-6 |GenericDelegator |I| Doing database check as requested in entityengine.xml with addMissing=true 2021-12-01 13:26:25,353 |OFBiz-batch-7 |GenericDelegator |I| Delegator "default-no-eca" initializing helper "localderbytenant" for entity group "org.apache.ofbiz.tenant". 2021-12-01 13:26:25,353 |OFBiz-batch-7 |GenericDelegator |I| Doing database check as requested in entityengine.xml with addMissing=true 2021-12-01 13:26:25,353 |OFBiz-batch-5 |DatabaseUtil |I| Database Product Name is Apache Derby 2021-12-01 13:26:25,353 |OFBiz-batch-5 |DatabaseUtil |I| Database Product Version is 10.14.2.0 - (1828579) 2021-12-01 13:26:25,353 |OFBiz-batch-5 |DatabaseUtil |I| Database Driver Name is Apache Derby Embedded JDBC Driver 2021-12-01 13:26:25,353 |OFBiz-batch-5 |DatabaseUtil |I| Database Driver Version is 10.14.2.0 - (1828579) 2021-12-01 13:26:25,353 |OFBiz-batch-5 |DatabaseUtil |I| Database Driver JDBC Version is 4.2 2021-12-01 13:26:25,353 |OFBiz-batch-5 |DatabaseUtil |I| Database Setting/Support Information (those with a * should be true): 2021-12-01 13:26:25,353 |OFBiz-batch-5 |DatabaseUtil |I| - supports transactions [true]* 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - isolation None [false] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - isolation ReadCommitted [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - isolation ReadUncommitted [true] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| Database Product Name is Apache Derby 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| Database Product Version is 10.14.2.0 - (1828579) 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| Database Driver Name is Apache Derby Embedded JDBC Driver 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| Database Driver Version is 10.14.2.0 - (1828579) 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| Database Driver JDBC Version is 4.2 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| Database Setting/Support Information (those with a * should be true): 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - supports transactions [true]* 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - isolation None [false] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - isolation RepeatableRead [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - isolation Serializable [true] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - isolation ReadCommitted [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - forward only type [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - scroll sensitive type [false] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - isolation ReadUncommitted [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - scroll insensitive type [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - is case sensitive [false] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - isolation RepeatableRead [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - stores LowerCase [false] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - stores MixedCase [false] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - isolation Serializable [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - stores UpperCase [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - max table name length [128] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - forward only type [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - max column name length [128] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - concurrent connections [0] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - scroll sensitive type [false] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - concurrent statements [0] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - scroll insensitive type [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - ANSI SQL92 Entry [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - ANSI SQL92 Intermediate [false] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - is case sensitive [false] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - ANSI SQL92 Full [false] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - stores LowerCase [false] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - ODBC SQL Grammar Core [false] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - ODBC SQL Grammar Extended [false] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - stores MixedCase [false] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - ODBC SQL Grammar Minimum [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - outer joins [true]* 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - stores UpperCase [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - limited outer joins [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - full outer joins [false] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - max table name length [128] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - group by [true]* 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - max column name length [128] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - group by not in select [true] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - column aliasing [true] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - concurrent connections [0] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - order by not in select [false] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - alter table add column [true]* 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - concurrent statements [0] 2021-12-01 13:26:25,354 |OFBiz-batch-5 |DatabaseUtil |I| - non-nullable column [true]* 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - ANSI SQL92 Entry [true] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - ANSI SQL92 Intermediate [false] 2021-12-01 13:26:25,354 |OFBiz-batch-6 |DatabaseUtil |I| - ANSI SQL92 Full [false] 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - ODBC SQL Grammar Core [false] 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - ODBC SQL Grammar Extended [false] 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - ODBC SQL Grammar Minimum [true] 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - outer joins [true]* 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - limited outer joins [true] 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - full outer joins [false] 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - group by [true]* 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - group by not in select [true] 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - column aliasing [true] 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - order by not in select [false] 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - alter table add column [true]* 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - non-nullable column [true]* 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - default fetchsize [1] 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| - named parameters [ SKIPPED ] 2021-12-01 13:26:25,355 |OFBiz-batch-6 |DatabaseUtil |I| Getting Table Info From Database 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| Database Product Name is Apache Derby 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| Database Product Version is 10.14.2.0 - (1828579) 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| Database Driver Name is Apache Derby Embedded JDBC Driver 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| Database Driver Version is 10.14.2.0 - (1828579) 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| Database Driver JDBC Version is 4.2 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| Database Setting/Support Information (those with a * should be true): 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| - supports transactions [true]* 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| - isolation None [false] 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| - isolation ReadCommitted [true] 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| - isolation ReadUncommitted [true] 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| - isolation RepeatableRead [true] 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| - isolation Serializable [true] 2021-12-01 13:26:25,356 |OFBiz-batch-7 |DatabaseUtil |I| - forward only type [true] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - scroll sensitive type [false] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - scroll insensitive type [true] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - is case sensitive [false] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - stores LowerCase [false] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - stores MixedCase [false] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - stores UpperCase [true] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - max table name length [128] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - max column name length [128] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - concurrent connections [0] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - concurrent statements [0] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - ANSI SQL92 Entry [true] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - ANSI SQL92 Intermediate [false] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - ANSI SQL92 Full [false] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - ODBC SQL Grammar Core [false] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - ODBC SQL Grammar Extended [false] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - ODBC SQL Grammar Minimum [true] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - outer joins [true]* 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - limited outer joins [true] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - full outer joins [false] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - group by [true]* 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - group by not in select [true] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - column aliasing [true] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - order by not in select [false] 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - alter table add column [true]* 2021-12-01 13:26:25,357 |OFBiz-batch-7 |DatabaseUtil |I| - non-nullable column [true]* 2021-12-01 13:26:25,358 |OFBiz-batch-5 |DatabaseUtil |I| - default fetchsize [1] 2021-12-01 13:26:25,358 |OFBiz-batch-5 |DatabaseUtil |I| - named parameters [ SKIPPED ] 2021-12-01 13:26:25,358 |OFBiz-batch-5 |DatabaseUtil |I| Getting Table Info From Database 2021-12-01 13:26:25,359 |OFBiz-batch-7 |DatabaseUtil |I| - default fetchsize [1] 2021-12-01 13:26:25,359 |OFBiz-batch-7 |DatabaseUtil |I| - named parameters [ SKIPPED ] 2021-12-01 13:26:25,359 |OFBiz-batch-7 |DatabaseUtil |I| Getting Table Info From Database 2021-12-01 13:26:25,367 |OFBiz-batch-5 |DatabaseUtil |I| Getting Column Info From Database 2021-12-01 13:26:25,376 |OFBiz-batch-7 |DatabaseUtil |I| Getting Column Info From Database 2021-12-01 13:26:25,377 |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 13:26:25,378 |OFBiz-batch-5 |DatabaseUtil |I| Searching in 7 tables for primary key fields ... 2021-12-01 13:26:25,383 |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 13:26:25,383 |OFBiz-batch-7 |DatabaseUtil |I| Searching in 6 tables for primary key fields ... 2021-12-01 13:26:25,387 |OFBiz-batch-7 |DatabaseUtil |I| Reviewed 8 primary key fields from database. 2021-12-01 13:26:25,390 |OFBiz-batch-5 |DatabaseUtil |I| Reviewed 9 primary key fields from database. 2021-12-01 13:26:25,437 |OFBiz-batch-6 |DatabaseUtil |I| Getting Column Info From Database 2021-12-01 13:26:25,630 |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 13:26:25,631 |OFBiz-batch-6 |DatabaseUtil |I| Searching in 866 tables for primary key fields ... 2021-12-01 13:26:25,881 |OFBiz-batch-6 |DatabaseUtil |I| Reviewed 1689 primary key fields from database. 2021-12-01 13:26:25,895 |OFBiz-batch-6 |GenericDelegator |I| Entity ECA Handler disabled for delegator [default-no-eca] 2021-12-01 13:26:26,975 |jsse-nio-8443-exec-5 |ServiceDispatcher |T| Sync service [partymgr/linkPartyRecord] finished in [1659] milliseconds 2021-12-01 13:26:26,975 |jsse-nio-8443-exec-5 |RequestHandler |I| Ran Event [service:#linkPartyRecord] from [request], result is [success] 2021-12-01 13:26:26,977 |jsse-nio-8443-exec-5 |RequestHandler |I| Sending redirect to: [https://localhost:8443/partymgr/control/viewprofile?partyId=DemoLead2]. Hidden sessionId by default. 2021-12-01 13:26:26,988 |jsse-nio-8443-exec-5 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2021-12-01 13:26:27,009 |jsse-nio-8443-exec-5 |ControlServlet |T| [[[partymgr::setPartyLink (Domain:https://localhost)] Request Done- total:1.785,since last([partymgr::setPar...):1.785]] 2021-12-01 13:26:27,222 |sse-nio-8443-exec-10 |ControlServlet |T| [[[partymgr::viewprofile (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2021-12-01 13:26:27,252 |sse-nio-8443-exec-10 |RequestHandler |I| Rendering View [viewprofile]. Hidden sessionId by default. 2021-12-01 13:26:27,253 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/getUserPreferenceGroup] finished in [1] milliseconds 2021-12-01 13:26:27,263 |sse-nio-8443-exec-10 |ScreenFactory |I| Got 42 screens in 0.008s from: file:/C:/projectsASF/Git/ofbiz-framework/applications/party/widget/partymgr/PartyScreens.xml 2021-12-01 13:26:27,342 |sse-nio-8443-exec-10 |ScreenFactory |I| Got 5 screens in 0.004s from: file:/C:/projectsASF/Git/ofbiz-framework/applications/party/widget/partymgr/CommonScreens.xml 2021-12-01 13:26:27,356 |sse-nio-8443-exec-10 |ScreenFactory |I| Got 1 screens in 0.005s from: file:/C:/projectsASF/Git/ofbiz-framework/applications/commonext/widget/CommonScreens.xml 2021-12-01 13:26:27,543 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/getLastSystemInfoNote] finished in [127] milliseconds 2021-12-01 13:26:27,552 |sse-nio-8443-exec-10 |ScreenFactory |I| Got 29 screens in 0.004s from: file:/C:/projectsASF/Git/ofbiz-framework/framework/common/widget/CommonScreens.xml 2021-12-01 13:26:27,694 |sse-nio-8443-exec-10 |ScreenFactory |I| Got 28 screens in 0.005s from: file:/C:/projectsASF/Git/ofbiz-framework/themes/common-theme/widget/CommonScreens.xml 2021-12-01 13:26:27,900 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/genericBasePermissionCheck] finished in [72] milliseconds 2021-12-01 13:26:27,900 |sse-nio-8443-exec-10 |ServiceEcaCondition |W| doRealCompare returned null, returning false 2021-12-01 13:26:27,900 |sse-nio-8443-exec-10 |ServiceEcaRule |I| For Service ECA [partyBasePermissionCheck] on [return] got false for condition: [hasPermission][equals][false][true][Boolean] 2021-12-01 13:26:27,900 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/partyBasePermissionCheck] finished in [167] milliseconds 2021-12-01 13:26:27,906 |sse-nio-8443-exec-10 |ServiceEcaCondition |W| doRealCompare returned null, returning false 2021-12-01 13:26:27,906 |sse-nio-8443-exec-10 |ServiceEcaRule |I| For Service ECA [partyBasePermissionCheck] on [return] got false for condition: [hasPermission][equals][false][true][Boolean] 2021-12-01 13:26:27,907 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/partyBasePermissionCheck] finished in [1] milliseconds 2021-12-01 13:26:27,957 |sse-nio-8443-exec-10 |Log |I| [CommonPermissionServices.xml#genericBasePermissionCheck line 59] This simple-method-call is deprecated! Please use a service-call of genericBasePermissionC heck instead. 2021-12-01 13:26:27,958 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/genericBasePermissionCheck] finished in [1] milliseconds 2021-12-01 13:26:27,988 |sse-nio-8443-exec-10 |UtilProperties |I| ResourceBundle DefaultMessagesUiLabels (fr) created in 0.03s with 3 properties 2021-12-01 13:26:27,989 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/acctgBasePermissionCheck] finished in [65] milliseconds 2021-12-01 13:26:27,994 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/genericBasePermissionCheck] finished in [1] milliseconds 2021-12-01 13:26:27,994 |sse-nio-8443-exec-10 |ServiceEcaCondition |W| doRealCompare returned null, returning false 2021-12-01 13:26:27,994 |sse-nio-8443-exec-10 |ServiceEcaRule |I| For Service ECA [partyBasePermissionCheck] on [return] got false for condition: [hasPermission][equals][false][true][Boolean] 2021-12-01 13:26:27,994 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/partyBasePermissionCheck] finished in [1] milliseconds 2021-12-01 13:26:27,995 |sse-nio-8443-exec-10 |Log |I| [CommonPermissionServices.xml#genericBasePermissionCheck line 59] This simple-method-call is deprecated! Please use a service-call of genericBasePermissionC heck instead. 2021-12-01 13:26:27,997 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/genericBasePermissionCheck] finished in [2] milliseconds 2021-12-01 13:26:27,997 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/acctgBasePermissionCheck] finished in [3] milliseconds 2021-12-01 13:26:28,031 |sse-nio-8443-exec-10 |ConfigXMLReader |I| controller loaded: 0.005s, 514 requests, 243 views in file:/C:/projectsASF/Git/ofbiz-framework/applications/accounting/webapp/accounting/WEB-INF/controller. xml 2021-12-01 13:26:28,032 |sse-nio-8443-exec-10 |Log |I| [CommonPermissionServices.xml#genericBasePermissionCheck line 59] This simple-method-call is deprecated! Please use a service-call of genericBasePermissionC heck instead. 2021-12-01 13:26:28,033 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/genericBasePermissionCheck] finished in [1] milliseconds 2021-12-01 13:26:28,033 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/acctgBasePermissionCheck] finished in [1] milliseconds 2021-12-01 13:26:28,082 |sse-nio-8443-exec-10 |ConfigXMLReader |I| controller loaded: 0.003s, 380 requests, 153 views in file:/C:/projectsASF/Git/ofbiz-framework/applications/order/webapp/ordermgr/WEB-INF/controller.xml 2021-12-01 13:26:28,292 |sse-nio-8443-exec-10 |ScreenFactory |I| Got 23 screens in 0.027s from: file:/C:/projectsASF/Git/ofbiz-framework/applications/party/widget/partymgr/ProfileScreens.xml 2021-12-01 13:26:28,549 |sse-nio-8443-exec-10 |UtilProperties |I| ResourceBundle CommonEntityLabels (fr) created in 0.152s with 1399 properties 2021-12-01 13:26:29,466 |sse-nio-8443-exec-10 |ServiceDispatcher |T| Sync service [partymgr/getOrderedSummaryInformation] finished in [367] milliseconds 2021-12-01 13:26:30,098 |sse-nio-8443-exec-10 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2021-12-01 13:26:30,102 |sse-nio-8443-exec-10 |ControlServlet |T| [[[partymgr::viewprofile (Domain:https://localhost)] Request Done- total:2.88,since last([partymgr::viewpr...):2.88]] 2021-12-01 13:26:31,030 |jsse-nio-8443-exec-1 |ControlServlet |T| [[[partymgr::getJSONuiLabelArray (Domain:https://localhost)] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2021-12-01 13:26:31,067 |jsse-nio-8443-exec-1 |RequestHandler |I| Ran Event [java:org.apache.ofbiz.common.CommonEvents#getJSONuiLabelArray] from [request], result is [success] 2021-12-01 13:26:31,068 |jsse-nio-8443-exec-1 |ServerHitBin |I| Visit delegatorName=default, ServerHitBin delegatorName=default 2021-12-01 13:26:31,069 |jsse-nio-8443-exec-1 |ControlServlet |T| [[[partymgr::getJSONuiLabelArray (Domain:https://localhost)] Request Done- total:0.039,since last([partymgr::getJSO...):0.039]] {noformat} Now we need to be sure this has no other implications. I believe it should not and it's hard to know w/o doing it. Could be a 1st step before extending it to all relations from [EntityName]Role to PartyRole... Of course we should not backport this change, at least for a moment. Before being sure it's OK. > 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)