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
