[
https://issues.apache.org/jira/browse/OFBIZ-6216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14546609#comment-14546609 ]
Divesh Dutta commented on OFBIZ-6216:
-------------------------------------
As Rishi mentioned, these error will never come while loading data from ant commands because these files do not have entry in ofbiz-component.xml . Also these files are only used in method createProductStoreWithDefaultSetting in SetupEvents.xml . These files are not made to imported directly from
https://localhost:8443/webtools/control/entityImport .
Actually in createProductStoreWithDefaultSetting method, productStoreId will be generated dynamically and stored in variable PRODUCTSTOREID. And in code
{code}
<ProductStorePaymentSetting productStoreId="PRODUCTSTOREID" paymentMethodTypeId="CREDIT_CARD" paymentServiceTypeEnumId="PRDS_PAY_AUTH" paymentService="alwaysApproveCCProcessor" paymentCustomMethodId="CC_AUTH_ALWAYSAPPROV"/>
{code}
productStoreId="PRODUCTSTOREID is not a value itself but its expected to take value from variable PRODUCTSTOREID and assign it to a field productStoreId of ProductStorePaymentSetting table.
When you go to
https://localhost:8443/ofbizsetup/control/main , you can set up store with all the default settings. For this purpose, ProductStoreData.xml file have the template for creating the store.
Now to address the original issue, we can use NEXT_DAY_AIR instead of NEXT_DAY in ProductStoreData.xml. NEXT_DAY_AIR have entry in ShippingData.xml
> ProductStoreData.xml contains UPS NEXT_DAY not present in ShippingData.xml
> --------------------------------------------------------------------------
>
> Key: OFBIZ-6216
> URL:
https://issues.apache.org/jira/browse/OFBIZ-6216> Project: OFBiz
> Issue Type: Bug
> Components: product
> Affects Versions: Trunk
> Reporter: Christian Carlow
> Priority: Trivial
>
> A foreign key error is thrown when shipping data is manually entered by copying the xml from ProductStoreData.xml into the text field at
https://localhost:8443/webtools/control/entityImport after doing the same for ShippingData.xml. I don't think the error is seen when the data is imported by running load-seed because it creates dummy foreign keys.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
Locked
