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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0008915
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] F. Localizationmajorhave not tried2009-05-05 17:242012-05-25 12:09
ReporterplujanView Statuspublic 
Assigned Tovmromanos 
PrioritynormalResolutionfixedFixed in Version3.0MP12
StatusclosedFix in branchFixed in SCM revision588bdc741142
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionmainSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008915: Organization's error message when using Spanish is still in English

DescriptionI tried to "set as ready" an Org with no valid data using Spanish, and I got this message (in english):

Error:
Every organization where transactions are possible must have one and only one ancestor (including itself) that is a legal entity
Steps To ReproduceInstall the Spansih Localization Pack
Use Spanish as Language
Create a new client
Create a new Org type generic
try to set it as ready
Tags250mp2, OB3-Reviewed, VMA-Reviewed
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 0012599 closednaiaramartinez Find and fix all RAISE_APPLICATION_ERROR with first parameter not being -20000 

-  Notes
(0016071)
shuehner (administrator)
2009-05-05 20:21

 Tested: on postgres this message will always appear in english. When using oracle translation is possible (What is shown depends on, if this error message has been translated or not).

Problem is that the code uses:
RAISE_APPLICATION_ERROR(-20540, 'Every organization where transactions are possible must have one and only one ancestor (including itself) that is a legal entity');
where oracle looks up the 20540 entry in AD_MESSAGE and postgres only displays the text in this statement. As the text does not contain any @ markers no translation is done for postgres.

Two possibilities:
a.) Fix openbravo postgres translation to work around the missing number in raise-statements (not a trivial task)
b.) Fix all raise_statements using number codes not equal to 20000 and put the respectice @marker@ in the text.
(0045217)
vmromanos (manager)
2012-02-17 09:31

 It will be fixed with 0012599
(0048331)
hgbot (developer)
2012-05-03 13:26

 Repository: erp/devel/pi
Changeset: 588bdc7411427aa642d75ec18d0abdb641143a6e
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Mon Apr 02 16:48:45 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/588bdc7411427aa642d75ec18d0abdb641143a6e [^]

