NewShipmenrOrder & QuickShipmentOrder Problems

[Baga Raj]

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`))))))]

[cjhowe]

You tried to update a constrained statusId field with the value "RAJA".
 If you wish to use this as a statusId, there needs to be an entry in
the Status entity with statusId = RAJA


--- Baga  Raj <[hidden email]> wrote:

> 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`))))))]
>
>
>

[G.Venkata Phanindra]

Hi,
      Please check did u enable Odbc section configuration in entity
engine.xml file...please try it
One more is in store settings u may have   to enable the invertory
configurations.
cheers
Phani


On 15 Feb 2007 05:54:44 -0000, Baga Raj <[hidden email]> wrote:

>
> 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`))))))]
>
>
>

--
G.Venkata Phanindra
Mob:: [phone]