thanks, I am trying to get into a test environment. how do I load the dimension ids below?
Jacopo Cappellato wrote: > > Load these and that error will disappear: > > <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."/> > <ProductDimension dimensionId="_NF_" description="Product Not Found."/> > <ProductDimension dimensionId="_NA_" description="Product Not Set."/> > > However, if I were in you, and if you are running in a test environment > at least I would issue the following command: > > ant run-install-seed > > It will now wipe out your existing data (and if you run it there is no > need to manually load the data I sent you) > > Good luck! > > Jacopo > > > > > pmacdee wrote: >> I did when I did the original installation. But based on David's remark >> below, I did an svn update. I saw a lot of failures when I started ofbiz >> again, so I erased the ofbiz directory and did a new installation, but >> didn't do the ant run-install because I was using an postgres db with the >> demo data and some other data that I wanted to keep. Should I still do >> an >> ant run-install? >> >> thanks for your help. >> >> >> Jacopo Cappellato wrote: >>> 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 <[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#a13649994 Sent from the OFBiz - User mailing list archive at Nabble.com.
