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#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'.))))]
--
Dave Tenerowicz
[EMAIL PROTECTED]
Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330
Visit us at http://www.salmonllc.com
