[jira] Created: (OFBIZ-3910) Sending multiple emails simultaneously to new party does not work properly

["Martin Kreidenweis (JIRA)" <ji...@apache.org>]

Sending multiple emails simultaneously to new party does not work properly
--------------------------------------------------------------------------

                 Key: OFBIZ-3910
                 URL: https://issues.apache.org/jira/browse/OFBIZ-3910
             Project: OFBiz
          Issue Type: Bug
          Components: party
    Affects Versions: Release Branch 10.04
            Reporter: Martin Kreidenweis


Sending more than one email at once to a party that never has received an email using the sendMailFromScreen service fails. 
Creating the communication event for the email in this case triggers the createPartyRole service. So two threads apparently try to insert the same party role. This results in the following error: 
{code}
java.lang.Exception: Failure in create operation for entity [PartyRole]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:PartyRole][createdStamp,2010-08-30 10:44:41.144(java.sql.Timestamp)][createdTxStamp,2010-08-30 10:44:26.709(java.sql.Timestamp)][lastUpdatedStamp,2010-08-30 10:44:41.144(java.sql.Timestamp)][lastUpdatedTxStamp,2010-08-30 10:44:26.709(java.sql.Timestamp)][partyId,RegisteredMerchantCompany(java.lang.String)][roleTypeId,ADDRESSEE(java.lang.String)] (SQL Exception while executing the following:INSERT INTO ofbiz.PARTY_ROLE (PARTY_ID, ROLE_TYPE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint »pk_party_role«)). Rolling back transaction.
{code}

This happens only after the actual emails are sent. OFBiz now rolls back the transaction, thinks the email sending failed, and tries to send the emails again later. 

Workaround: 
Create a PartyRole ADDRESSE for the party before trying to send emails. 
We did not find a good solution for the actual problem. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.