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.
