You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Christian Carlow (JIRA)" <ji...@apache.org> on 2013/10/10 23:28:45 UTC
[jira] [Comment Edited] (OFBIZ-5345) Cannot pick or pack shipment
for mutiple sales orders
[ https://issues.apache.org/jira/browse/OFBIZ-5345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13791479#comment-13791479 ]
Christian Carlow edited comment on OFBIZ-5345 at 10/10/13 9:27 PM:
-------------------------------------------------------------------
This second patch will resolve the inventoryItemSeqId primary key violation that results after the first patch is applied and allow for picking and packing of shipments containing order items from more than one order.
was (Author: ofbizzer):
This second patch will resolve the inventoryItemSeqId primary key violation that results after the first patch is applied and allow for picking and packing of shipments containing order items from more than one item.
> Cannot pick or pack shipment for mutiple sales orders
> -----------------------------------------------------
>
> Key: OFBIZ-5345
> URL: https://issues.apache.org/jira/browse/OFBIZ-5345
> Project: OFBiz
> Issue Type: Bug
> Components: order
> Affects Versions: Release Branch 12.04
> Reporter: Christian Carlow
> Attachments: InvoiceServices.java.patch, InvoiceServices.xml.patch
>
>
> I get this error when trying to change the statusId of a shipment to picked or packed:
> Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service invocation error (Could not commit transaction for service [updateShipment] call: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [InvoiceRole]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][createdTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][datetimePerformed,2013-10-09 13:13:57.498(java.sql.Timestamp)][invoiceId,CI6(java.lang.String)][lastUpdatedStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][lastUpdatedTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][roleTypeId,PLACING_CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_invoice_role"<br/> Detail: Key (invoice_id, party_id, role_type_id)=(CI6, DemoCustCompany, PLACING_CUSTOMER) already exists.)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][createdTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][datetimePerformed,2013-10-09 13:13:57.498(java.sql.Timestamp)][invoiceId,CI6(java.lang.String)][lastUpdatedStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][lastUpdatedTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][roleTypeId,PLACING_CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_invoice_role"<br/> Detail: Key (invoice_id, party_id, role_type_id)=(CI6, DemoCustCompany, PLACING_CUSTOMER) already exists.)) (Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][createdTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][datetimePerformed,2013-10-09 13:13:57.498(java.sql.Timestamp)][invoiceId,CI6(java.lang.String)][lastUpdatedStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][lastUpdatedTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][roleTypeId,PLACING_CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_invoice_role"<br/> Detail: Key (invoice_id, party_id, role_type_id)=(CI6, DemoCustCompany, PLACING_CUSTOMER) already exists.))))
> The createInvoiceForOrder service is called for each orderId in createInvoicesFromShipments of InvoiceServices.java but the createInvoiceForOrder calls createInvoiceRole which attempts to insert the OrderRoles associated with the orderId which causes primary key violations.
--
This message was sent by Atlassian JIRA
(v6.1#6144)