You can try importing this from webtools, I guess this would help.
<DateDimension dimensionId="_NA_" description="Date Not Set."
lastUpdatedStamp="2009-05-29 14:15:17.409" lastUpdatedTxStamp="2009-05-29
14:15:17.299" createdStamp="2009-05-22 11:02:36.596"
createdTxStamp="2009-05-22 11:02:36.559"/>
<DateDimension dimensionId="_NF_" description="Date Not Found."
lastUpdatedStamp="2009-05-29 14:15:17.406" lastUpdatedTxStamp="2009-05-29
14:15:17.299" createdStamp="2009-05-22 11:02:36.589"
createdTxStamp="2009-05-22 11:02:36.559"/>
On Tue, Oct 13, 2009 at 12:13 PM, <toanils...@gmail.com> wrote:
> 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
>
