Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0053476Openbravo ERPB. User interfacepublic2023-09-18 16:322023-10-30 10:57
dbaz 
AugustoMauch 
normalminoralways
closedfixed 
5
 
PR24Q1 
approved
No
Core
No
0053476: Activate/Deactivate selected records shows a not user friendly message if something fails.
Activate/Deactivate selected records shows a not user friendly message if something fails.

Error
org.hibernate.exception.GenericJDBCException: could not execute statement

I would expect a human-friendly message if there has been an error trying to update any of the records, and to know at least what has happened with in general with the records (none of them updated, only X of them updated, etc).
In livebuilds, as The White Valley Group Admin
Go to "Product" window
Enter in name "b" to filter products containing a "b". 71 results should be found
Select the 71 records
Click on the Activate/Deactivate button and press "Deactivate Selected Records"

The error described is shown

No tags attached.
Issue History
2023-09-18 16:32dbazNew Issue
2023-09-18 16:32dbazAssigned To => Triage Platform Base
2023-09-18 16:32dbazOBNetwork customer => No
2023-09-18 16:32dbazModules => Core
2023-09-18 16:32dbazTriggers an Emergency Pack => No
2023-09-19 18:23AugustoMauchAssigned ToTriage Platform Base => AugustoMauch
2023-09-19 18:23AugustoMauchStatusnew => scheduled
2023-09-19 18:27hgbotMerge Request Status => open
2023-09-19 18:27hgbotNote Added: 0155009
2023-09-28 09:16hgbotMerge Request Statusopen => approved
2023-10-30 10:57hgbotResolutionopen => fixed
2023-10-30 10:57hgbotStatusscheduled => closed
2023-10-30 10:57hgbotNote Added: 0156483
2023-10-30 10:57hgbotFixed in Version => PR24Q1
2023-10-30 10:57hgbotNote Added: 0156484

Notes
(0155009)
hgbot   
2023-09-19 18:27   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1000 [^]
(0156483)
hgbot   
2023-10-30 10:57   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1000 [^]
(0156484)
hgbot   
2023-10-30 10:57   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: de34fa1f59a2974447f27ae9b3ab781a77ffbed8
Author: Augusto Mauch <augusto.mauch@openbravo.com>
Date: 30-10-2023 10:56:55
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/de34fa1f59a2974447f27ae9b3ab781a77ffbed8 [^]

Fixes ISSUE-53476: Show proper error when there is a problem disabling many records at once

A proper message is now shown. In order to get the underlying sql exception in this flow, DbUtility had to be updated

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/EnableOrDisableMultipleRecords.java
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/service/db/DbUtility.java
---