0057340: API Product - Error when updating a related product

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0057340

Retail Modules

Retail API

public

2024-11-05 11:55

2024-12-02 13:31

Reporter

hbrasme

Assigned To

jgalarza

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

RR24Q4

Fixed 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 Pack

Summary

0057340: API Product - Error when updating a related product

Description

Following the implementation of contributions, management is carried out through the related product and the multiplier field.

However, this field must be able to be updated when the contribution is revised

Currently when I want to update a multiplier I get the error message below:

ERROR: duplicate key value violates unique constraint "m_product_service_prod"
Detail: Key (m_product_id, m_related_product_id)=(358807CC49444D5DB82C0FD66AE7F678, 7A763395EA494A13B0D5FF4D920B48DF) already exists

Steps To Reproduce

Create a related product to a contribution like that :

[
   {
      "client":"TERRENA",
      "organization":"*",
      "searchKey":"Contribution RPD",
      "relatedProducts":[{
         "product":"1200900",
         "multiplicator":1.14,
         "active":true
         }
      ]
   }

]

Try to change the multiplicator field (Put 1.25 instead of 1.14) :

[
   {
      "client":"TERRENA",
      "organization":"*",
      "searchKey":"Contribution RPD",
      "relatedProducts":[{
         "product":"1200900",
         "multiplicator":1.25,
         "active":true
         }
      ]
   }

]

Proposed Solution

It would be necessary to be able to update the related products if they already exist.

Additional Information