Abhijeet, Its a foreign key constraint between "SalesInvoiceItemFact" and "DateDimension" entities, it means you are trying to insert some record in "SalesInvoiceItemFact" entity for which "dimensionId" is not exist in "DateDimension". So first insert required entries in "DateDimension" entity then in SalesInvoiceItemFact entity. I would suggest to look into specialpurpose/bi/entitydef/entitymodel.xml for more information.
On Tue, Oct 13, 2009 at 10:36 AM, Abhijeet Pandey <abhijeet.pan...@gmail.com > wrote: > Hi All, > > Please help me with this? > > What is the cause and solution of this error. > > Error trying to begin transaction, could not process method: The current > transaction is marked for rollback, not beginning a new transaction and > aborting current operation; the rollbackOnly was caused by: Failure in > create operation for entity [SalesInvoiceItemFact]: > org.ofbiz.entity.GenericEntityException: > Error while inserting: > > [GenericEntity:SalesInvoiceItemFact][billToCustomerDimId,_NA_(java.lang.String)][createdStamp,2009-10-12 > 12:29:18.17(java.sql.Timestamp)][createdTxStamp,2009-10-12 > > 12:29:10.003(java.sql.Timestamp)][invoiceDateDimId,_NF_(java.lang.String)][invoiceId,CI7(java.lang.String)][invoiceItemSeqId,00001(java.lang.String)][lastUpdatedStamp,2009-10-12 > 12:29:18.17(java.sql.Timestamp)][lastUpdatedTxStamp,2009-10-12 > > 12:29:10.003(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-10-12 > 12:29:18.17(java.sql.Timestamp)][createdTxStamp,2009-10-12 > > 12:29:10.003(java.sql.Timestamp)][invoiceDateDimId,_NF_(java.lang.String)][invoiceId,CI7(java.lang.String)][invoiceItemSeqId,00001(java.lang.String)][lastUpdatedStamp,2009-10-12 > 12:29:18.17(java.sql.Timestamp)][lastUpdatedTxStamp,2009-10-12 > > 12:29:10.003(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-10-12 > 12:29:18.17(java.sql.Timestamp)][createdTxStamp,2009-10-12 > > 12:29:10.003(java.sql.Timestamp)][invoiceDateDimId,_NF_(java.lang.String)][invoiceId,CI7(java.lang.String)][invoiceItemSeqId,00001(java.lang.String)][lastUpdatedStamp,2009-10-12 > 12:29:18.17(java.sql.Timestamp)][lastUpdatedTxStamp,2009-10-12 > > 12:29:10.003(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.))) > > > > Please help. > > > -- > Abhijeet Pandey > -- Anil Soni +91-9930302283cell
