Re: Failure in create operation for entity [SalesInvoiceItemFact]

Jacopo Cappellato Thu, 02 Apr 2009 06:17:38 -0700

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
Description: S/MIME cryptographic signature

Re: Failure in create operation for entity [SalesInvoiceItemFact]

Reply via email to