You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Ricardo Chavez (JIRA)" <ji...@apache.org> on 2006/08/22 23:15:15 UTC
[jira] Commented: (OFBIZ-177) Shipments cannont be packed when
using a language other than English
[ http://issues.apache.org/jira/browse/OFBIZ-177?page=comments#action_12429810 ]
Ricardo Chavez commented on OFBIZ-177:
--------------------------------------
sorry for the misspelling... it's 'cannot' instead of 'cannont' :S
> Shipments cannont be packed when using a language other than English
> --------------------------------------------------------------------
>
> Key: OFBIZ-177
> URL: http://issues.apache.org/jira/browse/OFBIZ-177
> Project: OFBiz (The Open for Business Project)
> Issue Type: Bug
> Components: product
> Affects Versions: SVN trunk
> Environment: any
> Reporter: Ricardo Chavez
>
> Hello everybody
> When I try to create packages for a sales shipment (so its status can be set to Packed) and I'm using a language other than English (for example, Spanish), I get the following error:
> * ERROR: Could not complete the Create ShipmentPackageContent [file:/.../ShipmentServices.xml#createShipmentPackageContent] process [problem creating the newEntity value: Exception while inserting the following entity: [GenericEntity:ShipmentPackageContent][createdStamp,2006-08-22 15:54:45.155(java.sql.Timestamp)][createdTxStamp,2006-08-22 15:54:44.764(java.sql.Timestamp)][lastUpdatedStamp,2006-08-22 15:54:45.155(java.sql.Timestamp)][lastUpdatedTxStamp,2006-08-22 15:54:44.764(java.sql.Timestamp)][quantity,100.0(java.lang.Double)][shipmentId,10060(java.lang.String)][shipmentItemSeqId,00001(java.lang.String)][shipmentPackageSeqId,Nuevo(java.lang.String)] (...some repeated information omitted...)
> (SQL Exception while executing the following:INSERT INTO SHIPMENT_PACKAGE_CONTENT (SHIPMENT_ID, SHIPMENT_PACKAGE_SEQ_ID, SHIPMENT_ITEM_SEQ_ID, QUANTITY, SUB_PRODUCT_ID, SUB_PRODUCT_QUANTITY, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Integrity constraint violation - no parent PCK_CNTNT_SHPKG table: SHIPMENT_PACKAGE in statement [INSERT INTO SHIPMENT_PACKAGE_CONTENT ...]
> This error does not happen when working with English. Although this may seem strange, there is a reason (I think): there is a SECA for service createShipmentPackageContent, which calls the createShipmentPackage service only when the shipmentPackageSeqId equals "New". But when using the Spanish transaltion, "New" changes to "Nuevo", and so the createShipmentPackage doesn't get called and the new package is never created; this causes the above error.
> Hope this information is useful.
> -- Ricardo
> p.s.: this seems not too complicated. if I fix it, how can I submit my bugfix so it goes into one of the weekly builds? thanks!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira