Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011572Openbravo ERPA. Platformpublic2009-12-01 13:352011-08-01 14:19
Reportermarvintm 
Assigned Toshuehner 
PriorityurgentSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP2Fixed in Version 
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
Summary0011572: Constraint error text parser on Postgres doesn't work with Spanish translated PostgreSQL
DescriptionThe constraint error text parser doesn't work on Spanish translated PostgreSQL. For example, this error message is not parsed correctly:

ERROR: llave duplicada viola restricción de unicidad «ad_message_value_un»

The problem is the different quotes that the Spanish message uses: "<< >>".
Steps To ReproduceJust add a new message entry in the application, in Postgre. The standard constraint error will be shown, instead of the Openbravo customized, "nice" one.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00176302.50MP32 closed shuehner Constraint error text parser on Postgres doesn't work with Spanish translated PostgreSQL 
has duplicate defect 0017933 closed eduardo_Argal System does not provide an intuitive warning message in the case of not entering ledger accounts in case of BS posting 
related to design defect 0033940 new Triage Platform Base [SERQA 1558 ]When Postgres database is configured in French the unique message is not found in Openbravo's ad_message 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-01 13:35marvintmNew Issue
2009-12-01 13:35marvintmAssigned To => shuehner
2010-01-05 12:12iciordiaPrioritynormal => urgent
2010-01-05 12:12iciordiaStatusnew => scheduled
2011-03-16 16:52AinhoaPagolaIssue Monitored: AinhoaPagola
2011-06-13 18:32shuehnerStatusscheduled => feedback
2011-06-13 18:33shuehnerStatusfeedback => new
2011-06-13 18:33shuehnerTarget Version => 3.0MP2
2011-06-13 18:33shuehnerStatusnew => scheduled
2011-06-13 18:33shuehnerfix_in_branch => pi
2011-07-14 16:12hgbotCheckin
2011-07-14 16:12hgbotNote Added: 0039066
2011-07-14 16:12hgbotStatusscheduled => resolved
2011-07-14 16:12hgbotResolutionopen => fixed
2011-07-14 16:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5ba902b0d15e0a5aa5b3edc520feb1e6b2ce2a7c [^]
2011-07-15 18:23marvintmStatusresolved => closed
2011-08-01 14:19hudsonbotCheckin
2011-08-01 14:19hudsonbotNote Added: 0039596
2012-03-15 16:45eduardo_ArgalRelationship addedhas duplicate 0017933
2016-09-12 15:50shuehnerRelationship addedrelated to 0033940

Notes
(0039066)
hgbot   
2011-07-14 16:12   
Repository: erp/devel/pi
Changeset: 5ba902b0d15e0a5aa5b3edc520feb1e6b2ce2a7c
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Jul 14 16:12:08 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5ba902b0d15e0a5aa5b3edc520feb1e6b2ce2a7c [^]

Fixed 11572: Allow «» also as separators when searching for constraint name
Spanish translation of pgsql error messages uses «» instead of "" as quotes
around the columnname. Add that case to error text parser for postgres to be
able to find the constraint name and show a nicer error message. Also add
unit test for this. As language config of db is normally not in spanish that
added test just passes in known string into errror text-parser and does not
really test db-action vs. expected message like the other testcases.

---
M src-test/org/openbravo/test/system/ErrorTextParserTest.java
M src/org/openbravo/erpCommon/utility/ErrorTextParserPOSTGRE.java
---
(0039596)
hudsonbot   
2011-08-01 14:19   
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/cf2afed6e8ef [^]

Maturity status: Test