Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0049492
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Multi UPC/EAN for Productmajorhave not tried2022-06-07 07:062022-07-25 08:57
ReporteralostaleView Statuspublic 
Assigned Toranjith_qualiantech_com 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0049492: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
caused by defect 0046167 closedranjith_qualiantech_com The "Multi UPC/EAN for Products" module does not recalculate the EM_Obmupc_Multiupc_Desc field 

-  Notes
(0139220)
hgbot (developer)
2022-07-11 07:39

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/merge_requests/16 [^]
(0139221)
hgbot (developer)
2022-07-11 07:39

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc/-/merge_requests/3 [^]
(0139567)
hgbot (developer)
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 (developer)
2022-07-25 08:57

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/merge_requests/16 [^]
(0139569)
hgbot (developer)
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 (developer)
2022-07-25 08:57

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc/-/merge_requests/3 [^]

- Issue History
Date Modified Username Field Change
2022-06-07 07:06 alostale New Issue
2022-06-07 07:06 alostale Assigned To => Retail
2022-06-07 07:06 alostale OBNetwork customer => No
2022-06-07 07:06 alostale Regression level => Production - Confirmed Stable
2022-06-07 07:06 alostale Regression date => 2021-04-08
2022-06-07 07:06 alostale Regression introduced in release => RR21Q3
2022-06-07 07:06 alostale Regression introduced by commit => https://gitlab.com/openbravo/product/pmods/org.openbravo.multiupc/-/commit/867ca62708d566bbe4ee0c695665df0f98e462aa [^]
2022-06-07 07:06 alostale Triggers an Emergency Pack => No
2022-06-07 07:06 alostale Relationship added caused by 0046167
2022-07-07 11:54 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2022-07-07 12:17 ranjith_qualiantech_com Status new => scheduled
2022-07-11 07:39 hgbot Merge Request Status => open
2022-07-11 07:39 hgbot Note Added: 0139220
2022-07-11 07:39 hgbot Note Added: 0139221
2022-07-25 08:57 hgbot Merge Request Status open => approved
2022-07-25 08:57 hgbot Resolution open => fixed
2022-07-25 08:57 hgbot Status scheduled => closed
2022-07-25 08:57 hgbot Note Added: 0139567
2022-07-25 08:57 hgbot Note Added: 0139568
2022-07-25 08:57 hgbot Note Added: 0139569
2022-07-25 08:57 hgbot Note Added: 0139570


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker