OFBiz › OFBiz - User

QuickShipOrder errors

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

10 messages Options

Dave Tenerowicz

QuickShipOrder errors

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
[hidden email]

Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330

Visit us at http://www.salmonllc.com

David E Jones

Re: QuickShipOrder errors

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

Re: QuickShipOrder errors

Using the latest revision from trunk.

ParytAcctgPreferences for Company are:
invoiceSequenceEnumId =INVSQ_ENF_SEQ
invoiceIdPrefix =CI
lastInvoiceNumber = 0
useInvoiceIdForReturns = "null"

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
[hidden email]

Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330

Visit us at http://www.salmonllc.com

David E Jones

Re: QuickShipOrder errors

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

Re: QuickShipOrder errors

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
[hidden email]

Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330

Visit us at http://www.salmonllc.com

Dave Tenerowicz

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#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
[hidden email]

Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330

Visit us at http://www.salmonllc.com

kurtis shipp

changing default currency

how do I change the default currency?

cheers,
kurtis.

Dave Tenerowicz <[hidden email]> wrote:
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:

--
Dave Tenerowicz
[hidden email]

Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330

Visit us at http://www.salmonllc.com

---------------------------------
Be a better Globetrotter. Get better travel answers from someone who knows.
Yahoo! Answers - Check it out.

guo weizhan

Re: changing default currency

if you want to change the store currency you can change it in the
stroe preference. and there is currency.uom.id.default in
general.properties, you can change this too.

2007/8/10, kurtis shipp <[hidden email]>:

> how do I change the default currency?
>
> cheers,
> kurtis.
>
>
>
> Dave Tenerowicz <[hidden email]> wrote:
> 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
> [hidden email]
>
> Office: 303.493.6727
> Mobile 303.906.6116
> Fax 303.814.8330
>
> Visit us at http://www.salmonllc.com
>
>
>
>
> ---------------------------------
> Be a better Globetrotter. Get better travel answers from someone who knows.
> Yahoo! Answers - Check it out.

Jacques Le Roux

Re: QuickShipOrder errors

Administrator

In reply to this post by Dave Tenerowicz

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" <[hidden email]>
À : <[hidden email]>
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
> [hidden email]
>
> Office: 303.493.6727
> Mobile 303.906.6116
> Fax 303.814.8330
>
> Visit us at http://www.salmonllc.com
>
>

Dave Tenerowicz

Re: QuickShipOrder errors

That was it ! Setting an appropriate value for lastInvoiceNumber
resolved the issue.
Thanks very much Jacques.
-Dave

Jacques Le Roux wrote:

> 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" <[hidden email]>
> À : <[hidden email]>
> 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
>> [hidden email]
>>
>> Office: 303.493.6727
>> Mobile 303.906.6116
>> Fax 303.814.8330
>>
>> Visit us at http://www.salmonllc.com
>>
>>
>>
>
>
>
>

--
Dave Tenerowicz
[hidden email]

Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330

Visit us at http://www.salmonllc.com