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 
Review Assigned To
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 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 Note Added: 0139220
2022-07-11 07:39 hgbot Note Added: 0139221
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