Hi,
i am running my application with MSSQL. i did ant clean all and then
i am
facing issue when i am doing quick ship entire order from order
manager
application.
the code is same , i just did ant clean all , what is the problem
with this.
Please help.
this is error which i am getting , pLz help.
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
