0056980: 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

0056980

Retail Modules

Retail API

public

2024-11-05 11:55

2024-12-02 11:05

Reporter

hbrasme

Assigned To

jgalarza

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

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

Summary

0056980: 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

Tags

No tags attached.

Relationships

depends on	backport	0057340	RR24Q4	closed	jgalarza	API Product - Error when updating a related product
related to	defect	0058054		closed	Sathishkumar	Import Product: relation of related product inversed