Hi,
currently it is
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localmssql"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localderbyolap"/>
</delegator>
so this should be changed to
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localmssql"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localmssql"/>
</delegator>
Is this correct ?
Thanks,
On Mon, Oct 12, 2009 at 2:55 PM, Jacopo Cappellato <
[email protected]> wrote:
> Hi Abhijeet,
>
> please make sure that, in entityengine.xml, you have properly mapped to a
> valid data source the group-name="org.ofbiz.olap"
>
> Jacopo
>
>
> On Oct 12, 2009, at 9:10 AM, Abhijeet Pandey wrote:
>
> 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
>>
>
>
--
Abhijeet Pandey
