[jira] [Created] (OFBIZ-4567) Cannot add address for new party

[Nicolas Malin (Jira)]

Cannot add address for new party
--------------------------------

                 Key: OFBIZ-4567
                 URL: https://issues.apache.org/jira/browse/OFBIZ-4567
             Project: OFBiz
          Issue Type: Bug
          Components: specialpurpose/ecommerce
    Affects Versions: Release Branch 11.04, SVN trunk
            Reporter: Kiran Gawde


Create new party from partymgr.
Add login for the party.

Now login to ecommerce app using the party.
Click Profile -> Manage Address -> Add New Address.
Fill in address. Hit Save. You will get following error.

{code}
ERROR: Could not complete the Create a PartyContactMech [file:/home/ofbiz/trunk/applications/party/script/org/ofbiz/party/contact/PartyContactMechServices.xml#createPartyContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:PartyContactMech][contactMechId,10035(java.lang.String)][createdStamp,2011-11-16 03:04:30.775(java.sql.Timestamp)][createdTxStamp,2011-11-16 03:04:30.65(java.sql.Timestamp)][fromDate,2011-11-16 03:04:30.775(java.sql.Timestamp)][lastUpdatedStamp,2011-11-16 03:04:30.775(java.sql.Timestamp)][lastUpdatedTxStamp,2011-11-16 03:04:30.65(java.sql.Timestamp)][partyId,10006(java.lang.String)][roleTypeId,CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PARTY_CONTACT_MECH (PARTY_ID, CONTACT_MECH_ID, FROM_DATE, THRU_DATE, ROLE_TYPE_ID, ALLOW_SOLICITATION, EXTENSION, VERIFIED, COMMENTS, YEARS_WITH_CONTACT_MECH, MONTHS_WITH_CONTACT_MECH, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PARTY_CONTACT_MECH' caused a violation of foreign key constraint 'PARTY_CMECH_PROLE' for key (10006,CUSTOMER). The statement has been rolled back.))]
{code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[Malin Nicolas]

Your party haven't Customer role. If you want correct this, when you
create a Person, add the Customer role if is a customer, otherwise
extend a service to automatic add the needed role when you load a
contactMech for a customer (but you escape to functionnal control)

Nicolas

Le 16/11/2011 04:09, Kiran Gawde (Created) (JIRA) a écrit :

> Cannot add address for new party
> --------------------------------
>
>                   Key: OFBIZ-4567
>                   URL: https://issues.apache.org/jira/browse/OFBIZ-4567
>               Project: OFBiz
>            Issue Type: Bug
>            Components: specialpurpose/ecommerce
>      Affects Versions: Release Branch 11.04, SVN trunk
>              Reporter: Kiran Gawde
>
>
> Create new party from partymgr.
> Add login for the party.
>
> Now login to ecommerce app using the party.
> Click Profile ->  Manage Address ->  Add New Address.
> Fill in address. Hit Save. You will get following error.
>
> {code}
> ERROR: Could not complete the Create a PartyContactMech [file:/home/ofbiz/trunk/applications/party/script/org/ofbiz/party/contact/PartyContactMechServices.xml#createPartyContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:PartyContactMech][contactMechId,10035(java.lang.String)][createdStamp,2011-11-16 03:04:30.775(java.sql.Timestamp)][createdTxStamp,2011-11-16 03:04:30.65(java.sql.Timestamp)][fromDate,2011-11-16 03:04:30.775(java.sql.Timestamp)][lastUpdatedStamp,2011-11-16 03:04:30.775(java.sql.Timestamp)][lastUpdatedTxStamp,2011-11-16 03:04:30.65(java.sql.Timestamp)][partyId,10006(java.lang.String)][roleTypeId,CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PARTY_CONTACT_MECH (PARTY_ID, CONTACT_MECH_ID, FROM_DATE, THRU_DATE, ROLE_TYPE_ID, ALLOW_SOLICITATION, EXTENSION, VERIFIED, COMMENTS, YEARS_WITH_CONTACT_MECH, MONTHS_WITH_CONTACT_MECH, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PARTY_CONTACT_MECH' caused a violation of foreign key constraint 'PARTY_CMECH_PROLE' for key (10006,CUSTOMER). The statement has been rolled back.))]
> {code}
>
> --
> This message is automatically generated by JIRA.
> If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
> For more information on JIRA, see: http://www.atlassian.com/software/jira
>
>

--
Nicolas MALIN
Consultant
Tél : [phone]
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : [phone]
Site : http://www.librenberry.net/

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-4567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13151367#comment-13151367 ]

Kiran Gawde commented on OFBIZ-4567:
------------------------------------

Had to add customer role to party using party mgr.

Thanks Nicolas for the info!
               

> Cannot add address for new party
> --------------------------------
>
>                 Key: OFBIZ-4567
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4567
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: Release Branch 11.04, SVN trunk
>            Reporter: Kiran Gawde
>
> Create new party from partymgr.
> Add login for the party.
> Now login to ecommerce app using the party.
> Click Profile -> Manage Address -> Add New Address.
> Fill in address. Hit Save. You will get following error.
> {code}
> ERROR: Could not complete the Create a PartyContactMech [file:/home/ofbiz/trunk/applications/party/script/org/ofbiz/party/contact/PartyContactMechServices.xml#createPartyContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:PartyContactMech][contactMechId,10035(java.lang.String)][createdStamp,2011-11-16 03:04:30.775(java.sql.Timestamp)][createdTxStamp,2011-11-16 03:04:30.65(java.sql.Timestamp)][fromDate,2011-11-16 03:04:30.775(java.sql.Timestamp)][lastUpdatedStamp,2011-11-16 03:04:30.775(java.sql.Timestamp)][lastUpdatedTxStamp,2011-11-16 03:04:30.65(java.sql.Timestamp)][partyId,10006(java.lang.String)][roleTypeId,CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PARTY_CONTACT_MECH (PARTY_ID, CONTACT_MECH_ID, FROM_DATE, THRU_DATE, ROLE_TYPE_ID, ALLOW_SOLICITATION, EXTENSION, VERIFIED, COMMENTS, YEARS_WITH_CONTACT_MECH, MONTHS_WITH_CONTACT_MECH, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PARTY_CONTACT_MECH' caused a violation of foreign key constraint 'PARTY_CMECH_PROLE' for key (10006,CUSTOMER). The statement has been rolled back.))]
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-4567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kiran Gawde resolved OFBIZ-4567.
--------------------------------

    Resolution: Not A Problem

Had to add customer role to party using partymgr. (Info provided by Nicolas)
               

> Cannot add address for new party
> --------------------------------
>
>                 Key: OFBIZ-4567
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4567
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: Release Branch 11.04, SVN trunk
>            Reporter: Kiran Gawde
>
> Create new party from partymgr.
> Add login for the party.
> Now login to ecommerce app using the party.
> Click Profile -> Manage Address -> Add New Address.
> Fill in address. Hit Save. You will get following error.
> {code}
> ERROR: Could not complete the Create a PartyContactMech [file:/home/ofbiz/trunk/applications/party/script/org/ofbiz/party/contact/PartyContactMechServices.xml#createPartyContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:PartyContactMech][contactMechId,10035(java.lang.String)][createdStamp,2011-11-16 03:04:30.775(java.sql.Timestamp)][createdTxStamp,2011-11-16 03:04:30.65(java.sql.Timestamp)][fromDate,2011-11-16 03:04:30.775(java.sql.Timestamp)][lastUpdatedStamp,2011-11-16 03:04:30.775(java.sql.Timestamp)][lastUpdatedTxStamp,2011-11-16 03:04:30.65(java.sql.Timestamp)][partyId,10006(java.lang.String)][roleTypeId,CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PARTY_CONTACT_MECH (PARTY_ID, CONTACT_MECH_ID, FROM_DATE, THRU_DATE, ROLE_TYPE_ID, ALLOW_SOLICITATION, EXTENSION, VERIFIED, COMMENTS, YEARS_WITH_CONTACT_MECH, MONTHS_WITH_CONTACT_MECH, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PARTY_CONTACT_MECH' caused a violation of foreign key constraint 'PARTY_CMECH_PROLE' for key (10006,CUSTOMER). The statement has been rolled back.))]
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-4567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux closed OFBIZ-4567.
----------------------------------


Thanks Nicolas!
               

> Cannot add address for new party
> --------------------------------
>
>                 Key: OFBIZ-4567
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4567
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: Release Branch 11.04, SVN trunk
>            Reporter: Kiran Gawde
>
> Create new party from partymgr.
> Add login for the party.
> Now login to ecommerce app using the party.
> Click Profile -> Manage Address -> Add New Address.
> Fill in address. Hit Save. You will get following error.
> {code}
> ERROR: Could not complete the Create a PartyContactMech [file:/home/ofbiz/trunk/applications/party/script/org/ofbiz/party/contact/PartyContactMechServices.xml#createPartyContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:PartyContactMech][contactMechId,10035(java.lang.String)][createdStamp,2011-11-16 03:04:30.775(java.sql.Timestamp)][createdTxStamp,2011-11-16 03:04:30.65(java.sql.Timestamp)][fromDate,2011-11-16 03:04:30.775(java.sql.Timestamp)][lastUpdatedStamp,2011-11-16 03:04:30.775(java.sql.Timestamp)][lastUpdatedTxStamp,2011-11-16 03:04:30.65(java.sql.Timestamp)][partyId,10006(java.lang.String)][roleTypeId,CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PARTY_CONTACT_MECH (PARTY_ID, CONTACT_MECH_ID, FROM_DATE, THRU_DATE, ROLE_TYPE_ID, ALLOW_SOLICITATION, EXTENSION, VERIFIED, COMMENTS, YEARS_WITH_CONTACT_MECH, MONTHS_WITH_CONTACT_MECH, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PARTY_CONTACT_MECH' caused a violation of foreign key constraint 'PARTY_CMECH_PROLE' for key (10006,CUSTOMER). The statement has been rolled back.))]
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira