[jira] [Comment Edited] (OFBIZ-5949) ofbizsetup create product store cause exception, remove use of temp file to load entity data

["Jacques Le Roux (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OFBIZ-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14349488#comment-14349488 ] 

Jacques Le Roux edited comment on OFBIZ-5949 at 3/5/15 9:32 PM:
----------------------------------------------------------------

Wai,

Do you say that there is only 1 modification in your patch? Because your patch is 64 KB and contains "tons" of modifications. 
Also your change is about 
{quote}
replacing shipmentMethodTypeId="NEXT_DAY" to shipmentMethodTypeId="NEXT_DAY_AIR"
{quote}
But OOTB there are no "NEXT_DAY_AIR shipmentMethodTypeId, only "NEXT_DAY" and "AIR" shipmentMethodTypeIds

Could you explain more please? From where does come this combination? I don't clearly understand your statement:
{quote}
This is required because the original data references a nonexistent entry in CarrierShipmentMethod and causes a foreign key violation
{quote}
"NEXT_DAY" is not a carrier (nor "AIR" BTW). A carrier must be a party with a valid partyId.



was (Author: jacques.le.roux):
Wai,

Do you say that there is only 1 modification in your patch? Because your patch is 64 KB and contains "tons" of modifications. 
Also your change is about 
{quote}
replacing shipmentMethodTypeId="NEXT_DAY" to shipmentMethodTypeId="NEXT_DAY_AIR"
{quote}
But OOTB there are no "NEXT_DAY_AIR shipmentMethodTypeId, only "NEXT_DAY" and "AIR" shipmentMethodTypeId

Could you explain more please? From where does come this combination? I don't clearly understand your statement:
{quote}
This is required because the original data references a nonexistent entry in CarrierShipmentMethod and causes a foreign key violation
{quote}
"NEXT_DAY" is not a carrier (nor "AIR" BTW). A carrier must be a party with a valid partyId.


> ofbizsetup create product store cause exception, remove use of temp file to load entity data
> --------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-5949
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-5949
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: Trunk
>            Reporter: Wai
>            Assignee: Jacques Le Roux
>         Attachments: OFBIZ-5949.patch
>
>
> The exception is caused by foreign key constraint violation between ShipmentCostEstimate and  CarrierShipmentMethod entities.
> Currently, when creating a new product store using ofbizsetup component default data associated with the product store is loaded into the database using the following steps.
> 1. read default data from entity xml file and replace specific items in the read data and write to temp file.
> 2. use service=parseEntityXmlFile to load the processed file into database.
> The issue with this method is that the temp file can present a problem when ofbiz is operating in multitenant mode.
> The solution is to modify the relevant services so that no temp file needs generated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)