[ https://issues.apache.org/jira/browse/OFBIZ-2812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12743269#action_12743269 ]
Jacques Le Roux commented on OFBIZ-2812: ---------------------------------------- A comment from dev ML by Ajay S {quote} Here is sure shot solution: This is because when you create a Lead you only specify the mandatory fields . So when you try to convert the lead the party group is null which throws an error. So while creating a lead you are required to specify the field name "Group Name" then convert your lead.This will make the entry of your lead in accounts and contacts as well. :-) {quote} At 1st sight this sounds like we should make this field mandatory, but I did not test anything at this stage > bug in sfa when converting a lead > --------------------------------- > > Key: OFBIZ-2812 > URL: https://issues.apache.org/jira/browse/OFBIZ-2812 > Project: OFBiz > Issue Type: Bug > Components: marketing > Affects Versions: SVN trunk > Reporter: Erwan de FERRIERES > Fix For: SVN trunk > > > After having created a lead in the sfa component, and that you want to > convert it, you don't have the choice to choose an account for him. > https://localhost:8443/sfa/control/ConvertLead?partyId=10010&partyGroupId=null > Then if you still want to convert him, and you click on the submit button, > you've got the following error : > ERROR: Could not complete the Create Party Role > [file:/home/erwan/workspaceNeogia/ofbizTrunk/ofbiz/applications/party/script/org/ofbiz/party/party/PartyServices.xml#createPartyRole] > process [problem creating the newEntity value: Error while inserting: > [GenericEntity:PartyRole][createdStamp,2009-08-07 > 18:50:07.857(java.sql.Timestamp)][createdTxStamp,2009-08-07 > 18:50:07.761(java.sql.Timestamp)][lastUpdatedStamp,2009-08-07 > 18:50:07.857(java.sql.Timestamp)][lastUpdatedTxStamp,2009-08-07 > 18:50:07.761(java.sql.Timestamp)][partyId,null(java.lang.String)][roleTypeId,ACCOUNT(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO OFBIZ.PARTY_ROLE > (PARTY_ID, ROLE_TYPE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (INSERT on table > 'PARTY_ROLE' caused a violation of foreign key constraint 'PARTY_RLE_PARTY' > for key (null). The statement has been rolled back.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.