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#createShipmentForFacilityAndShipGroup]
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()][lastTimeZone,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()][successiveFailedLogins,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,2007-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,2007-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'.))))]
