[ 
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)

Reply via email to