Hi all,
I had a Problem in QuichShipOrder and NewShipment Order..
In the NewShipmetOrder i am trying to set the shipment status to Packed
after completing the Issue All Items. It is throwing an error Like:
The Following Errors Occurred:
Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service
invocation error (Commit transaction failed)
But Initially i was the shipment status to Packed means its working fine
and then i tried to Issue all items, and then come back to Setting the
shipment staus to Shipped , finally the order has been completed but the
invoice is not created.
In Quick ShipmentOrder :
I am getting the Error like:
The Following Errors Occurred:
ERROR: Could not complete the Quick ships an entire order from multiple
facilities [quickShipEntireOrder] process [problem invoking the
[updateShipment] service with the map named [packedContext] containing
[{locale=en_US, userLogin=[GenericEntity:UserLogin][createdStamp,2006-01-17
18:26:34.0(java.sql.Timestamp)][createdTxStamp,2006-01-17 18:26:34.0(
java.sql.Timestamp
)][currentPassword,c682529d939a64d68f2b5778b913c059792ca3eb(
java.lang.String)][disabledDateTime,2006-10-25 06:02:57.0(
java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(
java.lang.String
)][isSystem,null()][lastCurrencyUom,null()][lastLocale,en_US(
java.lang.String)][lastUpdatedStamp,2007-02-14 03:27:48.0(
java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-14 03:27:48.0(
java.sql.Timestamp)][partyId,admin(java.lang.String)][passwordHint,time(
java.lang.String)][successiveFailedLogins,0(java.lang.Long
)][userLoginId,admin(java.lang.String)], shipmentId=T10952,
statusId=SHIPMENT_SHIPPED}]: Problems with the transaction. (Exception while
inserting the following entity:
[GenericEntity:Invoice][billingAccountId,null()][createdByUserLogin,admin(
java.lang.String)][createdStamp,2007-02-14
22:46:50.915(java.sql.Timestamp)][createdTxStamp,2007-02-14
22:46:50.79(java.sql.Timestamp)][currencyUomId,CAD(java.lang.String)][invoiceDate,2007-02-14
22:46:50.915(java.sql.Timestamp)][invoiceId,T10892(java.lang.String
)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2007-02-14
22:46:50.915(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-14 22:46:
50.79(java.sql.Timestamp)][partyId,admin(java.lang.String
)][partyIdFrom,Company(java.lang.String)][statusId,RAJA(java.lang.String)]
(while inserting:
[GenericEntity:Invoice][billingAccountId,null()][createdByUserLogin,admin(
java.lang.String)][createdStamp,2007-02-14
22:46:50.915(java.sql.Timestamp)][createdTxStamp,2007-02-14
22:46:50.79(java.sql.Timestamp)][currencyUomId,CAD(java.lang.String)][invoiceDate,2007-02-14
22:46:50.915(java.sql.Timestamp)][invoiceId,T10892(java.lang.String
)][invoiceTypeId,SALES_INVOICE(java.lang.String)][lastUpdatedStamp,2007-02-14
22:46:50.915(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-14 22:46:
50.79(java.sql.Timestamp)][partyId,admin(java.lang.String
)][partyIdFrom,Company(java.lang.String)][statusId,RAJA(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO 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,
INVOICE_MESSAGE, DESCRIPTION, CURRENCY_UOM_ID, IS_INVOICE_SYNCHRONIZED,
CREATED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key
constraint fails (`ofbiz_wss/invoice`, CONSTRAINT `INVOICE_STTSITM` FOREIGN
KEY (`STATUS_ID`) REFERENCES `status_item` (`STATUS_ID`))))))]
