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 <[EMAIL PROTECTED]> 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.
