Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0057756POS2POSpublic2025-01-24 14:202025-02-19 10:52
Reporterfermin_ostivar 
Assigned ToAtulOpenbravo 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0057756: PGSQL Trigger exception not captured in AWO inventory
DescriptionIf during an inventory a trigger database throws and exception the message is not captured by the front end just informing the customer about and error in Hibernate
"Failed to synchronize: org.hibernate.exception.GenericJDBCException: could not execute batch"
Steps To ReproduceAdd a trigger for testing purpose on the database
Add Product to the inventory on the AWO Front-end
Proposed SolutionCapture the exception and display a popup informing to the customer
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng InventoryTrigger.png (120,775) 2025-01-24 14:24
https://issues.openbravo.com/file_download.php?file_id=20797&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2025-01-24 14:20fermin_ostivarNew Issue
2025-01-24 14:20fermin_ostivarAssigned To => Retail
2025-01-24 14:20fermin_ostivarOBNetwork customer => Gold
2025-01-24 14:20fermin_ostivarTriggers an Emergency Pack => No
2025-01-24 14:21fermin_ostivarFile Added: InventoryTrigger.png
2025-01-24 14:22fermin_ostivarFile Deleted: InventoryTrigger.png
2025-01-24 14:24fermin_ostivarFile Added: InventoryTrigger.png
2025-01-26 10:18guillermogilAssigned ToRetail => Triage Omni WMS
2025-01-30 15:26mtaalAssigned ToTriage Omni WMS => AtulOpenbravo
2025-02-07 14:02AtulOpenbravoStatusnew => scheduled
2025-02-11 06:03hgbotMerge Request Status => open
2025-02-11 06:03hgbotNote Added: 0175443
2025-02-11 06:10AtulOpenbravoNote Added: 0175444
2025-02-11 06:11AtulOpenbravoNote Edited: 0175444bug_revision_view_page.php?bugnote_id=0175444#r29232
2025-02-19 10:51hgbotMerge Request Statusopen => approved
2025-02-19 10:52hgbotResolutionopen => fixed
2025-02-19 10:52hgbotStatusscheduled => closed
2025-02-19 10:52hgbotNote Added: 0175868
2025-02-19 10:52hgbotNote Added: 0175869

Notes
(0175443)
hgbot   
2025-02-11 06:03   
Merge Request created: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/365 [^]
(0175444)
AtulOpenbravo   
2025-02-11 06:10   
(edited on: 2025-02-11 06:11)
Test Plan

- Create a Message in using System Administrator role in Back Office with key "ERROR_UPDATING_LINE" and message text "Error while updating product in inventory line".

- Create the trigger as in the Notes above.

- Login into AWO Front End using AWOQAAdmin

- Create a inventory count for any product and try to update the quantity as 2.

- Realize that error is shown as: Failed to synchronize: Error while updating product in inventory line
(0175868)
hgbot   
2025-02-19 10:52   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: 741b82e48742f4aa8505c49d163065b2f46bd59d
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 19-02-2025 09:52:46
URL: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/741b82e48742f4aa8505c49d163065b2f46bd59d [^]

Fixes ISSUE-0057756: PGSQL Trigger exception not captured in AWO inventory

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/processors/InventoryCountCheckUnAssignedOrCancelled.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/processors/SynchronizableDocumentProcessor.java
---
(0175869)
hgbot   
2025-02-19 10:52   
Merge request merged: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/365 [^]