Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007729Openbravo ERP00. Application dictionarypublic2009-02-18 10:232009-03-05 17:05
ReporterDowid 
Assigned Toshuehner 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS10OS VersionSP2
Product Versionpi 
Target VersionFixed in Version2.40MP3 
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
Summary0007729: AD_MESSAGE with the search key that matches constraint name doesn't work in Postgres
DescriptionApplication Dictionary->Message
 
When creating an error message that is related to a contraint in the database, the OBError displays this message in Oracle but does not display the message in Postgres.
Steps To Reproduce1. Go to Application Dictionary->Message
2. Search meassage with Search key "AD_USER_UN_USERNAME". Message related to thise constraint "Already exists a user with the same User name . Input a different one"

3. Test this message in Oracle and Postgres. Please follow steps in [1]

Note that this message is displayed correctly in Oracle, and incorrectly in Postgres. Furthermore, this behavior is true for all errors that are related to contraints in the Postgres, but works in Oracle.
 

[1] https://issues.openbravo.com/view.php?id=6989 [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0007618 closed shuehner AD_MESSAGE with the search key that matches constraint name doesn't work in Postgres 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-20 17:29shuehnerTypedefect => backport
2009-02-20 17:29shuehnerfix_in_branch => 2.40
2009-02-20 17:31svnbotCheckin
2009-02-20 17:31svnbotNote Added: 0013859
2009-02-20 17:31svnbotStatusscheduled => resolved
2009-02-20 17:31svnbotResolutionopen => fixed
2009-02-20 17:31svnbotsvn_revision => 13481
2009-03-03 17:31psarobeFixed in Version => 2.40MP3
2009-03-05 17:05psarobeStatusresolved => closed

Notes
(0013859)
svnbot   
2009-02-20 17:31   
Repository: openbravo
Revision: 13481
Author: huehner
Date: 2009-02-20 17:31:28 +0100 (Fri, 20 Feb 2009)

Fixed 7729
Fix parsing of postgres error messages so that ad_message entries for a specific
constraint violation are correctly found

---
U branches/r2.40/src/org/openbravo/erpCommon/utility/ErrorTextParserPOSTGRE.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=13481&sc=1 [^]