Note: the GenericEntity:ContactMech][contactMechId,10000 is already allocated from loading party and contact info when ofbiz is initialized ant run-install-extseed so I am assuming that the lookup needs to evaluate the party to determine the next contactMechId Maybe also ECA's that updates the number pool on startup.
BJ Freeman sent the following on 9/24/2008 10:30 PM: > I forwarded an email to the account setup in the javamail container. > it showed up under communication > [Fwd: Using Your New E-mailbox] Auto Email [] [] Unknown > Party 2008-09-24 2008-09-24 > I clicked on it > https://localhost:8443/partymgr/control/ViewCommunicationEvent?communicationEventId=10000 > Allocate this message to a existing or new party and add an email address > I put in my partyid and clicked on > created/Add email to party. > I do not have the Email address shown in my party contact mech. > hard to test on the demo server. > > The Following Errors Occurred: > > Error:Error:Error:ERROR: Could not complete the Create Contact Mechanism > [file:/C:/projects/java/ofbiz_trickshop_dev/applications/party/script/org/ofbiz/party/contact/ContactMechServices.xml#createContactMech] > process [problem creating the newValue value: Error while inserting: > [GenericEntity:ContactMech][contactMechId,10000(java.lang.String)][contactMechTypeId,EMAIL_ADDRESS(java.lang.String)][createdStamp,2008-09-24 > 22:21:41.062(java.sql.Timestamp)][createdTxStamp,2008-09-24 > 22:21:40.562(java.sql.Timestamp)][infoString,[EMAIL > PROTECTED](java.lang.String)][lastUpdatedStamp,2008-09-24 > 22:21:41.062(java.sql.Timestamp)][lastUpdatedTxStamp,2008-09-24 > 22:21:40.562(java.sql.Timestamp)] (SQL Exception while executing the > following:INSERT INTO OFBIZ.CONTACT_MECH (CONTACT_MECH_ID, > CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, > ?, ?, ?, ?) (The statement was aborted because it would have caused a > duplicate key value in a unique or primary key constraint or unique > index identified by 'SQL080922112238980' defined on 'CONTACT_MECH'.))] > calling service createContactMech in createPartyContactMech calling > service createPartyContactMech in createPartyEmailAddress calling > service createPartyEmailAddress in allocateMsgToParty > > > >
