I just tried with rev. 564523 without problems. Did you reload the seed and demo data (ant run-install) ? Because of this line
<PartyAcctgPreference partyId="Company" taxFormId="US_IRS_1120" cogsMethodId="COGS_AVG_COST" baseCurrencyUomId="USD" invoiceSequenceEnumId="INVSQ_ENF_SEQ" invoiceIdPrefix="CI" lastInvoiceNumber="000000" quoteSequenceEnumId="INVSQ_ENF_SEQ" quoteIdPrefix="CQ" lastQuoteNumber="000000" orderSequenceEnumId="INVSQ_ENF_SEQ" orderIdPrefix="CO" lastOrderNumber="000000"/> in DemoOrganizationData.xml, if you had already invoices created you would get a conflict (because of see lastInvoiceNumber="000000"). That's why I have commented out this line in my demo server. To fix your problem, edit the ParytAcctgPreferences entity and set lastInvoiceNumber adequatly. This problem does not occur for orders because there is another increment (of 10) on its generated SeqId when you reload OFBiz. Not sure for quotes... Jacques ----- Message d'origine ----- De : "Dave Tenerowicz" <[EMAIL PROTECTED]> À : <[email protected]> Envoyé : jeudi 9 août 2007 23:09 Objet : Re: QuickShipOrder errors > Ok, I read the jira thread, and set a value for lastInvoiceRestartDate > (2007-01-01 00:00:00) > I still get the same error message. Also I am using a version much newer > than the one in which this issue was reported fixed. Is it possible that > this is a new issue? Is anyone else seeing the same error? > > -Dave > > Dave Tenerowicz wrote: > > Rev is 564334. > > > > David E Jones wrote: > >> > >> > >> Dave Tenerowicz wrote: > >>> Using the latest revision from trunk. > >> > >> Specific revision numbers are helpful. Things are changing all the > >> time. Are you saying the rev # is 564187? > >> > >>> ParytAcctgPreferences for Company are: > >>> invoiceSequenceEnumId =INVSQ_ENF_SEQ > >>> invoiceIdPrefix =CI > >>> lastInvoiceNumber = 0 > >>> useInvoiceIdForReturns = "null" > >> > >> There was a recent issue related to this, which is why I asked for > >> these details. I think there may have been comments that some > >> sequencing type may still not work. > >> > >> Hopefully someone who worked on that can comment and help out. You > >> could also try looking up that issue in Jira and related comments on > >> the mailing list (probably the dev list). > >> > >> -David > >> > >> > >>> David E Jones wrote: > >>>> > >>>> Which revision of OFBiz are you using, and what are your invoice ID > >>>> settings on the accounting preference record? > >>>> > >>>> -David > >>>> > >>>> > >>>> Dave Tenerowicz wrote: > >>>>> Hoping someone has seen this one before. > >>>>> In attempting a quick ship operation on an Order (Quick Ship > >>>>> Entire Order from the View Order screen) I receive the following > >>>>> error: > >>>>> Any ideas how to troubleshoot? What is the reference to > >>>>> "SQL070413040729120' defined on 'INVOICE" > >>>>> Many thanks in advance > >>>>> -Dave > >>>>> > >>>>> 2007-08-09 13:24:44,216 (http-0.0.0.0-443-Processor3) [ > >>>>> RequestHandler.java:308:ERROR] Request quickShipOrder caused an > >>>>> error with the following message: ERROR: Could not complete the > >>>>> Sub-method used by quickShip methods to create a shipment > >>>>> [file:/C:/projects/daveonly05032007/applications/product/script/org/ofbiz/shipment/shipment/ShipmentServices.xml#createShipmentForFa cilityAndShipGroup] > >>>>> process [problem invoking the [updateShipment] service with the > >>>>> map named [packedContext] containing [[shipmentId=10060, > >>>>> statusId=SHIPMENT_SHIPPED, > >>>>> userLogin=[GenericEntity:UserLogin][createdStamp,2007-04-13 > >>>>> 16:15:12.422(java.sql.Timestamp)][createdTxStamp,2007-04-13 > >>>>> 16:15:10.25(java.sql.Timestamp)][currentPassword,47ca69ebb4bdc9ae0adec130880165d2cc05db1a(java.lang.String)][disabledDateTime,null() ][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][isSystem,null()][lastCurrencyUom,null()][lastLocale,null()][lastTim eZone,null()][lastUpdatedStamp,2007-08-09 > >>>>> 11:01:15.891(java.sql.Timestamp)][lastUpdatedTxStamp,2007-08-09 > >>>>> 11:01:15.891(java.sql.Timestamp)][partyId,admin(java.lang.String)][passwordHint,null()][requirePasswordChange,null()][successiveFail edLogins,0(java.lang.Long)][userLoginId,admin(java.lang.String)], > >>>>> locale=en_US]]: Problems with the transaction. (Exception while > >>>>> inserting the following entity: > >>>>> [GenericEntity:Invoice][billingAccountId,null()][createdStamp,2007-08-09 > >>>>> 13:24:42.045(java.sql.Timestamp)][createdTxStamp,2007-08-09 > >>>>> 13:24:37.31(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][dueDate,null()][invoiceDate,2007-08-09 > >>>>> 13:24:41.701(java.sql.Timestamp)][invoiceId,CI1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2 007-08-09 > >>>>> 13:24:42.045(java.sql.Timestamp)][lastUpdatedTxStamp,2007-08-09 > >>>>> 13:24:37.31(java.sql.Timestamp)][partyId,DemoCustomer(java.lang.String)][partyIdFrom,Company(java.lang.String)][statusId,INVOICE_IN_ PROCESS(java.lang.String)] > >>>>> (while inserting: > >>>>> [GenericEntity:Invoice][billingAccountId,null()][createdStamp,2007-08-09 > >>>>> 13:24:42.045(java.sql.Timestamp)][createdTxStamp,2007-08-09 > >>>>> 13:24:37.31(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][dueDate,null()][invoiceDate,2007-08-09 > >>>>> 13:24:41.701(java.sql.Timestamp)][invoiceId,CI1(java.lang.String)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2 007-08-09 > >>>>> 13:24:42.045(java.sql.Timestamp)][lastUpdatedTxStamp,2007-08-09 > >>>>> 13:24:37.31(java.sql.Timestamp)][partyId,DemoCustomer(java.lang.String)][partyIdFrom,Company(java.lang.String)][statusId,INVOICE_IN_ PROCESS(java.lang.String)] > >>>>> (SQL Exception while executing the following:INSERT INTO > >>>>> OFBIZ.INVOICE (INVOICE_ID, INVOICE_TYPE_ID, PARTY_ID_FROM, > >>>>> PARTY_ID, ROLE_TYPE_ID, STATUS_ID, BILLING_ACCOUNT_ID, > >>>>> CONTACT_MECH_ID, INVOICE_DATE, DUE_DATE, PAID_DATE, > >>>>> INVOICE_MESSAGE, REFERENCE_NUMBER, DESCRIPTION, CURRENCY_UOM_ID, > >>>>> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > >>>>> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > >>>>> ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have > >>>>> caused a duplicate key value in a unique or primary key constraint > >>>>> or unique index identified by 'SQL070413040729120' defined on > >>>>> 'INVOICE'.))))] > >>>>> > >>>> > >>>> > >>> > >> > >> > > > > -- > Dave Tenerowicz > [EMAIL PROTECTED] > > Office: 303.493.6727 > Mobile 303.906.6116 > Fax 303.814.8330 > > Visit us at http://www.salmonllc.com > >
