https://localhost:8443/partymgr/control/allocateMsgToParty error

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

https://localhost:8443/partymgr/control/allocateMsgToParty error

BJ Freeman
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

Reply | Threaded
Open this post in threaded view
|

Re: https://localhost:8443/partymgr/control/allocateMsgToParty error

BJ Freeman
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
>
>
>
>

Reply | Threaded
Open this post in threaded view
|

Re: https://localhost:8443/partymgr/control/allocateMsgToParty error

BJ Freeman
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
>>
>>
>>
>>
>
>
>
>

Reply | Threaded
Open this post in threaded view
|

Re: https://localhost:8443/partymgr/control/allocateMsgToParty error

Jacques Le Roux
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
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: https://localhost:8443/partymgr/control/allocateMsgToParty error

BJ Freeman
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
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>
>
>
>
>

Reply | Threaded
Open this post in threaded view
|

Re: https://localhost:8443/partymgr/control/allocateMsgToParty error

Jacques Le Roux
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
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: https://localhost:8443/partymgr/control/allocateMsgToParty error

BJ Freeman
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
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>>
>>>
>>
>
>
>
>