Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0057756 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [POS2] POS | minor | always | 2025-01-24 14:20 | 2025-02-19 10:52 | |||
| Reporter | fermin_ostivar | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | approved | |||||||
| Review Assigned To | ||||||||
| OBNetwork customer | Gold | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0057756: PGSQL Trigger exception not captured in AWO inventory | |||||||
| Description | If 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 Reproduce | Add a trigger for testing purpose on the database Add Product to the inventory on the AWO Front-end | |||||||
| Proposed Solution | Capture the exception and display a popup informing to the customer | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  InventoryTrigger.png [^] (120,775 bytes) 2025-01-24 14:24
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0175443) hgbot (developer) 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 (viewer) 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 (developer) 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 (developer) 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 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2025-01-24 14:20 | fermin_ostivar | New Issue | |
| 2025-01-24 14:20 | fermin_ostivar | Assigned To | => Retail |
| 2025-01-24 14:20 | fermin_ostivar | OBNetwork customer | => Gold |
| 2025-01-24 14:20 | fermin_ostivar | Triggers an Emergency Pack | => No |
| 2025-01-24 14:21 | fermin_ostivar | File Added: InventoryTrigger.png | |
| 2025-01-24 14:22 | fermin_ostivar | File Deleted: InventoryTrigger.png | |
| 2025-01-24 14:24 | fermin_ostivar | File Added: InventoryTrigger.png | |
| 2025-01-26 10:18 | guillermogil | Assigned To | Retail => Triage Omni WMS |
| 2025-01-30 15:26 | mtaal | Assigned To | Triage Omni WMS => AtulOpenbravo |
| 2025-02-07 14:02 | AtulOpenbravo | Status | new => scheduled |
| 2025-02-11 06:03 | hgbot | Merge Request Status | => open |
| 2025-02-11 06:03 | hgbot | Note Added: 0175443 | |
| 2025-02-11 06:10 | AtulOpenbravo | Note Added: 0175444 | |
| 2025-02-11 06:11 | AtulOpenbravo | Note Edited: 0175444 | View Revisions |
| 2025-02-19 10:51 | hgbot | Merge Request Status | open => approved |
| 2025-02-19 10:52 | hgbot | Resolution | open => fixed |
| 2025-02-19 10:52 | hgbot | Status | scheduled => closed |
| 2025-02-19 10:52 | hgbot | Note Added: 0175868 | |
| 2025-02-19 10:52 | hgbot | Note Added: 0175869 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |