[
https://issues.apache.org/jira/browse/OFBIZ-9768?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16700257#comment-16700257
]
Jacques Le Roux commented on OFBIZ-9768:
----------------------------------------
I tried the patch, the idea seems good. When on the the Lead conversion page I
clicked on the Submit button and got:
bq. Exception thrown while creating the "newEntity" GenericValue:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:PartyRelationship][createdStamp,2018-11-27
12:07:44.339(java.sql.Timestamp)][createdTxStamp,2018-11-27
12:07:44.216(java.sql.Timestamp)][fromDate,2018-11-27
12:07:44.339(java.sql.Timestamp)][lastUpdatedStamp,2018-11-27
12:07:44.339(java.sql.Timestamp)][lastUpdatedTxStamp,2018-11-27
12:07:44.216(java.sql.Timestamp)][partyIdFrom,admin(java.lang.String)][partyIdTo,sfa102(java.lang.String)][partyRelationshipTypeId,ACCOUNT(java.lang.String)][roleTypeIdFrom,OWNER(java.lang.String)][roleTypeIdTo,ACCOUNT(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.PARTY_RELATIONSHIP (PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM,
ROLE_TYPE_ID_TO, FROM_DATE, THRU_DATE, STATUS_ID, RELATIONSHIP_NAME,
SECURITY_GROUP_ID, PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID,
PERMISSIONS_ENUM_ID, POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PARTY_RELATIONSHIP'
caused a violation of foreign key constraint 'PARTY_REL_FPROLE' for key
(admin,OWNER). The statement has been rolled back.)) (Error while inserting:
[GenericEntity:PartyRelationship][createdStamp,2018-11-27
12:07:44.339(java.sql.Timestamp)][createdTxStamp,2018-11-27
12:07:44.216(java.sql.Timestamp)][fromDate,2018-11-27
12:07:44.339(java.sql.Timestamp)][lastUpdatedStamp,2018-11-27
12:07:44.339(java.sql.Timestamp)][lastUpdatedTxStamp,2018-11-27
12:07:44.216(java.sql.Timestamp)][partyIdFrom,admin(java.lang.String)][partyIdTo,sfa102(java.lang.String)][partyRelationshipTypeId,ACCOUNT(java.lang.String)][roleTypeIdFrom,OWNER(java.lang.String)][roleTypeIdTo,ACCOUNT(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.PARTY_RELATIONSHIP (PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM,
ROLE_TYPE_ID_TO, FROM_DATE, THRU_DATE, STATUS_ID, RELATIONSHIP_NAME,
SECURITY_GROUP_ID, PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID,
PERMISSIONS_ENUM_ID, POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PARTY_RELATIONSHIP'
caused a violation of foreign key constraint 'PARTY_REL_FPROLE' for key
(admin,OWNER). The statement has been rolled back.)))
Not sure it's an issue on my side or generic. To be checked, thanks
> While converting the lead, it redirects to the Create Party Relationship in
> SFA component
> -----------------------------------------------------------------------------------------
>
> Key: OFBIZ-9768
> URL: https://issues.apache.org/jira/browse/OFBIZ-9768
> Project: OFBiz
> Issue Type: Bug
> Affects Versions: Release Branch 13.07, Trunk, Release Branch 16.11,
> Release Branch 17.12
> Reporter: Rubia Elza Joshep
> Assignee: Suraj Khurana
> Priority: Major
> Attachments: OFBIZ-9768.patch, screenshot-1.png, screenshot-2.png
>
>
> Steps to regenerate:
> 1) Open URL
> https://demo-trunk.ofbiz.apache.org/sfa/control/viewprofile?roleTypeId=LEAD&partyId=10007
> 2) Click on Convert lead and select the related company and click on Add.
> 3) It redirects to the Create Party Relationship.
> Expected: It should redirect to the Lead conversion page since the company is
> associated.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
