Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035047
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Localization Pack: Spain] Spain Professional Localization Packmajoralways2017-01-24 17:072017-09-27 09:21
Reporterqualitic_operativasView Statuspublic 
Assigned ToTriage Finance 
PriorityhighResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version
OS VersionUbuntu 14.04Database version9.xAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Tongarcia
Regression introduced in release
Summary

0035047: Inventory Amount Update - Process Fails

DescriptionAfter processing the Inventory Amount Update using Spanish Professional Localization Pack, the process fails with the following error:
"Error: name: Value (Inventario de cierre de la Actualización del Valor de Inventario) is too long, it has length 64, the maximum allowed length is 60".

To be able to process the document must change to English Languaje.


Steps To ReproduceWhile using Spanish.

1) Go to: Application ->Warehouse Management -> Transactions -> Inventory Amount Update.

2) Create new document.
3) Create Lines.
4) Press Process button.

TagsNo tags attached.
Attached Filespng file icon error.png [^] (5,935 bytes) 2017-01-24 17:08

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 0032906 closedmarkmm82 Openbravo ERP Cannot process an inventory amount update if the user is logged in with Spanish (Spain) language 

-  Notes
(0093814)
qualitic_tecnico (reporter)
2017-01-25 10:33
edited on: 2017-01-25 10:34

 Message: "Inventario de cierre de la Actualización del Valor de Inventario"

this message is contained in "AD_MESSAGE_TRL_es_ES.xml" of module "org.openbravo.localization.spain.referencedata.translation.es_ES"

...
  <row id="71C5D55B1EE14B2DA165D44220963D84" trl="Y">
    <value column="MsgText" isTrl="Y" original="Inventory Amount Update Closing Inventory">Inventario de cierre de la Actualización del Valor de Inventario</value>
    <value column="MsgTip" isTrl="N" original=""/>
  </row>
...

English message's value column in table AD_MESSAGE is: InvAmtUpdCloseInventory

--value = InvAmtUpdCloseInventory
SELECT * FROM AD_MESSAGE WHERE AD_MESSAGE_ID = '71C5D55B1EE14B2DA165D44220963D84'

Spanish translation's length is 64 chars:

--64
SELECT LENGTH(MSGTEXT) FROM AD_MESSAGE_TRL WHERE AD_MESSAGE_ID = '71C5D55B1EE14B2DA165D44220963D84'

This message is used in class org.openbravo.costing.InventoryAmountUpdateProcess
at line:

closeInv.setName(OBMessageUtils.messageBD("InvAmtUpdCloseInventory"));

closeInv is an InventoryCount object and refers to M_INVENTORY table.

So basically the application it's trying to insert in column "name" of table M_INVENTORY that's defined as varchar(60) a value of 64 characters.

I suggest increasing name column's length to something more fitting.

- Issue History
Date Modified Username Field Change
2017-01-24 17:07 qualitic_operativas New Issue
2017-01-24 17:07 qualitic_operativas Assigned To => Triage Finance
2017-01-24 17:08 qualitic_operativas File Added: error.png
2017-01-24 17:09 qualitic_operativas Issue Monitored: qualitic_operativas
2017-01-25 09:57 qualitic_tecnico Issue Monitored: qualitic_tecnico
2017-01-25 10:33 qualitic_tecnico Note Added: 0093814
2017-01-25 10:34 qualitic_tecnico Note Edited: 0093814 View Revisions
2017-09-27 09:21 ngarcia Review Assigned To => ngarcia
2017-09-27 09:21 ngarcia Relationship added duplicate of 0032906
2017-09-27 09:21 ngarcia Status new => closed
2017-09-27 09:21 ngarcia Resolution open => duplicate

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker