Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0053912Retail ModulesRetail APIpublic2023-11-10 13:472024-01-25 05:59
Reporteralfonso_alcalde 
Assigned ToSABARINATH P 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0053912: API PriceList ERROR updating inactive product
DescriptionWhen trying to update inactive products in a price list through the Price List API, an error occurs, "duplicate key value violates unique constraint", as it tries to insert the already existing product.
Steps To Reproduce1- Locate in the backoffice, or insert a pricelist with any product from the backoffice or through the API.

2- Via PriceList API, deactivate the product.

2.2- In our project we have the "IsActive" field visible in the ProductPrice tab, so we can check the inactive status resulting from the previous step.

3- Resend any update via API of that product in the PriceList.

4- Check the error in EDL Request.

ERROR: duplicate key value violates unique constraint "m_productprice_pricelist_ve_un".
 
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0055222 closed alostale Price API - importing price for deactivated product 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-11-10 13:47alfonso_alcaldeNew Issue
2023-11-10 13:47alfonso_alcaldeAssigned To => Triage Platform Conn
2023-11-10 13:47alfonso_alcaldeTriggers an Emergency Pack => No
2023-11-10 13:49alfonso_alcaldeNote Added: 0157042
2023-11-10 13:53marvintmAssigned ToTriage Platform Conn => Retail
2023-11-10 13:53marvintmDescription Updatedbug_revision_view_page.php?rev_id=27105#r27105
2023-11-10 13:53marvintmSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=27107#r27107
2023-11-15 06:00SABARINATH PAssigned ToRetail => SABARINATH P
2023-11-15 08:03SABARINATH PStatusnew => scheduled
2023-11-17 06:06hgbotNote Added: 0157262
2023-11-20 07:29hgbotResolutionopen => fixed
2023-11-20 07:29hgbotStatusscheduled => closed
2023-11-20 07:29hgbotNote Added: 0157322
2023-11-20 07:29hgbotNote Added: 0157323
2023-11-20 09:39hgbotNote Added: 0157332
2024-01-25 05:59elijahnelsonNote Added: 0159746
2024-09-09 10:29alostaleRelationship addedrelated to 0055222

Notes
(0157042)
alfonso_alcalde   
2023-11-10 13:49   
https://drive.google.com/file/d/1-VYPWSfrv0VBpi8mcYQgRqmTmF7oY7U2/view?usp=sharing [^]
(0157262)
hgbot   
2023-11-17 06:06   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.commercialoperations.api/-/merge_requests/6 [^]
(0157322)
hgbot   
2023-11-20 07:29   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.commercialoperations.api [^]
Changeset: 85bb66d5f9eaa69ceb7e2b111cf5348aea0e6c31
Author: Sabarinath <sabarinath.palanisamy.ext@openbravo.com>
Date: 16-11-2023 15:52:58
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.commercialoperations.api/-/commit/85bb66d5f9eaa69ceb7e2b111cf5348aea0e6c31 [^]

Fixed ISSUE-53912: Handled error while updating pricelist via API

---
M src/org/openbravo/commercialoperations/api/hook/productPriceException/ProductPriceBaseOBObjectFetcher.java
---
(0157323)
hgbot   
2023-11-20 07:29   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.commercialoperations.api/-/merge_requests/6 [^]
(0157332)
hgbot   
2023-11-20 09:39   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/customers/saboraespana/snapshots [^]
Changeset: 5ff171fedd7fe0ddaf049573a4778c6c176d8edd
Author: Alfonso Alcalde Elorz <alfonso.alcalde@openbravo.com>
Date: 20-11-2023 09:39:01
URL: https://gitlab.com/openbravo/customers/saboraespana/snapshots/-/commit/5ff171fedd7fe0ddaf049573a4778c6c176d8edd [^]

Update Snapshot_Dev_23Q4, Fixed ISSUE-53912
---
M delivery/dev/Snapshot_Dev_23Q4
---
(0159746)
elijahnelson   
2024-01-25 05:59   
You can query the database directly or use relevant APIs or tools provided by your system to verify the existing records.
https://mapquestdrivingdirections.io [^]