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

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #41866		[ Back to Issue ]
Summary	0041866: Error messages for check constrains are not generated if PosgreSQL is in Spanish

Revision	2019-09-23 13:37 by adrianromero
Description	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".

Revision	2019-09-23 12:31 by adrianromero
Description	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 "