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. >> > > > > -- View this message in context: http://www.nabble.com/Error-on-Quick-Ship-tf4762206.html#a13647994 Sent from the OFBiz - User mailing list archive at Nabble.com.
