OFBiz › OFBiz - User

Failure in create operation for entity [SalesInvoiceItemFact]

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 3 messages Options
benni23
Reply | Threaded
Open this post in threaded view
♦
♦
|

Failure in create operation for entity [SalesInvoiceItemFact]

benni23
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
Jacopo Cappellato-4
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Failure in create operation for entity [SalesInvoiceItemFact]

Jacopo Cappellato-4
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.
>


smime.p7s (3K) Download Attachment
benni23
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Failure in create operation for entity [SalesInvoiceItemFact]

benni23
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.
>


 
Free forum by Nabble Edit this page