Error

[Abhijeet Pandey]

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]

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 <[hidden email]
> 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
[phone]cell

[Abdullah Shaikh-3]

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, <[hidden email]> 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 <
> [hidden email]
> > 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
> [phone]cell
>