Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0048544
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Retail APIminoralways2022-02-07 18:582022-02-24 16:31
ReportermartinsdanView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget VersionRR20Q3.4
OSLinux 64 bitDatabasePostgreSQLJava version11
OS VersionUbuntu 18.04.1 LTSDatabase version10.10Ant version1.10.5
Product VersionSCM revision 
Review Assigned Tocaristu
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0048544: 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
  }]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
has duplicate defect 0044598 closedTriage Platform Conn Provide a more detailed error when an import fails 

-  Notes
(0135288)
hgbot (developer)
2022-02-24 15:32

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.externaldata.integration/-/merge_requests/13 [^]
(0135292)
hgbot (developer)
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 (developer)
2022-02-24 16:25

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.externaldata.integration/-/merge_requests/13 [^]

- Issue History
Date Modified Username Field Change
2022-02-07 18:58 martinsdan New Issue
2022-02-07 18:58 martinsdan Assigned To => Triage Platform Conn
2022-02-07 18:58 martinsdan Triggers an Emergency Pack => No
2022-02-24 15:32 alostale Assigned To Triage Platform Conn => alostale
2022-02-24 15:32 hgbot Note Added: 0135288
2022-02-24 16:25 hgbot Resolution open => fixed
2022-02-24 16:25 hgbot Status new => resolved
2022-02-24 16:25 hgbot Note Added: 0135292
2022-02-24 16:25 hgbot Note Added: 0135293
2022-02-24 16:30 caristu Relationship added has duplicate 0044598
2022-02-24 16:31 caristu Review Assigned To => caristu
2022-02-24 16:31 caristu Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker