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:07:14 UTC
[jira] Created: (OFBIZ-177) Shipments cannont be packed when using
a language other than English
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
[jira] Commented: (OFBIZ-177) Shipments cannont be packed when
using a language other than English
Posted by "Ricardo Chavez (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OFBIZ-177?page=comments#action_12430036 ]
Ricardo Chavez commented on OFBIZ-177:
--------------------------------------
Thanks for the information.
Jacopo: yes, I'm running the package creation from the Shipment -> Items screen but, in my case, the line you are pointing does not have the 'value' attribute set in the 'option' tag. I'm running the stable version of OFBiz (0.9.1), so maybe the bug is already fixed in one of the most recent weekly builds; if that's the case, I apologize for the inconvenience.
Thanks again.
> 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
> Assigned To: Jacopo Cappellato
>
> 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
[jira] Commented: (OFBIZ-177) Shipments cannont be packed when
using a language other than English
Posted by "Rodrigo Aguinaga (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OFBIZ-177?page=comments#action_12429904 ]
Rodrigo Aguinaga commented on OFBIZ-177:
----------------------------------------
Hi Ricardo,
About how can you submit your changes for them to be integrated to the weekly build there are a couple pages that you can visit.
http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Contributors+Best+Practices, here you can find all the information you need about how to submit your changes, how to access the svn, and how to send your changes ( you can actually upload the patch file here, that way the asignee person can take a look to it before submitting )
If you don't use a svn system you can take a look to this
Install Subversion (svn) plugin in Eclipse aka Subclipse : http://subclipse.tigris.org/
Link to the repository with Subclipse help : http://incubator.apache.org/ofbiz/svn.html
You can also use other free software like TortoiseSVN!
Regards
Rodrigo
PS. I've read you are using the spanish translation of ofbiz, please let me know if you find mistakes on it, actually there are not many people that have use this translation since is brand newm so it would be a good feedback!
> 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
> Assigned To: Jacopo Cappellato
>
> 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
[jira] Assigned: (OFBIZ-177) Shipments cannont be packed when using
a language other than English
Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OFBIZ-177?page=all ]
Jacopo Cappellato reassigned OFBIZ-177:
---------------------------------------
Assignee: Jacopo Cappellato
> 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
> Assigned To: Jacopo Cappellato
>
> 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
[jira] Commented: (OFBIZ-177) Shipments cannont be packed when
using a language other than English
Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OFBIZ-177?page=comments#action_12429906 ]
Jacopo Cappellato commented on OFBIZ-177:
-----------------------------------------
About the weekly build question: if you'll attach a patch to this Jira issue and it will be committed to svn, then it will be in the next weekly build.
> 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
> Assigned To: Jacopo Cappellato
>
> 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
[jira] Closed: (OFBIZ-177) Shipments cannont be packed when using a
language other than English
Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OFBIZ-177?page=all ]
Jacopo Cappellato closed OFBIZ-177.
-----------------------------------
Resolution: Fixed
Ricardo,
yes this has been probably fixed after that version of Opentaps has been released; I'm going to close this issue but I'm sure that it will not be ignored by Si Chen (that is also the maintainer of the Opentaps project).
> 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
> Assigned To: Jacopo Cappellato
>
> 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
[jira] Commented: (OFBIZ-177) Shipments cannont be packed when
using a language other than English
Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OFBIZ-177?page=comments#action_12429905 ]
Jacopo Cappellato commented on OFBIZ-177:
-----------------------------------------
Hi Ricardo,
your guess is interesting but I'm not sure that the problem is there.
In fact, the "New" value is set in line 82 of product/webapp/facility/shipment/EditShipmentItems.ftl:
<option value="New">${uiLabelMap.CommonNew}</option><!-- Warning: the "New" value cannot be translated because it is used in secas -->
As you can see the option's label is translated, not the option's value.
Are you running the package creation from the Shipment->Items screen?
Thanks
> 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
> Assigned To: Jacopo Cappellato
>
> 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
[jira] Commented: (OFBIZ-177) Shipments cannont be packed when
using a language other than English
Posted by "Ricardo Chavez (JIRA)" <ji...@apache.org>.
[ 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