Getting Following Error

[Abhijeet Pandey]

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

[RamKrishna Swamy]

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
>