You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by benni23 <b....@googlemail.com> on 2009/04/01 18:23:10 UTC
Failure in create operation for entity [SalesInvoiceItemFact]
Hi,
I have a problem with the "quickShipEntireOrder" function (I am using ofbiz
trunk 755618). For an order created in the webshop I suddenly get the
following error:
ERROR 23503: INSERT on table 'SALES_INVOICE_ITEM_FACT' caused a violation of
foreign key constraint 'SIIF_INVDATE' for key (_NF_).
Furthermore I have the jdbc Driver of the Derby DB in the stacktrace althoug
I configured the entity engine to use postgres:
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="mei_postgres"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localderbyolap"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="mei_postgres"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localderbyolap"/>
</delegator>
My store settings are as follows:
<ProductStore productStoreId="9000" storeName="Meilenkontor Webstore"
companyName="Meilenkontor" title="Meilenkontor Meilenshop" subtitle="Shop
your miles away"
payToPartyId="Meilenkontor" daysToCancelNonPay="30"
manualAuthIsCapture="N" prorateShipping="N" prorateTaxes="Y"
viewCartOnAdd="N" autoSaveCart="N" autoApproveReviews="N" isDemoStore="N"
isImmediatelyFulfilled="N" inventoryFacilityId="MEIKO_WAREHOUSE01"
oneInventoryFacility="Y" checkInventory="Y" reserveInventory="Y"
reserveOrderEnumId="INVRO_FIFO_REC" requireInventory="N"
balanceResOnOrderCreation="N" orderNumberPrefix="WS"
defaultLocaleString="de_DE" defaultCurrencyUomId="EUR"
defaultSalesChannelEnumId="WEB_SALES_CHANNEL" allowPassword="Y"
explodeOrderItems="N" checkGcBalance="N" retryFailedAuths="Y"
headerApprovedStatus="ORDER_APPROVED" itemApprovedStatus="ITEM_APPROVED"
digitalItemApprovedStatus="ITEM_APPROVED"
headerDeclinedStatus="ORDER_REJECTED"
itemDeclinedStatus="ITEM_REJECTED" headerCancelStatus="ORDER_CANCELLED"
itemCancelStatus="ITEM_CANCELLED"
authDeclinedMessage="There has been a problem with your method of payment.
Please try a different method or call customer service."
authFraudMessage="Your order has been rejected and your account has been
disabled due to fraud."
authErrorMessage="Problem connecting to payment processor; we will
continue to retry and notify you by email."
visualThemeId="MULTIFLEX" usePrimaryEmailUsername="N"
requireCustomerRole="N" autoInvoiceDigitalItems="Y"
reqShipAddrForDigItems="Y" showCheckoutGiftOptions="Y"
selectPaymentTypePerItem="N" showPricesWithVatTax="N" showTaxIsExempt="N"
vatTaxAuthGeoId="DEU" vatTaxAuthPartyId="FIN_HAM"
enableAutoSuggestionList="N" enableDigProdUpload="N"
prodSearchExcludeVariants="Y" autoOrderCcTryExp="Y"
autoOrderCcTryOtherCards="Y" autoOrderCcTryLaterNsf="Y"
storeCreditValidDays="90" autoApproveInvoice="Y" autoApproveOrder="Y"
shipIfCaptureFails="Y" addToCartRemoveIncompat="Y"
addToCartReplaceUpsell="Y" splitPayPrefPerShpGrp="Y"
lastUpdatedStamp="2009-04-01 18:08:19.687" lastUpdatedTxStamp="2009-04-01
18:08:19.453"
createdStamp="2009-02-27 17:41:18.671" createdTxStamp="2009-02-27
17:41:18.343" />
The stacktrace reads:
ERROR 23503: INSERT on table 'SALES_INVOICE_ITEM_FACT' caused a violation of
foreign key constraint 'SIIF_INVDATE' for key (_NF_). The statement has
been rolled back.
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown
Source)
org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown
Source)....
Does anybody have a clue what the cause of this error might be?
regards,
Benni
--
View this message in context: http://www.nabble.com/Failure-in-create-operation-for-entity--SalesInvoiceItemFact--tp22829962p22829962.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Failure in create operation for entity [SalesInvoiceItemFact]
Posted by benni23 <b....@googlemail.com>.
Hi,
you are right, this solved the problem. Thanks for the hint.
regards,
Benni
Jacopo Cappellato-4 wrote:
>
> Hi,
>
> this is an error caused by the missing configuration of the bi
> (business intelligence) component.
> You still have probably this line in the entityengine.xml file (where
> the delegator is defined):
>
> <group-map group-name="org.ofbiz.olap" datasource-
> name="localderbyolap"/>
>
> this is the db (Derby) where the bi entities are created.
> In particular you should have a record with id "_NF_" in the
> DateDimension entity (in localderbyolap): if you add the record (I
> don't know why it is missing) the error should disappear.
>
> Or you can just disable the automatic trigger by removing the
> following line from the ofbiz-component.xml file of the accounting
> component:
>
> <service-resource type="eca" loader="main" location="servicedef/
> secas_olap.xml"/>
>
> This will solve your issue.
>
> Jacopo
>
> On Apr 1, 2009, at 9:53 PM, benni23 wrote:
>
>>
>> Hi,
>>
>> I have a problem with the "quickShipEntireOrder" function (I am
>> using ofbiz
>> trunk 755618). For an order created in the webshop I suddenly get the
>> following error:
>>
>> ERROR 23503: INSERT on table 'SALES_INVOICE_ITEM_FACT' caused a
>> violation of
>> foreign key constraint 'SIIF_INVDATE' for key (_NF_).
>>
>> Furthermore I have the jdbc Driver of the Derby DB in the stacktrace
>> althoug
>> I configured the entity engine to use postgres:
>> <delegator name="default" entity-model-reader="main"
>> entity-group-reader="main" entity-eca-reader="main"
>> distributed-cache-clear-enabled="false">
>> <group-map group-name="org.ofbiz" datasource-
>> name="mei_postgres"/>
>> <group-map group-name="org.ofbiz.olap"
>> datasource-name="localderbyolap"/>
>> </delegator>
>> <delegator name="default-no-eca" entity-model-reader="main"
>> entity-group-reader="main" entity-eca-reader="main"
>> entity-eca-enabled="false" distributed-cache-clear-enabled="false">
>> <group-map group-name="org.ofbiz" datasource-
>> name="mei_postgres"/>
>> <group-map group-name="org.ofbiz.olap"
>> datasource-name="localderbyolap"/>
>> </delegator>
>>
>>
>> My store settings are as follows:
>>
>> <ProductStore productStoreId="9000" storeName="Meilenkontor Webstore"
>> companyName="Meilenkontor" title="Meilenkontor Meilenshop"
>> subtitle="Shop
>> your miles away"
>> payToPartyId="Meilenkontor" daysToCancelNonPay="30"
>> manualAuthIsCapture="N" prorateShipping="N" prorateTaxes="Y"
>> viewCartOnAdd="N" autoSaveCart="N" autoApproveReviews="N"
>> isDemoStore="N"
>> isImmediatelyFulfilled="N" inventoryFacilityId="MEIKO_WAREHOUSE01"
>> oneInventoryFacility="Y" checkInventory="Y" reserveInventory="Y"
>> reserveOrderEnumId="INVRO_FIFO_REC" requireInventory="N"
>> balanceResOnOrderCreation="N" orderNumberPrefix="WS"
>> defaultLocaleString="de_DE" defaultCurrencyUomId="EUR"
>> defaultSalesChannelEnumId="WEB_SALES_CHANNEL" allowPassword="Y"
>> explodeOrderItems="N" checkGcBalance="N" retryFailedAuths="Y"
>> headerApprovedStatus="ORDER_APPROVED"
>> itemApprovedStatus="ITEM_APPROVED"
>> digitalItemApprovedStatus="ITEM_APPROVED"
>> headerDeclinedStatus="ORDER_REJECTED"
>> itemDeclinedStatus="ITEM_REJECTED"
>> headerCancelStatus="ORDER_CANCELLED"
>> itemCancelStatus="ITEM_CANCELLED"
>> authDeclinedMessage="There has been a problem with your method of
>> payment.
>> Please try a different method or call customer service."
>> authFraudMessage="Your order has been rejected and your account
>> has been
>> disabled due to fraud."
>> authErrorMessage="Problem connecting to payment processor; we will
>> continue to retry and notify you by email."
>> visualThemeId="MULTIFLEX" usePrimaryEmailUsername="N"
>> requireCustomerRole="N" autoInvoiceDigitalItems="Y"
>> reqShipAddrForDigItems="Y" showCheckoutGiftOptions="Y"
>> selectPaymentTypePerItem="N" showPricesWithVatTax="N"
>> showTaxIsExempt="N"
>> vatTaxAuthGeoId="DEU" vatTaxAuthPartyId="FIN_HAM"
>> enableAutoSuggestionList="N" enableDigProdUpload="N"
>> prodSearchExcludeVariants="Y" autoOrderCcTryExp="Y"
>> autoOrderCcTryOtherCards="Y" autoOrderCcTryLaterNsf="Y"
>> storeCreditValidDays="90" autoApproveInvoice="Y"
>> autoApproveOrder="Y"
>> shipIfCaptureFails="Y" addToCartRemoveIncompat="Y"
>> addToCartReplaceUpsell="Y" splitPayPrefPerShpGrp="Y"
>> lastUpdatedStamp="2009-04-01 18:08:19.687"
>> lastUpdatedTxStamp="2009-04-01
>> 18:08:19.453"
>> createdStamp="2009-02-27 17:41:18.671" createdTxStamp="2009-02-27
>> 17:41:18.343" />
>>
>>
>> The stacktrace reads:
>> ERROR 23503: INSERT on table 'SALES_INVOICE_ITEM_FACT' caused a
>> violation of
>> foreign key constraint 'SIIF_INVDATE' for key (_NF_). The statement
>> has
>> been rolled back.
>> org.apache.derby.iapi.error.StandardException.newException(Unknown
>> Source)
>> org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown
>> Source)
>> org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown
>> Source)....
>>
>>
>> Does anybody have a clue what the cause of this error might be?
>>
>> regards,
>> Benni
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Failure-in-create-operation-for-entity--SalesInvoiceItemFact--tp22829962p22829962.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>
>
>
--
View this message in context: http://www.nabble.com/Failure-in-create-operation-for-entity--SalesInvoiceItemFact--tp22829962p22863777.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Failure in create operation for entity [SalesInvoiceItemFact]
Posted by Jacopo Cappellato <ja...@hotwaxmedia.com>.
Hi,
this is an error caused by the missing configuration of the bi
(business intelligence) component.
You still have probably this line in the entityengine.xml file (where
the delegator is defined):
<group-map group-name="org.ofbiz.olap" datasource-
name="localderbyolap"/>
this is the db (Derby) where the bi entities are created.
In particular you should have a record with id "_NF_" in the
DateDimension entity (in localderbyolap): if you add the record (I
don't know why it is missing) the error should disappear.
Or you can just disable the automatic trigger by removing the
following line from the ofbiz-component.xml file of the accounting
component:
<service-resource type="eca" loader="main" location="servicedef/
secas_olap.xml"/>
This will solve your issue.
Jacopo
On Apr 1, 2009, at 9:53 PM, benni23 wrote:
>
> Hi,
>
> I have a problem with the "quickShipEntireOrder" function (I am
> using ofbiz
> trunk 755618). For an order created in the webshop I suddenly get the
> following error:
>
> ERROR 23503: INSERT on table 'SALES_INVOICE_ITEM_FACT' caused a
> violation of
> foreign key constraint 'SIIF_INVDATE' for key (_NF_).
>
> Furthermore I have the jdbc Driver of the Derby DB in the stacktrace
> althoug
> I configured the entity engine to use postgres:
> <delegator name="default" entity-model-reader="main"
> entity-group-reader="main" entity-eca-reader="main"
> distributed-cache-clear-enabled="false">
> <group-map group-name="org.ofbiz" datasource-
> name="mei_postgres"/>
> <group-map group-name="org.ofbiz.olap"
> datasource-name="localderbyolap"/>
> </delegator>
> <delegator name="default-no-eca" entity-model-reader="main"
> entity-group-reader="main" entity-eca-reader="main"
> entity-eca-enabled="false" distributed-cache-clear-enabled="false">
> <group-map group-name="org.ofbiz" datasource-
> name="mei_postgres"/>
> <group-map group-name="org.ofbiz.olap"
> datasource-name="localderbyolap"/>
> </delegator>
>
>
> My store settings are as follows:
>
> <ProductStore productStoreId="9000" storeName="Meilenkontor Webstore"
> companyName="Meilenkontor" title="Meilenkontor Meilenshop"
> subtitle="Shop
> your miles away"
> payToPartyId="Meilenkontor" daysToCancelNonPay="30"
> manualAuthIsCapture="N" prorateShipping="N" prorateTaxes="Y"
> viewCartOnAdd="N" autoSaveCart="N" autoApproveReviews="N"
> isDemoStore="N"
> isImmediatelyFulfilled="N" inventoryFacilityId="MEIKO_WAREHOUSE01"
> oneInventoryFacility="Y" checkInventory="Y" reserveInventory="Y"
> reserveOrderEnumId="INVRO_FIFO_REC" requireInventory="N"
> balanceResOnOrderCreation="N" orderNumberPrefix="WS"
> defaultLocaleString="de_DE" defaultCurrencyUomId="EUR"
> defaultSalesChannelEnumId="WEB_SALES_CHANNEL" allowPassword="Y"
> explodeOrderItems="N" checkGcBalance="N" retryFailedAuths="Y"
> headerApprovedStatus="ORDER_APPROVED"
> itemApprovedStatus="ITEM_APPROVED"
> digitalItemApprovedStatus="ITEM_APPROVED"
> headerDeclinedStatus="ORDER_REJECTED"
> itemDeclinedStatus="ITEM_REJECTED"
> headerCancelStatus="ORDER_CANCELLED"
> itemCancelStatus="ITEM_CANCELLED"
> authDeclinedMessage="There has been a problem with your method of
> payment.
> Please try a different method or call customer service."
> authFraudMessage="Your order has been rejected and your account
> has been
> disabled due to fraud."
> authErrorMessage="Problem connecting to payment processor; we will
> continue to retry and notify you by email."
> visualThemeId="MULTIFLEX" usePrimaryEmailUsername="N"
> requireCustomerRole="N" autoInvoiceDigitalItems="Y"
> reqShipAddrForDigItems="Y" showCheckoutGiftOptions="Y"
> selectPaymentTypePerItem="N" showPricesWithVatTax="N"
> showTaxIsExempt="N"
> vatTaxAuthGeoId="DEU" vatTaxAuthPartyId="FIN_HAM"
> enableAutoSuggestionList="N" enableDigProdUpload="N"
> prodSearchExcludeVariants="Y" autoOrderCcTryExp="Y"
> autoOrderCcTryOtherCards="Y" autoOrderCcTryLaterNsf="Y"
> storeCreditValidDays="90" autoApproveInvoice="Y"
> autoApproveOrder="Y"
> shipIfCaptureFails="Y" addToCartRemoveIncompat="Y"
> addToCartReplaceUpsell="Y" splitPayPrefPerShpGrp="Y"
> lastUpdatedStamp="2009-04-01 18:08:19.687"
> lastUpdatedTxStamp="2009-04-01
> 18:08:19.453"
> createdStamp="2009-02-27 17:41:18.671" createdTxStamp="2009-02-27
> 17:41:18.343" />
>
>
> The stacktrace reads:
> ERROR 23503: INSERT on table 'SALES_INVOICE_ITEM_FACT' caused a
> violation of
> foreign key constraint 'SIIF_INVDATE' for key (_NF_). The statement
> has
> been rolled back.
> org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown
> Source)
> org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown
> Source)....
>
>
> Does anybody have a clue what the cause of this error might be?
>
> regards,
> Benni
>
> --
> View this message in context: http://www.nabble.com/Failure-in-create-operation-for-entity--SalesInvoiceItemFact--tp22829962p22829962.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>