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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0033940
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. Platformmajoralways2016-09-09 13:002022-02-01 08:09
ReporternaiaramartinezView Statuspublic 
Assigned ToTriage Platform Base 
PriorityurgentResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033940: [SERQA 1558 ]When Postgres database is configured in French the unique message is not found in Openbravo's ad_message

DescriptionWhen creating a record in Openbravo that raises a unique constraint, instead of showing the ad_message it is showing the message raised by the database.

The message that I can see, for example, when creating a user that already exist, is the following:
 Saving failed. ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « ad_user_un_username » Détail : La clé « (username)=(Anthony) » existe déjà.

Please, check the 'ErrorTextParserPOSTGRE' java class to fix this. Stefan has asked to also include some test cases. For more information talk to Stefan.
Steps To Reproduceit is reproducible in French postgres database.
TagsNo tags attached.
Attached Fileslog file icon openbravo.log [^] (6,575 bytes) 2016-09-12 13:24
log file icon postgres.log [^] (545 bytes) 2016-09-12 15:45
diff file icon 33940.diff [^] (1,969 bytes) 2016-09-12 17:32 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00115723.0MP2 closedshuehner Constraint error text parser on Postgres doesn't work with Spanish translated PostgreSQL 
related to defect 0038907 closedcaristu DB errors which several OB messages are not correctly parsed in PG 
related to design defect 0041866 acknowledgedTriage Platform Base Error messages for check constrains are not generated if PosgreSQL is in Spanish 

-  Notes
(0089903)
shuehner (administrator)
2016-09-12 17:33
edited on: 2016-09-12 17:35

Note: Attached patch will NOT fix the issue just adds half fix + a simple junit test which can be used to show the issue.
Testcase also not final as 'expected message would need to be adjusted (after issue is fixed)'

(0090184)
alostale (manager)
2016-09-23 09:07

Moved to design defect.

Proper fix for this issue should add the capability to implement custom db error parsers instead of trying to handle all posible cases in any different language from a central one.

- Issue History
Date Modified Username Field Change
2016-09-09 13:00 naiaramartinez New Issue
2016-09-09 13:00 naiaramartinez Assigned To => AugustoMauch
2016-09-09 13:00 naiaramartinez Modules => Core
2016-09-09 13:00 naiaramartinez Triggers an Emergency Pack => No
2016-09-09 14:53 paul_guiot Resolution time => 1475186400
2016-09-09 14:53 paul_guiot Summary When Postgres database is configured in French the unique message is not found in Openbravo's ad_message => [SERQA 1558 ]When Postgres database is configured in French the unique message is not found in Openbravo's ad_message
2016-09-12 12:47 VictorVillar Assigned To AugustoMauch => platform
2016-09-12 13:04 naiaramartinez Priority normal => urgent
2016-09-12 13:04 naiaramartinez Severity trivial => major
2016-09-12 13:04 naiaramartinez Reproducibility have not tried => always
2016-09-12 13:24 naiaramartinez File Added: openbravo.log
2016-09-12 15:45 naiaramartinez File Added: postgres.log
2016-09-12 15:50 shuehner Relationship added related to 0011572
2016-09-12 17:32 shuehner File Added: 33940.diff
2016-09-12 17:33 shuehner Note Added: 0089903
2016-09-12 17:35 shuehner Note Edited: 0089903 View Revisions
2016-09-23 09:07 alostale Resolution time 1475186400 =>
2016-09-23 09:07 alostale Note Added: 0090184
2016-09-23 09:07 alostale Type defect => design defect
2018-08-02 08:56 alostale Relationship added related to 0038907
2019-09-27 11:20 alostale Relationship added related to 0041866
2022-02-01 08:09 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker