Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0055312Retail ModulesRetail APIpublic2024-04-25 11:022024-05-17 09:29
ReporterAgatheBertin 
Assigned ToSABARINATH P 
PrioritynormalSeveritymajorReproducibilityhave not tried
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
Summary0055312: PRODUCT API - BOM - lineNo not set as mandatory but SQL error
DescriptionWhen trying to import a BOM in the product API, the lineNo is not set as mandatory, but there is a SQL error

[{"client":"*","organization":"*","searchKey":"416720ABE","name":"chlore choc 1kg","description":"CHLORE CHOC 1KG PASTILLE 25G","upcEAN":"3491954167203ABE","uom":"Unit","productCategory":"Éclairage extérieur","taxCategory":"TVA normale","active":true,"productType":"I","generic":false,"stocked":true,"purchased":true,"billOfMaterials":true,"sold":true,"showCharactDesc":true,"scale":false,"showStock":true,"allowAnonymousSale":true,"groupedProduct":true,"deliveryModeInLayaway":"PickAndCarry","deliveryMode":"PickAndCarry","printDescription":true,"returnable":true,"volume":0,"weight":0,"editablePrice":true,"multiUPC":[{"code":"416721ABE","active":true}],"bom":[{"product":"014533","quantity":2},{"product":"182496","quantity":1,"price":10,"active":true,"lineNo":20}]}]
Steps To Reproduce- integrate a product with a BOM
- don't put the lineNo
- SQL error

ERROR: null value in column "line" violates not-null constraint
  Detail: Failing row contains (AB4EAAE982384443BD430103525BCF5B, 4AE32048B2F94E31B7E3F4EBCE923ECF, 0, Y, 2024-04-25 10:57:02.144, 6AF38E864DC94EA09599C9132663D139, 2024-04-25 10:57:02.144, 6AF38E864DC94EA09599C9132663D139, null, 2CE229BA7B974DA99CA2A36A5A9A5DC2, A608B9A177A941D4B1AFA0D3C64787BE, 2, null, P, null).
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng 2024-04-25_11h00_50.png (6,869) 2024-04-25 11:02
https://issues.openbravo.com/file_download.php?file_id=19701&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2024-04-25 11:02AgatheBertinNew Issue
2024-04-25 11:02AgatheBertinAssigned To => Triage Platform Conn
2024-04-25 11:02AgatheBertinFile Added: 2024-04-25_11h00_50.png
2024-04-25 11:02AgatheBertinTriggers an Emergency Pack => No
2024-04-25 13:28adrianromeroAssigned ToTriage Platform Conn => Retail
2024-04-26 09:14jorgewederagoStatusnew => acknowledged
2024-04-30 06:55SABARINATH PAssigned ToRetail => SABARINATH P
2024-04-30 06:55SABARINATH PStatusacknowledged => scheduled
2024-05-06 10:36hgbotNote Added: 0164100
2024-05-08 07:10hgbotNote Added: 0164303
2024-05-08 07:13hgbotNote Added: 0164304
2024-05-08 07:13SABARINATH PNote Deleted: 0164303
2024-05-08 07:14SABARINATH PNote Deleted: 0164100
2024-05-17 09:29hgbotResolutionopen => fixed
2024-05-17 09:29hgbotStatusscheduled => closed
2024-05-17 09:29hgbotNote Added: 0164737
2024-05-17 09:29hgbotNote Added: 0164738

Notes
(0164304)
hgbot   
2024-05-08 07:13   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/267 [^]
(0164737)
hgbot   
2024-05-17 09:29   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: 5b9ab734d6604f82313ad3d2d97ac162a94a5227
Author: Sabarinath <sabarinath.palanisamy.ext@openbravo.com>
Date: 17-05-2024 07:23:43
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/5b9ab734d6604f82313ad3d2d97ac162a94a5227 [^]

Fixed ISSUE-55312: Updated lineNo in BOM not to accept null values(makes it mandatory.

---
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---
(0164738)
hgbot   
2024-05-17 09:29   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/267 [^]