Fixed bug 12599, Fixed bug 8915 RAISE_APPLICATION_ERROR set first parameter -20000

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_C_BANKSTATEMENT_TRG.xml
M modules/org.openbravo.client.application/src-db/database/model/triggers/OBUIAPP_VIEW_IMPL_TRG.xml
M modules/org.openbravo.service.datasource/src-db/database/model/triggers/OBSERDS_DATASOURCE_FIELD_TRG.xml
M modules/org.openbravo.service.datasource/src-db/database/model/triggers/OBSERDS_DATASOURCE_TRG.xml
M modules/org.openbravo.userinterface.selector/src-db/database/model/triggers/OBUISEL_SELECTOR_FIELD_TRG.xml
M modules/org.openbravo.userinterface.selector/src-db/database/model/triggers/OBUISEL_SELECTOR_TRG.xml
M src-db/database/model/functions/AD_ORG_READY.xml
M src-db/database/model/functions/AD_TAB_IMPORT.xml
M src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml
M src-db/database/model/functions/C_INVOICELINETAX_INSERT.xml
M src-db/database/model/functions/C_INVOICE_POST.xml
M src-db/database/model/functions/C_ORDERLINETAX_INSERT.xml
M src-db/database/model/functions/C_ORDER_POST1.xml
M src-db/database/model/functions/C_REMITTANCE_POST.xml
M src-db/database/model/functions/C_SETTLEMENT_POST.xml
M src-db/database/model/functions/C_TAXPAYMENT_POST.xml
M src-db/database/model/functions/M_PRICELIST_CREATE.xml
M src-db/database/model/triggers/AD_ACCOUNTINGRPT_ELEMENT_TRG.xml
M src-db/database/model/triggers/AD_ALERTRECIPIENT_TRG.xml
M src-db/database/model/triggers/AD_AUXILIARINPUT_MOD_TRG.xml
M src-db/database/model/triggers/AD_AUXILIARINPUT_TRG.xml
M src-db/database/model/triggers/AD_CALLOUT_MOD_TRG.xml
M src-db/database/model/triggers/AD_COLUMN_MOD_TRG.xml
M src-db/database/model/triggers/AD_DATASET_COLUMN_MOD_TRG.xml
M src-db/database/model/triggers/AD_DATASET_MOD_TRG.xml
M src-db/database/model/triggers/AD_DATASET_TABLE_MOD_TRG.xml
M src-db/database/model/triggers/AD_ELEMENT_MOD_TRG.xml
M src-db/database/model/triggers/AD_FIELDGROUP_MOD_TRG.xml
M src-db/database/model/triggers/AD_FIELD_MOD_TRG.xml
M src-db/database/model/triggers/AD_FORM_MOD_TRG.xml
M src-db/database/model/triggers/AD_MENU_MOD_TRG.xml
M src-db/database/model/triggers/AD_MENU_TRG.xml
M src-db/database/model/triggers/AD_MESSAGE_MOD_TRG.xml
M src-db/database/model/triggers/AD_MESSAGE_TRG.xml
M src-db/database/model/triggers/AD_MODULE_DBPREFIX_MOD_TRG.xml
M src-db/database/model/triggers/AD_MODULE_DBPREFIX_TRG.xml
M src-db/database/model/triggers/AD_MODULE_DENPENDENCY_TRG.xml
M src-db/database/model/triggers/AD_MODULE_TRG.xml
M src-db/database/model/triggers/AD_MODULE_VERSION_TRG.xml
M src-db/database/model/triggers/AD_ORGTYPE_TRG.xml
M src-db/database/model/triggers/AD_ORG_ACCTSCHEMA_TRG.xml
M src-db/database/model/triggers/AD_ORG_TRG.xml
M src-db/database/model/triggers/AD_PACKAGE_JP_TRG.xml
M src-db/database/model/triggers/AD_PACKAGE_MOD_TRG.xml
M src-db/database/model/triggers/AD_PROCESS_MOD_TRG.xml
M src-db/database/model/triggers/AD_PROCESS_PARA_MOD_TRG.xml
M src-db/database/model/triggers/AD_REFERENCE_MOD_TRG.xml
M src-db/database/model/triggers/AD_REF_LIST_MOD_TRG.xml
M src-db/database/model/triggers/AD_REF_SEARCH_COLUMN_MOD_TRG.xml
M src-db/database/model/triggers/AD_REF_SEARCH_MOD_TRG.xml
M src-db/database/model/triggers/AD_REF_TABLE_MOD_TRG.xml
M src-db/database/model/triggers/AD_REGISTRATION_INFO_TRG.xml
M src-db/database/model/triggers/AD_SYSTEM_INFO_TRG.xml
M src-db/database/model/triggers/AD_SYSTEM_INFO_TRG2.xml
M src-db/database/model/triggers/AD_TABLE_MOD_TRG.xml
M src-db/database/model/triggers/AD_TABLE_TRG.xml
M src-db/database/model/triggers/AD_TAB_MOD_TRG.xml
M src-db/database/model/triggers/AD_TEXTINTERFACES_MOD_TRG.xml
M src-db/database/model/triggers/AD_TREENODE_MOD_TRG.xml
M src-db/database/model/triggers/AD_TREENODE_TRG.xml
M src-db/database/model/triggers/AD_VAL_RULE_MOD_TRG.xml
M src-db/database/model/triggers/AD_WINDOW_MOD_TRG.xml
M src-db/database/model/triggers/A_AMORTIZATIONLINE_TRG.xml
M src-db/database/model/triggers/A_AMORTIZATION_TRG.xml
M src-db/database/model/triggers/A_ASSET_TRG.xml
M src-db/database/model/triggers/C_BANKACCOUNTIBAN_TRG.xml
M src-db/database/model/triggers/C_BANKCOUNTRY_TRG.xml
M src-db/database/model/triggers/C_BANKSTATEMENTLINE_TRG.xml
M src-db/database/model/triggers/C_BANKSTATEMENT_TRG.xml
M src-db/database/model/triggers/C_BPARTNER_TRG.xml
M src-db/database/model/triggers/C_BP_BANKACCOUNTIBAN_TRG.xml
M src-db/database/model/triggers/C_BP_SALCATEGORY_TRG.xml
M src-db/database/model/triggers/C_BSTMTLINE_CHK_RESTRICT_TRG.xml
M src-db/database/model/triggers/C_BSTMT_CHK_RESTRICTIONS_TRG.xml
M src-db/database/model/triggers/C_BUDGETLINE_TRG.xml
M src-db/database/model/triggers/C_CASHLINE_CHK_RESTRICT_TRG.xml
M src-db/database/model/triggers/C_CASHLINE_TRG.xml
M src-db/database/model/triggers/C_CASH_CHK_RESTRICTIONS_TRG.xml
M src-db/database/model/triggers/C_CONVERSION_RATE_DOCUMENT_TRG.xml
M src-db/database/model/triggers/C_CONVERSION_RATE_TRG.xml
M src-db/database/model/triggers/C_CONVERSION_RATE_TRG2.xml
M src-db/database/model/triggers/C_DEBT_PAYMENT_BAL_TRG.xml
M src-db/database/model/triggers/C_DEBT_PAYMENT_TRG.xml
M src-db/database/model/triggers/C_DPMLINE_CHK_RESTRICTIONS_TRG.xml
M src-db/database/model/triggers/C_DP_MANAGEMENT_CHK_RESTR_TRG.xml
M src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml
M src-db/database/model/triggers/C_INVLINE_CHK_RESTRICTIONS_TRG.xml
M src-db/database/model/triggers/C_INVOICEDISCOUNT_TRG.xml
M src-db/database/model/triggers/C_INVOICELINE_TRG.xml
M src-db/database/model/triggers/C_INVOICETAX_TRG.xml
M src-db/database/model/triggers/C_INVOICE_TRG.xml
M src-db/database/model/triggers/C_INVTAX_CHK_RESTRICTIONS_TRG.xml
M src-db/database/model/triggers/C_LOCATION_TRG.xml
M src-db/database/model/triggers/C_ORDERDISCOUNT_TRG.xml
M src-db/database/model/triggers/C_ORDERLINE_TRG.xml
M src-db/database/model/triggers/C_ORDERTAX_TRG.xml
M src-db/database/model/triggers/C_ORDER_CHK_RESTRINCTIONS_TRG.xml
M src-db/database/model/triggers/C_ORDER_TRG.xml
M src-db/database/model/triggers/C_ORDLINE_CHK_RESTRICTIONS_TRG.xml
M src-db/database/model/triggers/C_PROJECT_TRG.xml
M src-db/database/model/triggers/C_REMITTANCELINE_TRG.xml
M src-db/database/model/triggers/C_REMITTANCE_TRG.xml
M src-db/database/model/triggers/C_SALESREGION_TRG.xml
M src-db/database/model/triggers/C_SETTLEMENT_TRG.xml
M src-db/database/model/triggers/C_TAXPAYMENT_TRG.xml
M src-db/database/model/triggers/C_TAXREGISTERLINE_TRG.xml
M src-db/database/model/triggers/C_TAXREGISTER_TRG.xml
M src-db/database/model/triggers/C_TAX_REPORT_TRG.xml
M src-db/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
M src-db/database/model/triggers/GL_JL_CHK_RESTRICTIONS_TRG.xml
M src-db/database/model/triggers/GL_JOURNALLINE_TRG.xml
M src-db/database/model/triggers/GL_JOURNAL_CHK_RESTRICT_TRG.xml
M src-db/database/model/triggers/M_INOUTLINE_TRG.xml
M src-db/database/model/triggers/M_INOUT_CHK_RESTRICTIONS_TRG.xml
M src-db/database/model/triggers/M_INTERNAL_CONSUMPTIONLINE_TRG.xml
M src-db/database/model/triggers/M_INVENTORYLINE_TRG.xml
M src-db/database/model/triggers/M_INVENTORY_TRG.xml
M src-db/database/model/triggers/M_IOLINE_CHK_RESTRICTIONS_TRG.xml
M src-db/database/model/triggers/M_MOVEMENTLINE_TRG.xml
M src-db/database/model/triggers/M_MOVEMENT_TRG.xml
M src-db/database/model/triggers/M_PRODUCTIONLINE_TRG.xml
M src-db/database/model/triggers/M_PRODUCTIONPLAN_TRG.xml
M src-db/database/model/triggers/M_PRODUCTION_TRG.xml
M src-db/database/model/triggers/M_PRODUCT_TRG.xml
M src-db/database/model/triggers/M_REQUISITIONLINE_TRG.xml
M src-db/database/model/triggers/M_REQUISITIONORDER_TRG.xml
M src-db/database/model/triggers/M_REQUISITION_TRG.xml
M src-db/database/model/triggers/M_TRANSACTION_TRG.xml
M src-db/database/model/triggers/S_RESOURCEUNAVAILABLE_TRG.xml
M src-db/database/model/triggers/S_TIMEEXPENSELINE_TRG.xml
M src-db/database/model/triggers/S_TIMEEXPENSE_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0048800)
mirurita (developer)
2012-05-21 13:31

 code review + testing OK

