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,[hidden email](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 |
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,[hidden email](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 > > > > |
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,[hidden email](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 >> >> >> >> > > > > |
Administrator
|
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" <[hidden email]> > 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,[hidden email](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 >>> >>> >>> >>> >> >> >> >> > |
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" <[hidden email]> >> 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,[hidden email](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 >>>> >>>> >>>> >>>> >>> >>> >>> >>> >> > > > > |
Administrator
|
Cool, thanks !
Jacques From: "BJ Freeman" <[hidden email]> > 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" <[hidden email]> >>> 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,[hidden email](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 >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> >>> >> >> >> >> > |
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" <[hidden email]> >> 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" <[hidden email]> >>>> 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,[hidden email](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 >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>> >>> >>> >>> >> > > > > |
Free forum by Nabble | Edit this page |