Hi, Facing below error after packing and doing the shipment. Can anybody plz point out what could be the reason?
I am not seeing any table called "OFBIZ.SALES_INVOICE_ITEM_FACT" in my MSSQL. Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service invocation error (Could not commit transaction for service [completePack] call: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [SalesInvoiceItemFact]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SalesInvoiceItemFact][billToCustomerDimId,_NA_(java.lang.String)][createdStamp,2009-12-18 15:01:36.343(java.sql.Timestamp)][createdTxStamp,2009-12-18 15:01:32.921(java.sql.Timestamp)][invoiceDateDimId,_NF_(java.lang.String)][invoiceId,CI69(java.lang.String)][invoiceItemSeqId,00001(java.lang.String)][lastUpdatedStamp,2009-12-18 15:01:36.343(java.sql.Timestamp)][lastUpdatedTxStamp,2009-12-18 15:01:32.921(java.sql.Timestamp)][orderId,_NA_(java.lang.String)][origCurrencyDimId,_NF_(java.lang.String)][productDimId,_NF_(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SALES_INVOICE_ITEM_FACT (INVOICE_ID, INVOICE_ITEM_SEQ_ID, ORDER_ID, INVOICE_DATE_DIM_ID, PRODUCT_DIM_ID, BILL_TO_CUSTOMER_DIM_ID, ORIG_CURRENCY_DIM_ID, QUANTITY, EXT_GROSS_AMOUNT, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT, EXT_TAX_AMOUNT, EXT_MAN_FIXED_COST, EXT_MAN_VAR_COST, EXT_STORAGE_COST, EXT_DISTRIBUTION_COST, CONTRIBUTION_AMOUNT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (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.)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SalesInvoiceItemFact][billToCustomerDimId,_NA_(java.lang.String)][createdStamp,2009-12-18 15:01:36.343(java.sql.Timestamp)][createdTxStamp,2009-12-18 15:01:32.921(java.sql.Timestamp)][invoiceDateDimId,_NF_(java.lang.String)][invoiceId,CI69(java.lang.String)][invoiceItemSeqId,00001(java.lang.String)][lastUpdatedStamp,2009-12-18 15:01:36.343(java.sql.Timestamp)][lastUpdatedTxStamp,2009-12-18 15:01:32.921(java.sql.Timestamp)][orderId,_NA_(java.lang.String)][origCurrencyDimId,_NF_(java.lang.String)][productDimId,_NF_(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SALES_INVOICE_ITEM_FACT (INVOICE_ID, INVOICE_ITEM_SEQ_ID, ORDER_ID, INVOICE_DATE_DIM_ID, PRODUCT_DIM_ID, BILL_TO_CUSTOMER_DIM_ID, ORIG_CURRENCY_DIM_ID, QUANTITY, EXT_GROSS_AMOUNT, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT, EXT_TAX_AMOUNT, EXT_MAN_FIXED_COST, EXT_MAN_VAR_COST, EXT_STORAGE_COST, EXT_DISTRIBUTION_COST, CONTRIBUTION_AMOUNT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (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.)) (Error while inserting: [GenericEntity:SalesInvoiceItemFact][billToCustomerDimId,_NA_(java.lang.String)][createdStamp,2009-12-18 15:01:36.343(java.sql.Timestamp)][createdTxStamp,2009-12-18 15:01:32.921(java.sql.Timestamp)][invoiceDateDimId,_NF_(java.lang.String)][invoiceId,CI69(java.lang.String)][invoiceItemSeqId,00001(java.lang.String)][lastUpdatedStamp,2009-12-18 15:01:36.343(java.sql.Timestamp)][lastUpdatedTxStamp,2009-12-18 15:01:32.921(java.sql.Timestamp)][orderId,_NA_(java.lang.String)][origCurrencyDimId,_NF_(java.lang.String)][productDimId,_NF_(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SALES_INVOICE_ITEM_FACT (INVOICE_ID, INVOICE_ITEM_SEQ_ID, ORDER_ID, INVOICE_DATE_DIM_ID, PRODUCT_DIM_ID, BILL_TO_CUSTOMER_DIM_ID, ORIG_CURRENCY_DIM_ID, QUANTITY, EXT_GROSS_AMOUNT, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT, EXT_TAX_AMOUNT, EXT_MAN_FIXED_COST, EXT_MAN_VAR_COST, EXT_STORAGE_COST, EXT_DISTRIBUTION_COST, CONTRIBUTION_AMOUNT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (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.)))) Thanks, -- Abhijeet Pandey
