You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "surya kusumakar (JIRA)" <ji...@apache.org> on 2008/09/17 16:19:45 UTC
[jira] Created: (OFBIZ-1963) Added support for migrating
FacilityRole to FacilityParty
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
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.
[jira] Closed: (OFBIZ-1963) Added support for migrating
FacilityRole to FacilityParty
Posted by "Ashish Vijaywargiya (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Vijaywargiya closed OFBIZ-1963.
--------------------------------------
Resolution: Fixed
Thanks Surya for your contribution.
Your changes are in rev # 698159.
Special Thanks to Pranay Pandey for his support.
--
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, 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.
[jira] Updated: (OFBIZ-1963) Added support for migrating
FacilityRole to FacilityParty
Posted by "surya kusumakar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
surya kusumakar updated OFBIZ-1963:
-----------------------------------
Attachment: LatestUpdatedFacilityParty.patch
Hello Ashish,
This is updated with the required modifications.
Thanks
Surya .
> 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, 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.
[jira] Issue Comment Edited: (OFBIZ-1963) Added support for
migrating FacilityRole to FacilityParty
Posted by "surya kusumakar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12633204#action_12633204 ]
kusumakarsurya edited comment on OFBIZ-1963 at 9/22/08 3:43 AM:
-----------------------------------------------------------------
Hello Ashish,
This is updated patch with the required modifications.
Thanks
Surya .
was (Author: kusumakarsurya):
Hello Ashish,
This is updated with the required modifications.
Thanks
Surya .
> 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, 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.
[jira] Updated: (OFBIZ-1963) Added support for migrating
FacilityRole to FacilityParty
Posted by "surya kusumakar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
surya kusumakar updated OFBIZ-1963:
-----------------------------------
Priority: Minor (was: Major)
> 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
> 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.
[jira] Updated: (OFBIZ-1963) Added support for migrating
FacilityRole to FacilityParty
Posted by "surya kusumakar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
surya kusumakar updated OFBIZ-1963:
-----------------------------------
Attachment: (was: LatestUpdatedFacilityParty.patch)
> 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, 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.
[jira] Updated: (OFBIZ-1963) Added support for migrating
FacilityRole to FacilityParty
Posted by "surya kusumakar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
surya kusumakar updated OFBIZ-1963:
-----------------------------------
Attachment: (was: LatestUpdatedFacilityParty.patch)
> 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, LatestUpdatedFacilityParty.patch, 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.
[jira] Updated: (OFBIZ-1963) Added support for migrating
FacilityRole to FacilityParty
Posted by "surya kusumakar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
surya kusumakar updated OFBIZ-1963:
-----------------------------------
Attachment: LatestUpdatedFacilityParty.patch
This patch contains implementation of the description given above.
> 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
> 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.
[jira] Commented: (OFBIZ-1963) Added support for migrating
FacilityRole to FacilityParty
Posted by "Ashish Vijaywargiya (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (OFBIZ-1963) Added support for migrating
FacilityRole to FacilityParty
Posted by "surya kusumakar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
surya kusumakar updated OFBIZ-1963:
-----------------------------------
Attachment: LatestUpdatedFacilityParty.patch
> 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, LatestUpdatedFacilityParty.patch, 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.
[jira] Updated: (OFBIZ-1963) Added support for migrating
FacilityRole to FacilityParty
Posted by "surya kusumakar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
surya kusumakar updated OFBIZ-1963:
-----------------------------------
Attachment: LatestUpdatedFacilityParty.patch
This patch contains following changes :
1)In FacilityForms fromDate is added in deletelink as it was showing error when we delete FacilityParty.
2)Changes made in migrateFacilityRole service , now it is creating a record in PartyRole entity .
Thanks.
Surya Kusumakar
> 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, LatestUpdatedFacilityParty.patch, 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.
[jira] Assigned: (OFBIZ-1963) Added support for migrating
FacilityRole to FacilityParty
Posted by "Ashish Vijaywargiya (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Vijaywargiya reassigned OFBIZ-1963:
------------------------------------------
Assignee: 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.