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.
