Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0041866Openbravo ERPB. User interfacepublic2019-09-23 12:312022-02-01 08:07
adrianromero 
Triage Platform Base 
normalminorsometimes
acknowledgedopen 
5
 
 
Core
No
0041866: Error messages for check constrains are not generated if PosgreSQL is in Spanish
Having 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".

In description
No tags attached.
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 
has duplicate defect 0043205 closed platform Check constraint message is not shown sometimes 
Issue History
2019-09-23 12:31adrianromeroNew Issue
2019-09-23 12:31adrianromeroAssigned To => platform
2019-09-23 12:31adrianromeroModules => Core
2019-09-23 12:31adrianromeroTriggers an Emergency Pack => No
2019-09-23 13:37adrianromeroDescription Updatedbug_revision_view_page.php?rev_id=19397#r19397
2019-09-27 11:20alostaleRelationship addedrelated to 0033940
2019-09-27 11:20alostaleTypedefect => design defect
2020-02-13 11:34alostaleStatusnew => acknowledged
2020-02-13 11:36alostaleRelationship addedhas duplicate 0043205
2022-02-01 08:07alostaleAssigned Toplatform => Triage Platform Base

There are no notes attached to this issue.