You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Dave Tenerowicz <dt...@salmonllc.com> on 2007/08/09 19:33:39 UTC
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
dtenerowicz@salmonllc.com
Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330
Visit us at http://www.salmonllc.com
Re: changing default currency
Posted by guo weizhan <gu...@gmail.com>.
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 <ca...@yahoo.com>:
> how do I change the default currency?
>
> cheers,
> kurtis.
>
>
>
> Dave Tenerowicz <dt...@salmonllc.com> 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
> dtenerowicz@salmonllc.com
>
> 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.
Re: QuickShipOrder errors
Posted by Dave Tenerowicz <dt...@salmonllc.com>.
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" <dt...@salmonllc.com>
> À : <us...@ofbiz.apache.org>
> 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
>> dtenerowicz@salmonllc.com
>>
>> Office: 303.493.6727
>> Mobile 303.906.6116
>> Fax 303.814.8330
>>
>> Visit us at http://www.salmonllc.com
>>
>>
>>
>
>
>
>
--
Dave Tenerowicz
dtenerowicz@salmonllc.com
Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330
Visit us at http://www.salmonllc.com
Re: QuickShipOrder errors
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <dt...@salmonllc.com>
À : <us...@ofbiz.apache.org>
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
> dtenerowicz@salmonllc.com
>
> Office: 303.493.6727
> Mobile 303.906.6116
> Fax 303.814.8330
>
> Visit us at http://www.salmonllc.com
>
>
changing default currency
Posted by kurtis shipp <ca...@yahoo.com>.
how do I change the default currency?
cheers,
kurtis.
Dave Tenerowicz <dt...@salmonllc.com> 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
dtenerowicz@salmonllc.com
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.
Re: QuickShipOrder errors
Posted by Dave Tenerowicz <dt...@salmonllc.com>.
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
dtenerowicz@salmonllc.com
Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330
Visit us at http://www.salmonllc.com
Re: QuickShipOrder errors
Posted by Dave Tenerowicz <dt...@salmonllc.com>.
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
dtenerowicz@salmonllc.com
Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330
Visit us at http://www.salmonllc.com
Re: QuickShipOrder errors
Posted by David E Jones <jo...@hotwaxmedia.com>.
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'.))))]
>>>
>>
>>
>
Re: QuickShipOrder errors
Posted by Dave Tenerowicz <dt...@salmonllc.com>.
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
dtenerowicz@salmonllc.com
Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330
Visit us at http://www.salmonllc.com
Re: QuickShipOrder errors
Posted by David E Jones <jo...@hotwaxmedia.com>.
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'.))))]
>