Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049492Retail ModulesMulti UPC/EAN for Productpublic2022-06-07 07:062022-07-25 08:57
Reporteralostale 
Assigned Toranjith_qualiantech_com 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerNo
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2021-04-08
Regression introduced in releaseRR21Q3
Regression introduced by commithttps://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc/-/commit/867ca62708d566bbe4ee0c695665df0f98e462aa [^]
Triggers an Emergency PackNo
Summary0049492: cannot install org.openbravo.multiupc without retail
Descriptionorg.openbravo.multiupc declares dependency only in Openbravo 3 Framework, but it is not possible to install without retail as it depends on an AD_Element defined in Retail Configuration module.
Steps To Reproduce1. In a clean Openbravo core instance install org.openbravo.multiupc
  [createdatabase] 82451 [main] ERROR org.apache.ddlutils.DatabaseOperationException - Error while executing SQL -- END
[createdatabase] ALTER TABLE AD_PROCESS_PARA
[createdatabase] ADD CONSTRAINT AD_PROCESS_PARA_AD_ELEMENT FOREIGN KEY (AD_ELEMENT_ID) REFERENCES AD_ELEMENT (AD_ELEMENT_ID)
[createdatabase] org.postgresql.util.PSQLException: ERROR: insert or update on table "ad_process_para" violates foreign key constraint "ad_process_para_ad_element"
[createdatabase] Detail: Key (ad_element_id)=(8DE5963A8C4C42D881FE155384B7D5E0) is not present in table "ad_element".
[createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675) ~[postgresql-42.3.3.jar:42
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by defect 0046167 closed ranjith_qualiantech_com The "Multi UPC/EAN for Products" module does not recalculate the EM_Obmupc_Multiupc_Desc field 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-06-07 07:06alostaleNew Issue
2022-06-07 07:06alostaleAssigned To => Retail
2022-06-07 07:06alostaleOBNetwork customer => No
2022-06-07 07:06alostaleRegression level => Production - Confirmed Stable
2022-06-07 07:06alostaleRegression date => 2021-04-08
2022-06-07 07:06alostaleRegression introduced in release => RR21Q3
2022-06-07 07:06alostaleRegression introduced by commit => https://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc/-/commit/867ca62708d566bbe4ee0c695665df0f98e462aa [^]
2022-06-07 07:06alostaleTriggers an Emergency Pack => No
2022-06-07 07:06alostaleRelationship addedcaused by 0046167
2022-07-07 11:54ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2022-07-07 12:17ranjith_qualiantech_comStatusnew => scheduled
2022-07-11 07:39hgbotMerge Request Status => open
2022-07-11 07:39hgbotNote Added: 0139220
2022-07-11 07:39hgbotNote Added: 0139221
2022-07-25 08:57hgbotMerge Request Statusopen => approved
2022-07-25 08:57hgbotResolutionopen => fixed
2022-07-25 08:57hgbotStatusscheduled => closed
2022-07-25 08:57hgbotNote Added: 0139567
2022-07-25 08:57hgbotNote Added: 0139568
2022-07-25 08:57hgbotNote Added: 0139569
2022-07-25 08:57hgbotNote Added: 0139570

Notes
(0139220)
hgbot   
2022-07-11 07:39   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/merge_requests/16 [^]
(0139221)
hgbot   
2022-07-11 07:39   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc/-/merge_requests/3 [^]
(0139567)
hgbot   
2022-07-25 08:57   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc [^]
Changeset: 9c15ddffdf8da7444fae75188bb549f9eb423289
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 11-07-2022 11:06:51
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/commit/9c15ddffdf8da7444fae75188bb549f9eb423289 [^]

Fixed ISSUE-49492: Updated UpdateUPCDescription process from multiupc module

---
A src-db/database/sourcedata/AD_MENU.xml
A src-db/database/sourcedata/AD_MODEL_OBJECT.xml
A src-db/database/sourcedata/AD_PROCESS.xml
A src-db/database/sourcedata/AD_PROCESS_PARA.xml
A src-db/database/sourcedata/AD_TREENODE.xml
A src/org/openbravo/retail/multiupc/process/UpdateProductUPCDescription.java
---
(0139568)
hgbot   
2022-07-25 08:57   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/merge_requests/16 [^]
(0139569)
hgbot   
2022-07-25 08:57   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc [^]
Changeset: 9cf68f5f9d52e8c31f1b8c00fe55a0534d1b7a47
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 11-07-2022 11:06:12
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc/-/commit/9cf68f5f9d52e8c31f1b8c00fe55a0534d1b7a47 [^]

Related to ISSUE-49492: Moved UpdateUPCDescription process to retail multiupc module

---
R src-db/database/sourcedata/AD_MENU.xml
R src-db/database/sourcedata/AD_MODEL_OBJECT.xml
R src-db/database/sourcedata/AD_PROCESS.xml
R src-db/database/sourcedata/AD_PROCESS_PARA.xml
R src-db/database/sourcedata/AD_TREENODE.xml
R src/org/openbravo/multiupc/process/UpdateProductUPCDescription.java
---
(0139570)
hgbot   
2022-07-25 08:57   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc/-/merge_requests/3 [^]