[
https://issues.apache.org/jira/browse/OFBIZ-1963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12633185#action_12633185
]
Ashish Vijaywargiya commented on OFBIZ-1963:
--------------------------------------------
Hello Surya,
While running the migration service from Webtools I am getting the following
error :-
errorMessage ERROR: Could not complete the Migrate Data From FacilityRole To
FacilityParty
[file:/home/ashish/ofbiz_dev/other/applications/product/script/org/ofbiz/product/UpgradeServices.xml#migrateFacilityRole]
process [problem creating the facilityParty value: Error while inserting:
[GenericEntity:FacilityParty][createdStamp,2008-09-22
14:35:41.792(java.sql.Timestamp)][createdTxStamp,2008-09-22
14:35:41.76(java.sql.Timestamp)][facilityId,WebStoreWarehouse(java.lang.String)][fromDate,2008-09-22
14:35:41.792(java.sql.Timestamp)][lastUpdatedStamp,2008-09-22
14:35:41.792(java.sql.Timestamp)][lastUpdatedTxStamp,2008-09-22
14:35:41.76(java.sql.Timestamp)][partyId,approver(java.lang.String)][roleTypeId,ACCOUNT(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO public.FACILITY_PARTY
(FACILITY_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?) (ERROR: insert or update on table "facility_party" violates foreign
key constraint "facility_prty_role" Detail: Key
(party_id,role_type_id)=(approver,ACCOUNT) is not present in table
"party_role".))]
responseMessage error
To overcome from this error you should add the code to associate the roleTypeId
with the partyId in the PartyRole table.
This error is coming because now we have added the foreign key constraint in
the FacilityParty table with PartyRole table.
Please let me know if you need more description on this.
--
Ashish Vijaywargiya
> Added support for migrating FacilityRole to FacilityParty
> ---------------------------------------------------------
>
> Key: OFBIZ-1963
> URL: https://issues.apache.org/jira/browse/OFBIZ-1963
> Project: OFBiz
> Issue Type: Improvement
> Components: product
> Reporter: surya kusumakar
> Assignee: Ashish Vijaywargiya
> Priority: Minor
> Attachments: LatestUpdatedFacilityParty.patch
>
>
> 1) Write a migrate service to upgrade existing data from the FacilityRole
> entity to the new FacilityParty entity. For these, changes has been made in
> UI as well.
> 2) The FacilityRole entity has been deprecated and new entity FacilityParty
> is created for these changes has been made in UI and entitymodel.xml files.
> 3) Also add fromDate and thruDate fields to maintain records of FacilityRole
> entity.
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
