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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0041866
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] B. User interfaceminorsometimes2019-09-23 12:312022-02-01 08:07
ReporteradrianromeroView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava 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

0041866: Error messages for check constrains are not generated if PosgreSQL is in Spanish

DescriptionHaving configured PostgreSQL in Spanish, and with a Check Constraint with its corresponding message in AD_MESSAGE. For example Check Constraint "EM_RTP_APP_FISCAL_CFG" with message "Fiscal touchpoints must define a RT Printer to handle receipts fiscalization."

If in the user interface the user tries to store a record that violates that constraint the error that appears is "ERROR: el nuevo registro para la relación «obpos_applications» viola la restricción «check» «em_rtp_app_fiscal_cfg»
  Detail: La fila que falla contiene (6A93C7FD23B84..." The database error.

If PostgreSQL is configured in English the right message appears. "Fiscal touchpoints must define a RT Printer to handle receipts fiscalization.". In English the database message is like "ERROR: new row for relation "obpos_applications" violates check constraint "em_rtp_app_fiscal_cfg"
  Detail: Failing row contains (6A93C7FD23B84..."

The problem is located in function ErrorTextParserPOSTGRE.findConstraintName() https://code.openbravo.com/erp/devel/pi/file/tip/src/org/openbravo/erpCommon/utility/ErrorTextParserPOSTGRE.java#l83 [^] that returns in Postgresql "check" instead of "em_rtp_app_fiscal_cfg".

Steps To ReproduceIn description
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to design defect 0033940 newTriage Platform Base [SERQA 1558 ]When Postgres database is configured in French the unique message is not found in Openbravo's ad_message 
has duplicate defect 0043205 closedplatform Check constraint message is not shown sometimes 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2019-09-23 12:31 adrianromero New Issue
2019-09-23 12:31 adrianromero Assigned To => platform
2019-09-23 12:31 adrianromero Modules => Core
2019-09-23 12:31 adrianromero Triggers an Emergency Pack => No
2019-09-23 13:37 adrianromero Description Updated View Revisions
2019-09-27 11:20 alostale Relationship added related to 0033940
2019-09-27 11:20 alostale Type defect => design defect
2020-02-13 11:34 alostale Status new => acknowledged
2020-02-13 11:36 alostale Relationship added has duplicate 0043205
2022-02-01 08:07 alostale Assigned To platform => Triage Platform Base

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker