[jira] Created: (OFBIZ-2812) bug in sfa when converting a lead
Locked
[jira] Created: (OFBIZ-2812) bug in sfa when converting a lead
 
|
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. |
[jira] Commented: (OFBIZ-2812) bug in sfa when converting a lead
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-2812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12742237#action_12742237 ] Shradha Shah commented on OFBIZ-2812: ------------------------------------- Hi, I am working on functionality to select an existing account while converting a lead. Thanks & Regards Shradha Shah iLabs L&T Infotech > 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. |
Re: [jira] Created: (OFBIZ-2812) bug in sfa when converting a lead
|
|
In reply to this post by Nicolas Malin (Jira)
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.  If you need any further support on how to do this, please feel free to email us at ofbiz@palinfocom.net -- Best regards, Ajay S PIC Technologies, Mohali
|
[jira] Commented: (OFBIZ-2812) bug in sfa when converting a lead
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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. |
Re: [jira] Created: (OFBIZ-2812) bug in sfa when converting a lead
Administrator
|
In reply to this post by Pal Infocom Technologies-2
Hi Ajay,
As it sounded interesting I quickly put your comment in the Jira issue. But please rather use Jira directly next time Thanks Jacques From: "Pal InfoCom Technologies" <[hidden email]> > > 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. :-) > > If you need any further support on how to do this, please feel free to email > us at [hidden email] > > -- > Best regards, > Ajay S > > PIC Technologies, > Mohali > > > > > JIRA [hidden email] wrote: >> >> 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. >> >> >> > > -- > View this message in context: > http://www.nabble.com/-jira--Created%3A-%28OFBIZ-2812%29-bug-in-sfa-when-converting-a-lead-tp24868304p24954901.html > Sent from the OFBiz - Dev mailing list archive at Nabble.com. > |
[jira] Closed: (OFBIZ-2812) bug in sfa when converting a lead
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Erwan de FERRIERES closed OFBIZ-2812. ------------------------------------- Resolution: Fixed Assignee: Erwan de FERRIERES Working at rev.915812 > 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 > Assignee: 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. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |