0038827: Some trigger error messages are not shown nicely when using PostgreSQL version 10 (shows part of technical error)

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0038827

Openbravo ERP

A. Platform

public

2018-06-25 14:00

2023-07-21 09:07

Reporter

shuehner

Assigned To

caristu

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

3.0PR18Q3

Merge Request Status

Review Assigned To

AugustoMauch

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0038827: Some trigger error messages are not shown nicely when using PostgreSQL version 10 (shows part of technical error)

Description

When a database transaction throws an exception the ErrorTextParser class tries to parse it and translates it into a usable end-user message and shows that instead.

That parsing fails with pg10 and parts of the technical exception is shown mixed with the translated message.

When fixing the issue the existing unit tests (in ErrorTextParserTest class) for the parser should get a new test-case to cover the fix.

Steps To Reproduce

Start with instance having 18Q3 (or at least pi containing those)
Important: Have project to 'reject setting a module in development' when instance purpose is 'Production'.

Change Role to System Administrator
Set instance purpose to 'Production'
Go to module window
Edit entry to 'core' module and mark 'In Development' as active.
Save the edited record.

Expected error message:
Saving failed. Cannot have modules in "In Development" status in a Production instance

Actual error message when using postgresql version10.
Saving failed. Cannot have modules in "In Development" status in a Production instance Where: PL/pgSQL function ad_module_trg() line 33 at RAISE

Here part of the 'Stacktrace' of the error message comes up in the translated text.

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	feature request	0036911		closed	alostale	support PostgreSQL 10
depends on	backport	0038829	3.0PR18Q2.2	closed	caristu	Some trigger error messages are not shown nicely when using PostgreSQL version 10 (shows part of technical error)
causes	defect	0038907		closed	caristu	DB errors which several OB messages are not correctly parsed in PG