Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035047Localization Pack: SpainSpain Professional Localization Packpublic2017-01-24 17:072017-09-27 09:21
Reporterqualitic_operativas 
Assigned ToTriage Finance 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS30OS VersionUbuntu 14.04
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Tongarcia
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary0035047: 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.

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0032906 closed markmm82 Openbravo ERP Cannot process an inventory amount update if the user is logged in with Spanish (Spain) language 
Attached Filespng error.png (5,935) 2017-01-24 17:08
https://issues.openbravo.com/file_download.php?file_id=10341&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2017-01-24 17:07qualitic_operativasNew Issue
2017-01-24 17:07qualitic_operativasAssigned To => Triage Finance
2017-01-24 17:08qualitic_operativasFile Added: error.png
2017-01-24 17:09qualitic_operativasIssue Monitored: qualitic_operativas
2017-01-25 09:57qualitic_tecnicoIssue Monitored: qualitic_tecnico
2017-01-25 10:33qualitic_tecnicoNote Added: 0093814
2017-01-25 10:34qualitic_tecnicoNote Edited: 0093814bug_revision_view_page.php?bugnote_id=0093814#r14346
2017-09-27 09:21ngarciaReview Assigned To => ngarcia
2017-09-27 09:21ngarciaRelationship addedduplicate of 0032906
2017-09-27 09:21ngarciaStatusnew => closed
2017-09-27 09:21ngarciaResolutionopen => duplicate

Notes
(0093814)
qualitic_tecnico   
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.