[ https://issues.apache.org/jira/browse/OFBIZ-5980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Le Roux reopened OFBIZ-5980: ------------------------------------ Hi Pierre, I reopen because I found a small issue and a bigger one: small: description="RoleTypes associated to a Party"> should not be written this way bigger: if you look in log you will see a lot of errors like {noformat} 2021-11-06 10:23:45,057 |OFBiz-batch-2 |DatabaseUtil |E| SQL Exception while executing the following: ALTER TABLE OFBIZ.BILLING_ACCOUNT_ROLE ADD CONSTRAINT BILLACCT_RL_PTRL FOREIGN KEY (PARTY_ID, ROLE_TYPE_ID) REFERENCES OFBIZ.PARTY_ROLE (PARTY_ID, ROLE_TYPE_ID) Error was: java.sql.SQLException: Constraint 'BILLACCT_RL_PTRL' is invalid: there is no unique or primary key constraint on table '"OFBIZ"."PARTY_ROLE"' that matches the number and types of the columns in the foreign key. java.sql.SQLException: Constraint 'BILLACCT_RL_PTRL' is invalid: there is no unique or primary key constraint on table '"OFBIZ"."PARTY_ROLE"' that matches the number and types of the columns in the foreign key. {noformat} I guess it's because all relations like BILLACCT_RL_PTRL miss the fromDate PK TIA > Have the ability to revoke (expire) roles of a party > ---------------------------------------------------- > > Key: OFBIZ-5980 > URL: https://issues.apache.org/jira/browse/OFBIZ-5980 > Project: OFBiz > Issue Type: Improvement > Components: party > Affects Versions: Trunk > Reporter: Pierre Smits > Assignee: Pierre Smits > Priority: Major > Labels: roles > Fix For: Upcoming Branch > > > Currently it only possible to delete a role. > Which can lead to potential error messages, when a particular role is > associated with records where the roleTypeId is used as a foreign key in the > entity-model/database and the user tries to delete that role from the list. > In order to avoid such, it is better to revoke the PartyRole record by > setting an expiration date (end date) on the record. -- This message was sent by Atlassian Jira (v8.3.4#803005)