You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Erwan de FERRIERES (JIRA)" <ji...@apache.org> on 2009/08/07 18:51:14 UTC
[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.
Re: [jira] Created: (OFBIZ-2812) bug in sfa when converting a lead
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <of...@palinfocom.net>
>
> 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 jira@apache.org 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.
>
Re: [jira] Created: (OFBIZ-2812) bug in sfa when converting a lead
Posted by Pal InfoCom Technologies <of...@palinfocom.net>.
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 jira@apache.org 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] Commented: (OFBIZ-2812) bug in sfa when converting a lead
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Closed: (OFBIZ-2812) bug in sfa when converting a lead
Posted by "Erwan de FERRIERES (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (OFBIZ-2812) bug in sfa when converting a lead
Posted by "Shradha Shah (JIRA)" <ji...@apache.org>.
[ 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.