Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008915Openbravo ERPF. Localizationpublic2009-05-05 17:242012-05-25 12:09
Reporterplujan 
Assigned Tovmromanos 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionmain 
Target VersionFixed in Version3.0MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008915: 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
Proposed Solution
Additional Information
Tags250mp2, OB3-Reviewed, VMA-Reviewed
Relationships
depends on defect 0012599 closed naiaramartinez Find and fix all RAISE_APPLICATION_ERROR with first parameter not being -20000 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-05-05 17:24plujanNew Issue
2009-05-05 17:24plujanAssigned To => rafaroda
2009-05-05 17:24plujanRegression testing => No
2009-05-05 20:21shuehnerNote Added: 0016071
2009-05-06 14:05psarobeTag Attached: 250mp2
2009-05-06 14:06psarobeStatusnew => scheduled
2009-05-06 14:06psarobeAssigned Torafaroda => vmromanos
2009-05-06 14:06psarobefix_in_branch => pi
2009-05-06 14:06psarobeSeverityminor => major
2009-05-06 14:06psarobefix_in_branchpi =>
2011-10-28 12:30psarobeTag Attached: OB3-Reviewed
2012-02-17 09:29vmromanosRelationship addedrelated to 0012599
2012-02-17 09:30vmromanosTag Attached: VMA-Reviewed
2012-02-17 09:30vmromanosRelationship deletedrelated to 0012599
2012-02-17 09:30vmromanosRelationship addeddepends on 0012599
2012-02-17 09:31vmromanosNote Added: 0045217
2012-05-03 13:26hgbotCheckin
2012-05-03 13:26hgbotNote Added: 0048331
2012-05-03 13:26hgbotStatusscheduled => resolved
2012-05-03 13:26hgbotResolutionopen => fixed
2012-05-03 13:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/588bdc7411427aa642d75ec18d0abdb641143a6e [^]
2012-05-21 13:31miruritaNote Added: 0048800
2012-05-21 13:31miruritaStatusresolved => closed
2012-05-21 13:31miruritaFixed in Version => 3.0MP12
2012-05-25 12:09hudsonbotCheckin
2012-05-25 12:09hudsonbotNote Added: 0049007

Notes
(0016071)
shuehner   
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   
2012-02-17 09:31   
It will be fixed with 0012599
(0048331)
hgbot   
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   
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   
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