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
