ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacopo Cappellato <...@sastau.it>
Subject Re: Error on Quick Ship
Date Thu, 08 Nov 2007 15:15:12 GMT
did you run the "ant run-install" command?

Jacopo

pmacdee wrote:
> Thanks.  I get a different error now.  
> 
> I updated ofbiz to 
> 
> /var/www/ofbiz$ svn info
> Path: .
> URL: http://svn.apache.org/repos/asf/ofbiz/trunk
> Repository Root: http://svn.apache.org/repos/asf
> Repository UUID: 13f79535-47bb-0310-9956-ffa450edef68
> Revision: 593024
> Node Kind: directory
> Schedule: normal
> Last Changed Author: jacopoc
> Last Changed Rev: 592805
> Last Changed Date: 2007-11-07 08:17:53 -0800 (Wed, 07 Nov 2007)
> 
> and tried the following ...
> I have the seed data loaded  and start at Order Entry
>   Enter Party ID for Demo Customer -> Continue
>   Enter Default Routing Task as the WorkEffort Id
>   Add Dates, PO number -> Continue
>  Add a Big Gizmo to the order  -> Quick Finalize Order
>    Select ShipTo, Shipping option, Offline Payment -> Create Order
>   Then I hit QuickShip Entire Order and I get the error:
> 
> 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,2007-11-08
> 06:22:58.779(java.sql.Timestamp)][createdTxStamp,2007-11-08
> 06:22:56.89(java.sql.Timestamp)][invoiceDateDimId,_NF_(java.lang.String)][invoiceId,CI3(java.lang.String)][invoiceItemSeqId,00001(java.lang.String)][lastUpdatedStamp,2007-11-08
> 06:22:58.779(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-08
> 06:22:56.89(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,2007-11-08
> 06:22:58.779(java.sql.Timestamp)][createdTxStamp,2007-11-08
> 06:22:56.89(java.sql.Timestamp)][invoiceDateDimId,_NF_(java.lang.String)][invoiceId,CI3(java.lang.String)][invoiceItemSeqId,00001(java.lang.String)][lastUpdatedStamp,2007-11-08
> 06:22:58.779(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-08
> 06:22:56.89(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,2007-11-08
> 06:22:58.779(java.sql.Timestamp)][createdTxStamp,2007-11-08
> 06:22:56.89(java.sql.Timestamp)][invoiceDateDimId,_NF_(java.lang.String)][invoiceId,CI3(java.lang.String)][invoiceItemSeqId,00001(java.lang.String)][lastUpdatedStamp,2007-11-08
> 06:22:58.779(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-08
> 06:22:56.89(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.))))
> 
> 
> 
> David E Jones wrote:
>>
>> It is probably what I suspected then. This is a bug that was fixed a  
>> while back, and actually discussed on the mailing list too if you want  
>> to search around for the history (on something like nabble).
>>
>> -David
>>
>>
>> On Nov 7, 2007, at 1:49 PM, pmacdee wrote:
>>
>>> I did try it on hotwax and it worked (of course!).
>>>
>>> Here is the svninfo :
>>>
>>> /var/www/ofbiz$ svn info
>>> Path: .
>>> URL: http://svn.apache.org/repos/asf/ofbiz/trunk
>>> Repository Root: http://svn.apache.org/repos/asf
>>> Repository UUID: 13f79535-47bb-0310-9956-ffa450edef68
>>> Revision: 569999
>>> Node Kind: directory
>>> Schedule: normal
>>> Last Changed Author: jonesde
>>> Last Changed Rev: 569963
>>> Last Changed Date: 2007-08-26 19:30:23 -0700 (Sun, 26 Aug 2007)
>>>
>>>
>>> David E Jones wrote:
>>>>
>>>> A really useful detail would be the OFBiz revision number and
>>>> repository URL you are using.
>>>>
>>>> Another really useful things would be to try it on
>>>> http://demo.hotwaxmedia.com/facility/control/main
>>>>
>>>> -David
>>>>
>>>>
>>>> On Nov 6, 2007, at 7:02 PM, Scott Gray wrote:
>>>>
>>>>> I've run a few quick ships on the trunk lately without problems,  
>>>>> could
>>>>> you provide some more details or try to replicate the problem with  
>>>>> the
>>>>> seed data and give us the steps?
>>>>>
>>>>> Thanks
>>>>> Scott
>>>>>
>>>>> On 07/11/2007, pmacdee <pamacdonald@hrl.com> wrote:
>>>>>>
>>>>>> I get the an error when I try to quick ship an order.
>>>>>>
>>>>>> The following required parameter is missing:
>>>>>> [assignPartyToWorkEffort.workEffortId])]
>>>>>>
>>>>>> Any ideas?
>>>>>>
>>>>>> Thanks !
>>>>>>
>>>>>> Here is the complete error message
>>>>>>
>>>>>>
>>>>>>
>>>>>> The Following Errors Occurred:
>>>>>>
>>>>>> ERROR: Could not complete the Sub-method used by quickShip methods
>>>>>> to create
>>>>>> a shipment
>>>>>>
>>>>>> [file:/var/www/ofbiz/applications/product/script/org/ofbiz/ 
>>>>>> shipment/
>>>>>> shipment/ 
>>>>>> ShipmentServices.xml#createShipmentForFacilityAndShipGroup]
>>>>>> process [problem finding the Shipment entity: The current
>>>>>> transaction is
>>>>>> marked for rollback, not beginning a new transaction and aborting
>>>>>> current
>>>>>> operation; the rollbackOnly was caused by: Service
>>>>>> [assignPartyToWorkEffort]
>>>>>> threw an unexpected
>>>>>> exception/errororg.ofbiz.service.ServiceValidationException: The
>>>>>> following
>>>>>> required parameter is missing:
>>>>>> [assignPartyToWorkEffort.workEffortId] (The
>>>>>> following required parameter is missing:
>>>>>> [assignPartyToWorkEffort.workEffortId])]
>>>>>>
>>>>>> --
>>>>>> View this message in context:
>>>>>> http://www.nabble.com/Error-on-Quick-Ship-tf4762206.html#a13619920
>>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>>
>>>>>>
>>>>
>>>>
>>>>
>>> -- 
>>> View this message in context:
>>> http://www.nabble.com/Error-on-Quick-Ship-tf4762206.html#a13635784
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>  
>>
> 


Mime
View raw message