The message is displayed in Spanish: "Cualquier organización con transacciones permitidas debe tener uno y sólo un antecesor (incluyendo ella misma) que sea una entidad legal"
(0049007)
hudsonbot (developer)
2012-05-25 12:09

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5401e185a8b0 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2009-05-05 17:24 plujan New Issue
2009-05-05 17:24 plujan Assigned To => rafaroda
2009-05-05 17:24 plujan Regression testing => No
2009-05-05 20:21 shuehner Note Added: 0016071
2009-05-06 14:05 psarobe Tag Attached: 250mp2
2009-05-06 14:06 psarobe Status new => scheduled
2009-05-06 14:06 psarobe Assigned To rafaroda => vmromanos
2009-05-06 14:06 psarobe fix_in_branch => pi
2009-05-06 14:06 psarobe Severity minor => major
2009-05-06 14:06 psarobe fix_in_branch pi =>
2011-10-28 12:30 psarobe Tag Attached: OB3-Reviewed
2012-02-17 09:29 vmromanos Relationship added related to 0012599
2012-02-17 09:30 vmromanos Tag Attached: VMA-Reviewed
2012-02-17 09:30 vmromanos Relationship deleted related to 0012599
2012-02-17 09:30 vmromanos Relationship added depends on 0012599
2012-02-17 09:31 vmromanos Note Added: 0045217
2012-05-03 13:26 hgbot Checkin
2012-05-03 13:26 hgbot Note Added: 0048331
2012-05-03 13:26 hgbot Status scheduled => resolved
2012-05-03 13:26 hgbot Resolution open => fixed
2012-05-03 13:26 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/588bdc7411427aa642d75ec18d0abdb641143a6e [^]
2012-05-21 13:31 mirurita Note Added: 0048800
2012-05-21 13:31 mirurita Status resolved => closed
2012-05-21 13:31 mirurita Fixed in Version => 3.0MP12
2012-05-25 12:09 hudsonbot Checkin
2012-05-25 12:09 hudsonbot Note Added: 0049007

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker