Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0048544Retail ModulesRetail APIpublic2022-02-07 18:582022-02-24 16:31
Reportermartinsdan 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionUbuntu 18.04.1 LTS
Product Version 
Target VersionRR20Q3.4Fixed in Version 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0048544: GenericJDBCException on Retail API
DescriptionMessages raised by DB triggers are not visible in the EDL Request window.
Steps To ReproduceFind a product stocked with transactions and try to change it to not stocked via API.

Example:
[{
    "client": "The White Valley Group",
    "organization": "The White Valley Group",
    "id": "19015A9B3ABC4BDBAE9C07C3E7297A27",
    "searchKey": "WVG/T0011",
    "name": "Bivy bag gore-tex",
    "description": "Gore-Tex 3-layer bivy bag.",
    "uom": "EA",
    "productCategory": "Trekking & Camping",
    "taxCategory": "IVA Normal",
    "active": true,
    "productType": "I",
    "generic": false,
    "stocked": false,
    "purchased": true,
    "sold": true,
    "showCharactDesc": true,
    "scale": false,
    "showStock": false,
    "allowAnonymousSale": true,
    "multiSelectable": false,
    "groupedProduct": true,
    "printServices": true,
    "allowDeferredSell": false,
    "linkedToProduct": false,
    "uniquePerDocument": false,
    "priceRuleBased": false,
    "printDescription": false,
    "returnable": true,
    "summaryLevel": false,
    "billOfMaterials": false,
    "printDetailsOnInvoice": false,
    "printDetailsOnPickList": false,
    "verified": false,
    "calculated": false,
    "production": false,
    "quantityVariable": false,
    "discontinued": false,
    "quantityType": false,
    "printPrice": true,
    "volume": 0,
    "weight": 0
  }]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0044598 closed Triage Platform Conn Provide a more detailed error when an import fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-02-07 18:58martinsdanNew Issue
2022-02-07 18:58martinsdanAssigned To => Triage Platform Conn
2022-02-07 18:58martinsdanTriggers an Emergency Pack => No
2022-02-24 15:32alostaleAssigned ToTriage Platform Conn => alostale
2022-02-24 15:32hgbotNote Added: 0135288
2022-02-24 16:25hgbotResolutionopen => fixed
2022-02-24 16:25hgbotStatusnew => resolved
2022-02-24 16:25hgbotNote Added: 0135292
2022-02-24 16:25hgbotNote Added: 0135293
2022-02-24 16:30caristuRelationship addedhas duplicate 0044598
2022-02-24 16:31caristuReview Assigned To => caristu
2022-02-24 16:31caristuStatusresolved => closed

Notes
(0135288)
hgbot   
2022-02-24 15:32   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.externaldata.integration/-/merge_requests/13 [^]
(0135292)
hgbot   
2022-02-24 16:25   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.externaldata.integration [^]
Changeset: 06992c74bf72c65cbaae72bb5bddf299f4f8d0e7
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 24-02-2022 15:25:24
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.externaldata.integration/-/commit/06992c74bf72c65cbaae72bb5bddf299f4f8d0e7 [^]

fixes BUG-48544: generic error in EDL window when SQLException is thrown

When a SQLException is thrown while processing an EDL request, ie. a
trigger raised an error, a generic error message is logged in the EDL
window.

Now we try to get the underlying SQL exception to get the cause of the
problem if it is present. Note in case it includes an error code, it is
already parsed to get the proper message from DB.

---
M src/org/openbravo/externaldata/integration/process/AsynchronousProcessor.java
---
(0135293)
hgbot   
2022-02-24 16:25   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.externaldata.integration/-/merge_requests/13 [^]