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 |
Hi Abhijeet,
Check weather your DB has following data or not: <ProductDimension dimensionId="_NF_"/> <ProductDimension dimensionId="_NA_"/> <CurrencyDimension dimensionId="_NF_" description="Currency Not Found."/> <CurrencyDimension dimensionId="_NA_" description="Currency Not Set."/> <DateDimension dimensionId="_NF_" description="Date Not Found."/> <DateDimension dimensionId="_NA_" description="Date Not Set."/> -- Thanks Ramkrishna On Fri, Dec 18, 2009 at 3:18 PM, Abhijeet Pandey <[hidden email]>wrote: > 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 > |
Free forum by Nabble | Edit this page |