https://issues.apache.org/jira/browse/OFBIZ-1969
Jacques Le Roux sent the following on 9/25/2008 2:00 PM: > Cool, thanks ! > > Jacques > > From: "BJ Freeman" <[EMAIL PROTECTED]> >> yes. but consider that a quick fix for my problem. >> will open a jira once I have the service that will check insalled data >> against the number pool entity and set it to the max number. >> >> Jacques Le Roux sent the following on 9/25/2008 11:45 AM: >>> Hi BJ, >>> >>> Could you open a Jira issue and provide a patch for this please ? >>> I understood that you troubleshooted the problem by changing seed data, >>> did you test it ? >>> >>> Jacques >>> >>> From: "BJ Freeman" <[EMAIL PROTECTED]> >>>> or a quicker fix is to update the number entity in the seed data. >>>> :) >>>> >>>> BJ Freeman sent the following on 9/24/2008 10:51 PM: >>>>> 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 >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>> >>> >>> >>> >> > > > >
